We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Error trying to create pivot table

Thread ID:

Created:

Updated:

Platform:

Replies:

120557 Sep 24,2015 11:45 PM Sep 25,2015 04:40 AM Windows Forms 1
loading
Tags: XlsIO
Timothy L Anderson
Asked On September 24, 2015 11:45 PM

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 [Syncfusion]
Replied On September 25, 2015 04:40 AM

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


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;