Object data types support for worksheet.Cells.ImportArray

Aspose.Cells Product Family
1

Hi
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

Regards

Surendra

2

Hi,


I think you may try Cells.ImportCustomObjects() method for your need, see the topic for reference:
http://docs.aspose.com/display/cellsnet/Importing+Data+to+Worksheets



Thank you.
3

Thanks Amjad Sahi,

It works , I used

ImportTwoDimensionArray.

4

That’s good news,


Have a good day!