I just started evaluating ASPOSE.CELLS for .Net.
I need to paint multiple column and row in excel using array of data.
I found one funtion which supports multile row and columns.
worksheet.Cells.ImportArray(DataArray, 1, 1)
DataArray can have any no of row and columns. But this function supports only string, double and int data types.
I need to paint data in excel sheet with different data types in one array
Means I want to use object type array in which I can put any data type in any cell (row, column) and can paint entire sheet in one go.
for example date, int, string, double
Is there any other method in ASPOSE.CELLS which i can use instead of ImportArray function. or can you extend this function to support object data types.
Please refer below article
Use Automation to Transfer an Array of Data to a Range on a Worksheet
given in above page http://support.microsoft.com/kb/306023