Free Support Forum - aspose.com

Problem in Cells.exportcells

When i am trying to get the formula field it returns the worng value in the array. Below is my code when i am using workbook.calculateformula function it hangs the application.

Workbook objworkbook = new Workbook();

object[,] objArray;

objworkbook.Open("D:\\Desktop\\ee758372-6264-44e0-b4b2-087f79707787201004010606034800.xlsx", FileFormatType.Excel2007Xlsx);

Worksheet ws = objworkbook.Worksheets["Measure Units"];

Range rg = ws.Cells.CreateRange("l2", "P2");

objArray = ws.Cells.ExportArray(rg.FirstRow, rg.FirstColumn, rg.RowCount, rg.ColumnCount);

Please help me on this. I am planning to buy this software

Hi,

Could you post your template excel file here and point out which cell’s value is wrongly exported to the array. We will check it soon.

Thank you.