-
Notifications
You must be signed in to change notification settings - Fork 0
cDataTable.AsArray
Brendon edited this page Mar 17, 2024
·
1 revision
AsArray
returns Variant array
accepts Optional Variant
To transfer a cDataTable back to Excel it first must be converted into an array using this function.
If you don't want to output the header record with the field names you should pass a value of True to the method.
The method then builds a Variant array out of the data in the cDataTable
This array can easily be placed into a range in Excel.
See also: cDataTable.LoadArray, cDataFactory.InsertDataTableToCell