Copy Page

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account. You can also Sign Up for a new account.

<table class="wysiwyg-macro" data-macro-name="excerpt" data-macro-parameters="atlassian-macro-output-type=BLOCK|hidden=true" style="background-image: url(/plugins/servlet/confluence/placeholder/macro-heading?definition=e2V4Y2VycHQ6aGlkZGVuPXRydWV8YXRsYXNzaWFuLW1hY3JvLW91dHB1dC10eXBlPUJMT0NLfQ&amp;locale=en_GB&amp;version=2); background-repeat: no-repeat;" data-macro-body-type="RICH_TEXT"><tr><td class="wysiwyg-macro-body">supported types and conversions in Java, VB6, and VB.NET </td></tr></table> 
The following table summarizes the equivalent types between Scriptom and COM (VB6/VBA/.NET). 
 
<table class="confluenceTable"><tbody>
<tr>
<th class="confluenceTh"> Groovy/Java </th>
<th class="confluenceTh"> VB6/VBA </th>
<th class="confluenceTh"> VB.NET </th>
<th class="confluenceTh"> Comments </th>
</tr>
<tr>
<td class="confluenceTd"> null </td>
<td class="confluenceTd"> Empty/Nothing </td>
<td class="confluenceTd"> Empty/Nothing </td>
<td class="confluenceTd"> </td>
</tr>
<tr>
<td class="confluenceTd"> VariantNull </td>
<td class="confluenceTd"> Null </td>
<td class="confluenceTd"> ??? </td>
<td class="confluenceTd"> VariantNull is not the same as Java null. Use Scriptom.NULL. </td>
</tr>
<tr>
<td class="confluenceTd"> boolean </td>
<td class="confluenceTd"> Boolean </td>
<td class="confluenceTd"> Boolean </td>
<td class="confluenceTd"> </td>
</tr>
<tr>
<td class="confluenceTd"> byte </td>
<td class="confluenceTd"> Byte </td>
<td class="confluenceTd"> Byte/SByte </td>
<td class="confluenceTd"> 8-bit signed or unsigned integer. 0 to 255 in the COM library. -128 to 127 in Java. Conversion happens automatically. </td>
</tr>
<tr>
<td class="confluenceTd"> short </td>
<td class="confluenceTd"> Integer </td>
<td class="confluenceTd"> Short </td>
<td class="confluenceTd"> 16-bit signed integer. -32,768 to 32,767. </td>
</tr>
<tr>
<td class="confluenceTd"> (int) </td>
<td class="confluenceTd"> - </td>
<td class="confluenceTd"> UShort </td>
<td class="confluenceTd"> 16-bit unsigned integer. 0 to 65,535. </td>
</tr>
<tr>
<td class="confluenceTd"> int </td>
<td class="confluenceTd"> Long </td>
<td class="confluenceTd"> Integer </td>
<td class="confluenceTd"> 32-bit signed integer. -2,147,483,648 to 2,147,483,647. </td>
</tr>
<tr>
<td class="confluenceTd"> (long) </td>
<td class="confluenceTd"> - </td>
<td class="confluenceTd"> UInteger </td>
<td class="confluenceTd"> 32-bit unsigned integer. 0 to 4,294,967,295. </td>
</tr>
<tr>
<td class="confluenceTd"> long </td>
<td class="confluenceTd"> - </td>
<td class="confluenceTd"> Long </td>
<td class="confluenceTd"> 64-bit signed integer. -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807. 64-bit integers are not supported by COM in Windows Millenium or Windows 2000 and earlier. </td>
</tr>
<tr>
<td class="confluenceTd"> (BigInteger) </td>
<td class="confluenceTd"> - </td>
<td class="confluenceTd"> ULong </td>
<td class="confluenceTd"> 64-bit unsigned integer. 0 to 18,446,744,073,709,551,615. 64-bit integers are not supported by COM in Windows Millenium or Windows 2000 and earlier. </td>
</tr>
<tr>
<td class="confluenceTd"> float </td>
<td class="confluenceTd"> Single </td>
<td class="confluenceTd"> Single </td>
<td class="confluenceTd"> Low-precision floating point. -3.402823E38 to -1.401298E-45 for negative values; 1.401298E-45 to 3.402823E38 for positive values. </td>
</tr>
<tr>
<td class="confluenceTd"> double </td>
<td class="confluenceTd"> Double </td>
<td class="confluenceTd"> Double </td>
<td class="confluenceTd"> High-precision floating point. The range of a Double is -1.79769313486231E308 to -4.94065645841247E-324 for negative values; 4.94065645841247E-324 to 1.79769313486232E308 for positive values. </td>
</tr>
<tr>
<td class="confluenceTd"> BigDecimal </td>
<td class="confluenceTd"> - </td>
<td class="confluenceTd"> Decimal </td>
<td class="confluenceTd"> High-precision fixed/floating point (96 bits plus scaling), but without the large mantissa values supported by Double. Scriptom supports the Currency data type by converting to and from Decimal. The range of a Decimal is +/-79,228,162,514,264,337,593,543,950,335 
for zero-scaled numbers (that is, numbers with no decimal places). For numbers with 28 decimal places, the range is +/-7.9228162514264337593543950335. The smallest possible non-zero number is 0.0000000000000000000000000001. BigDecimal values with greater precision than Decimal supports are automatically rounded. </td>
</tr>
<tr>
<td class="confluenceTd"> BigDecimal </td>
<td class="confluenceTd"> Currency </td>
<td class="confluenceTd"> - </td>
<td class="confluenceTd"> Numbers from -922,337,203,685,477.5808 to 922,337,203,685,477.5807, with a fixed decimal point. Scriptom handles Currency values internally as type Decimal. </td>
</tr>
<tr>
<td class="confluenceTd"> Date </td>
<td class="confluenceTd"> Date </td>
<td class="confluenceTd"> Date </td>
<td class="confluenceTd"> </td>
</tr>
<tr>
<td class="confluenceTd"> String </td>
<td class="confluenceTd"> String </td>
<td class="confluenceTd"> String </td>
<td class="confluenceTd"> </td>
</tr>
<tr>
<td class="confluenceTd"> SafeArray </td>
<td class="confluenceTd"> Array </td>
<td class="confluenceTd"> Array </td>
<td class="confluenceTd"> Scriptom supports multi-dimensional arrays for COM. </td>
</tr>
<tr>
<td class="confluenceTd"> ActiveXObject </td>
<td class="confluenceTd"> A COM-callable object </td>
<td class="confluenceTd"> A COM-callable object </td>
<td class="confluenceTd"> </td>
</tr>
</tbody></table>

Note that implicit type conversions are supported, so you could - for instance - pass a float to a method that expects a double.  COM unsigned integer types are converted to the next largest Java signed equivalent integer type so that large positive values do not cause overflows.

<img class="emoticon emoticon-warning" data-emoticon-name="warning" border="0" src="/s/en_GB/3278/15/_/images/icons/emoticons/warning.png" alt="(warning)" title="(warning)" /> CAUTION: The default floating-point type in Groovy is BigDecimal, which gets converted to a COM Decimal.  Although Decimal will work in the majority of cases, type conversions involving Decimal are inefficient compared to other numeric types.  It is a good idea to explicitly coerce Decimal values to type Double or type Integer, whichever makes the most sense.  Also note that Decimal does not handle the types of large mantissas that type Double can, but it supports more precision.