Below is a list of data types accepted by Excel. The entries in the Argument and Result columns indicate whether the data type is supported by the Wizard as an argument to an add-in and a result, respectively.
Code | Name | 'C' Type | Argument | Result | Description |
---|---|---|---|---|---|
A | Boolean | BOOL | Yes | Yes | Boolean value as a 32-bit integer. 1 for true, 0 for false. |
B | Double | double | Yes | Yes | 8-byte double-precision floating point number. |
C | String | const char* | Yes | No | String of ASCII characters, maximum length 255. The length of the string is contained in the first byte. |
H | Unsigned short integer | USHORT | Yes | Yes | Unsigned 16-bit integer. |
I | Signed short integer | short | Yes | Yes | Signed 16-bit integer. |
J | Signed long integer | long | Yes | Yes | Signed 32-bit integer. |
K | Floating point number array | XLARRAY | Yes | No | Array of 8-byte numbers in an XLARRAY structure. |
P | COper | COper | Yes | No | Excel COper type. More... |
R | CXlOper | CXlOper | Yes | Yes | Excel CXlOper type. More... |
Below is a list of data types contained within the COper class. The Enumeration column contains the value of the type member of COper. The method whose name listed in the Test column can be used to determine if the COper is of the given type.
Name | Enumeration | 'C' Type | Test | Description |
---|---|---|---|---|
Boolean | xlotypeBool | short int | IsBool() | Boolean value as a 16-bit integer. 1 for true, 0 for false. |
Double | xlotypeNum | double | IsDouble() | 8-byte double-precision floating point number. |
String | xlotypeStr | char* | IsString() | String of ASCII characters, maximum length 255. The length of the string is contained in the first byte. |
Error | xlotypeErr | short int | IsError() | Error code. See error codes for a full list. |
Array | xlotypeMulti | Array structure | IsArray() | Structure containing a pointer to an array of COper, a column count and a row count. |
Missing | xlotypeMissing | IsMissing() | No value was provided; the argument is missing. |
Below is a list of data types contained within the CXlOper class. The Enumeration column contains the value of the xltype member of CXlOper. The method whose name listed in the Test column can be used to determine if the CXlOper is of the given type.
Name | Enumeration | 'C' Type | Test | Description |
---|---|---|---|---|
Boolean | xltypeBool | short int | IsBool() | Boolean value as a 16-bit integer. 1 for true, 0 for false. |
Double | xltypeNum | double | IsDouble() | 8-byte double-precision floating point number. |
String | xltypeStr | char* | IsString() | String of ASCII characters, maximum length 255. The length of the string is contained in the first byte. |
Error | xltypeErr | short int | IsError() | Error code. See error codes for a full list. |
Array | xltypeMulti | Array structure | IsArray() | Structure containing a pointer to an array of COper, a column count and a row count. |
Missing | xltypeMissing | IsMissing() | No value was provided; the argument is missing. | |
Reference | xltypeSRef | CXlRef | IsSRef() | Structure describing an Excel rectangular cell range. |
Multi-reference | xltypeMRef | CXlRef* | IsMRef() | Structure describing one or more Excel rectangular cell ranges. |
Empty | 0 | IsEmpty() | Unused or uninitialized value. |