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. Image for the cookie policy date

ArgumentException thrown when interacting with excel worksheet: 'Can't set current serie to secondary axis'

HI, i am access an excel workbook from a memorystream (having accessed it via database access).

the workbook has only one worksheet with several charts on it. I modify the values and print the sheet to pdf as report which the user can download using javascript to their browser.

when access the workbook i got this error: 'Can't set current serie to secondary axis'

I implemented the ExcelParseOptions.ParseWorksheetsOnDemand  and that gets the workbook to open. but as soon as I access/modify any ranges or charts on the worksheet it throws this error again.

I never had this problem with previous versions of syncfusion blazor components but since upgrading to 20.4 i am getting this error.  this is a major problem as my users on the website need to be able to print this report.

what should i do?



1 Reply

KK Konduru Keerthi Konduru Ravichandra Raju Syncfusion Team January 4, 2023 01:22 PM UTC

Michael, the new version of Syncfusion XlsIO ( is now available to download from nuget.org. Kindly upgrade to this new version, check, and let us know if the issue is resolved.

Latest NuGet Package:https://www.nuget.org/packages/Syncfusion.XlsIO.WinForms/ 

Live Chat Icon For mobile
Up arrow icon