We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Aspose.Cells ImportTwoDimensionArray Column Limitation


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


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?


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