Thanks Babar Raza !!For your quick response.
This is to update you that we have done further testing, however we were not able to avoid the Excel’s repair warning while loading the resultant spreadsheet therefore we have logged this incident in our bug tracking system as CELLSNET-43877. Please note, the aforesaid ticket has been logged to address the problem related to the Excel’s repair warning by adding/creating Pivot Table. Once we sort out this problem, we will look further into the requirement of creating a Pivot Table with desired layout.
Please allow the product team to further look into the details of this problem and we will keep you updated on the status of correction. We apologize for your inconvenience.
I am afraid, we haven’t yet received any updates regarding the aforesaid ticket. You have to spare us little more time as the ticket is currently pending for investigation and is in the queue with other priority tasks. That said, I have recorded a note to the aforesaid ticket, requesting the concerned member of the product team to share the insight of the problem. As soon as we receive any news, we will post here for your kind reference.
This is to inform you that the ticket logged earlier as CELLSNET-43877 has been marked resolved by the product team. We will shortly provide the fix here after ensuring the quality and incorporating other enhancements.
Thanks for your using Aspose.Cells.
Please download and try the latest fix: Aspose.Cells for .NET v22.214.171.124 and let us know your feedback.
Thank You Very Much!!
LoadOptions loadOptions = new LoadOptions();
Workbook workbook = new Workbook(“D:/customer.xlsx”, loadOptions);
Worksheet sheet2 = workbook.Worksheets[workbook.Worksheets.Add()];
sheet2.Name = “Summary 2”;
Aspose.Cells.Pivot.PivotTableCollection pivotTables = sheet2.PivotTables;
int index = pivotTables.Add("=" + workbook.Worksheets.Name + “!A1:Y” + (workbook.Worksheets.Cells.MaxDataRow + 1), “B3”, “PivotTable1”);
Aspose.Cells.Pivot.PivotTable pivotTable = pivotTables[index];
pivotTable.AddFieldToArea(Aspose.Cells.Pivot.PivotFieldType.Row, “AU No”);
pivotTable.AddFieldToArea(Aspose.Cells.Pivot.PivotFieldType.Row, “Debtor/Search Name”);
pivotTable.AddFieldToArea(Aspose.Cells.Pivot.PivotFieldType.Row, “Obligor No”);
if (pivotTable.DataField != null)
int rowFieldsCount = pivotTable.RowFields.Count;
for (int j = 0; j < rowFieldsCount; j++)
PivotField f = pivotTable.RowFields[j];
f.ShowCompact = true;
f.ShowInOutlineForm = true;
f.ShowSubtotalAtTop = true;
pivotTable.PivotTableStyleType = PivotTableStyleType.PivotTableStyleMedium9;
The issues you have found earlier (filed as CELLSNET-43877) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
Many Many Thanks to Aspose Team,You all did a great job to save my life.