Defines the value of the cells in the selection via an array of decimal values.
If the number of values provided is less than the number of selected cells, the function loops on the array.
Please note that although the function accepts any input definition XlsxToolBx works internally in double-precision floating-point format.
This means that numericals with higher than 15-digit precision will be rounded off.
Parameters
workbookHandle |
NUM_BIN_4 |
Workbook handle. |
selection |
ALPHA(n) |
Cell ranges processed. |
values(n) |
NUM_E(x,y) |
Array of values to be inserted. |
length |
NUM_BIN_2 |
Accuracy of the array items. |
scale |
NUM_BIN_2 |
Number of decimal places of the array items. |
nbValues |
NUM_BIN_4 |
Number of values array items. |
rc |
NUM_BIN_4 |
Function return code (see Error codes constants).
Output parameter. |
List of XlsxToolBx DLL functions - Selection class