Error trying to create pivot table

[Timothy L Anderson]

I am running on an older version of xlsio 8.3.0.21 and i am trying to create a pivot table.

I use the following code:

IWorksheet main = wkb.Worksheets[0];

IWorksheet wks = wkb.Worksheets.Create(account.AccountName);

string range = String.Format("A{0}:G{1}", (account.header_row - 1), (account.stop_row - 1));
               
IPivotCache cache = wkb.PivotCaches.Add(main.Range[range]);

I am getting the following exception:

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

I found reference to this error here:

http://help.syncfusion.com/samples/xlsio.silverlight/issues/newissues_1.txt

But there is no information about the error, other than it is a existing issue.

[Mathu Mohan Vijayakumar]

Hi Timothy,

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 8.3.0.21. We strongly recommend you to upgrade to our latest version (13.2.0.29), which has more features and enhancements. This is available for download under the following link.

Latest Version:

http://www.syncfusion.com/downloads/latest-version
Regards,
Mathu Mohan V A