I have created a "template" XLSX file that uses Smart Markers to populate some rows (see attached). I then have a Pivot Table created against those rows. This used to work perfect in the previous version of Cells (over a year ago), but now when I call Process, ASPOSE throws exceptions like:
System.ArgumentException: this name or range is not supported.
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
My code is pretty simple:
Aspose.Cells.WorkbookDesigner designer = new Aspose.Cells.WorkbookDesigner();
designer.Workbook = new Aspose.Cells.Workbook(@"c:\template.xlsx");
designer.SetDataSource(DataTableofInputData); // Pass in a simple data table
designer.Process(); // This call crashes with my attached XLSX file
If I add or remove columns in the attached template XLSX file, I can change the Exeption.
Any ideas what broke or changed in the newer versions of ASPOSE.Cells? Or how I can make this work? I tried ASPOSE.Cells 7.12 thru the latest and all behave the same way.