Can't read Pivot Table from document in *.xlsb format

Aspose.Cells Product Family
1
I've created a simple document with Pivot Table in *.xlsb format.
I tried to read this document with Aspose.Cells, but no Pivot Tables were found in the document.

Workbook wb = new Workbook(fName);
foreach(Worksheet ws in wb.Worksheets)
{
printLine(ws.Name, string.Empty, SPACE0); // my inner printing method
foreach(PivotTable pt in ws.PivotTables)
{
try { pt.RefreshData(); }
catch { }
try { pt.CalculateData(); }
catch { }
try { pt.CalculateRange(); }
catch { }

printLine(pt.Name, string.Empty, SPACE1);
}
}
I am using Excel 2010 and Aspose.Cells 7.0.4.1.

Can you also add "xlsb" extension to your forum upload filter? Because it's not allowed extension.

Thank you,
Alex Shloma
2
Hi,

I can find the issue as you have mentioned using your template XLSB file with the simple code below:
Workbook workbook = new Workbook("e:\\test2\\AsposePivotXLSB.xlsb");
MessageBox.Show(workbook.Worksheets["Sheet2"].PivotTables.Count.ToString()); //0
//PivotTable pt = workbook.Worksheets[1].PivotTables[0];
//string name = pt.Name;

I have logged a ticket with an id: CELLSNET-40212. We will look into it soon.

Thank you.
3

Hi,

We will support reading/writing pivottable in xlsb format next year.

4

Hi,

Thanks for using Aspose.Cells for .NET

Please download and try this fix: Aspose.Cells for .NET v7.3.4.2 and let us know your feedback.

We have supported reading pivot table for xlsb in this latest version.


We will support writing pivot table for xlsb later. We have logged a separate ticket for this issue with the id: CELLSNET-41226.

Once, we will have some update for you relating to it, we will let you know asap.

5

Thank you!


I will check this soon and will let you know.

Best regards,
Alex Shloma
6

The issues you have found earlier (filed as CELLSNET-40212) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.
7

Hi,


Please try our latest version/fix: Aspose.Cells for .NET v7.7.0.3

We have fixed the issue"CELLSNET-41226".

Thank you.