Index Out of range -Value must beb nonnegative Exception

Aspose.Cells Product Family
1

Hi,

I am using Aspose.Cell version 8.3.1.0 licensed version.

I am trying to generate excel report from datatable.
It has 2115 rows and 604 columns.

The Error is thrown in the Line 1 shown below(highlighted) while initializing Cells.


Cells cells = objFrameworkExcel.Excel.Worksheets[intTable].Cells;
cells.MemorySetting = MemorySetting.MemoryPreference; objFrameworkExcel.Excel.Worksheets[intTable].Cells.ImportDataTable(dstFormatedData.Tables[intTable], true, “A1”);

Note: objFrameworkExcel is my class object

Please let me know the solution to overcome this exception

Thanks
Raghu
2

Hi Raghu,

Thanks for your posting and using Aspose.Cells.

Your code looks good. However, we cannot test and replicate it until you provide us some sample preferably console application replicating this issue. Please provide the needful so that we test it at our end and log it in our database for a fix.

Please also check if you remove MemoryPreference setting, then does it work or not?

Let us know your feedback.