System.ArgumentException: strName - string cannot be empty at Syncfusion.XlsIO.Implementation.Collections.PivotCacheFieldsCollection.AddNewField(String strName) at Syncfusion.XlsIO.Implementation.PivotTables.PivotCacheImpl..ctor(IApplication application, Object parent, IRange dataRange) at Syncfusion.XlsIO.Implementation.PivotTables.PivotCacheCollection.Add(IRange range) at HoldingsIndustryReport.Program.generate_accounts_worksheets(IWorkbook& wkb, List`1 accounts) in Program.cs:line 158 at HoldingsIndustryReport.Program.Main(String args) in Program.cs:line 469
MMMathu Mohan Vijayakumar Syncfusion Team September 25, 2015 08:40 AM UTC
It seems to be a usage level issue. In your code we can see that you are selecting the range with empty cells to add the pivot cache. Hence the exception is thrown. You can resolve this by adding values to the range before performing this. Kindly refer to the online documentation related to pivot tables from the following link. UG Documentation Link: http://help.syncfusion.com/wpf/xlsio/working-with-pivot-tables
You have mentioned that your file version is 188.8.131.52. We strongly recommend you to upgrade to our latest version (184.108.40.206), which has more features and enhancements. This is available for download under the following link.