obtains the data for the active range of cells selected
Usage:
xlsData (object me )
Parameters:
None
Returns:
list2D ( list of lists ) A 2 dimension list with the inner list containing the data for the row and the outer list holding individual list for each column
Example:
xtRose = xtra("Rosetta").new( )
xtRose.xlsLaunch( )
xtRose.xlsOpen( "C:\myCalculations.xls", EMPTY )
xtRose.xlsSetRange( 1, 1, 5, 3 )
list2Ddata = xtRose.xlsData( )
Notes:
The 3 director data types supported in Excel are strings, integers and float. All value in Excel that does not use these data type will be converted to a Director string ( for example data values ). The returned list dimension will equal to the range ( width and height ) selected.