Please see attached excel file, in “BillingPivot” tab, a report filter on B3, the values are from G cell of “BillingData” tab.
I want to make the report filter select the max value(in this case the max value is 2006/4/21) after some new records add to BillingData tab by using aspose, and the pivot table should be really filtered, please give me some clue, thanks in advance.
PivotTable table = workbook.getWorksheets().getSheet(0).getPivotTables().get(0);
PivotField field = table.getPageFields().get(1);
Could you provide instructions on how to do this in the .NET version? I don’t seem to have access to most of these methods; starting with the get methods (I can get the fields another way, but I don’t even have a setCurrentPageItem or anything similar on the field.
Thanks in advance,
Thanks for your posting and using Aspose.Cells for .NET.
Please download and use the latest version: Aspose.Cells
for .NET v22.214.171.124.
Please use PivotTField.CurrentPageItem the property. Below is the translated code in .NET
Workbook workbook = new Workbook(“D:\Billing.xls”);
PivotTable table = workbook.Worksheets.PivotTables;
PivotField field = table.PageFields;
field.CurrentPageItem = (short)(field.ItemCount - 1);
table.RefreshDataOnOpeningFile = true;
Is there any updates on Ticket Id CELLSJAVA-28115 .
I have a similar requirement.
Thanks for your posting and using Aspose.Cells.
This is actually an old ticket which is non-existent in the current database. Could you please elaborate your requirements in detail in a New Post. We will look into it and create a New Ticket in the current database to support your feature request.
Thanks for your cooperation.