Formula in Excel file

[VincentB]

Hello

I have an issue when i try to load an Excel file with Formula =LEFT(B3, 1)

Code: Select all

string path = Chemin + "sample.xlsx";
var workbook = new Workbook();
workbook.LoadFromFile(path);
// Unexpected token.Unexpected token type: tInteger, string value:   at position 8. Formula: LEFT(B3,1), Position: 8


Do you know when this issue happens or do you have a bypass ?

Thanks

[Betsy.jiang]

Dear VincentB,

Thanks for your inquiry.
Please try to set current culture to avoid this error.

Code: Select all

            CultureInfo cc = Thread.CurrentThread.CurrentCulture;
            Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture;
            Workbook book = new Workbook();
            book.LoadFromFile(@"F:\Sample.xlsx");
            ...
            Thread.CurrentThread.CurrentCulture = cc;

If there is any question, please let me know.

Sincerely,
Betsy
E-iceblue support team

[VincentB]

Hello,

It works perfectly !!

Thanks

[Betsy.jiang]

Dear VincentB,

Thanks for your feedback.
Please feel free to contact us if there is any question, we are here for help .

Sincerely,
Betsy
E-iceblue support team