Support: How can we avoid the 'Unexpected token' exception while using formula in XlsIO? : Syncfusion

How can we avoid the 'Unexpected token' exception while using formula in XlsIO?

(Views :1863)

While using formula in XlsIO the following exception may occur:

Syncfusion.XlsIO.Implementation.Exceptions.ParseException "Unexpected token.Unexpected token type: Identifier, string value: at position 7. Formula: SUM(A1;B2), Position: 7"

This issue occurs if a different regional setting is used other than English. You may need to set separator to workbook before assigning formula depending upon your current UI culture. The below code is used for setting separators:

IWorkbook workbook = applicationWorkbooks.Create(1);

IWorksheet sheet = book.Worksheets[ 0 ];

workbook.SetSeparators('';'', '','');

sheet.Range["H10"].Formula = "=SUM(A1;B2)";

Dim workbook As IWorkbook = applicationWorkbooks.Create(1)

Dim sheet As IWorksheet = book.Worksheets(0)

workbook.SetSeparators(";", ",")

sheet.Range("H10").Formula = "=SUM(A1;B2)"

Call Toll Free

1-888-9DOTNET

Products

Support

Sales

Downloads

Company

Call us

Toll Free: 1-888-9DOTNET
US: +1 919.481.1974
UK: +44 20 7084 6215

Sales

sales@syncfusion.com

About Syncfusion

Founded by industry experts in 2001, Syncfusion, Inc. provides the broadest range of enterprise-class software components and tools for the Microsoft .NET platform. With Syncfusion, developers can move beyond simply coding applications to delivering real business innovation—the elegant user interfaces, business intelligence dashboards, and sophisticated reporting that today's business users need, in the formats they demand.