Aspose.Cells ImportTwoDimensionArray Column Limitation

Hi,

I am using the latest version of Aspose.Cells .NET to create a worksheet with 460 columns and about 500 rows. When I use ImportTwoDimensionArray to insert the data only the columns up to IV are inserted. Is this a limitation of the function or is it a bug?

Thanks, Randy

Hi,

No, it's not a bug, we limit this feature currently. We will support it for Excel2007 .xlsx file soon.

Thank you.

It seems to be working when I use ImportDataTable. Are there any major differences in performance in these two functions?

Hi,

Please try this fix.

In this fix,we use Cell.GetStyle and SetStyle method replace the property of Cell.Style. The two methods will save more memory usage than cell.Style property.

If you want to set style of the cell, please change your codes as :

//Getting the style of the cell.

Style style = cell.GetStyle();

//Setting the property of the style.

.......

//Setting the style of the cell

cell.SetStyle(style);