Now you have resolved my previous issue, i am trying to put some calculations in my excel.
But I have a problem since I succeeded to get my csv values, I am trying to use some formula.
In my calculation I have a square formula ( RACINE(Value) in french ), but when I do that I have a =@RACINE(....)
My set up is :
- Windows 10 Family - French
- Excel 2019 - French
- Visual Studio C# coding- NET 5.0 in Console (even in 4.7.5 .NET in Form)
- Code: Select all
CultureInfo cc = Thread.CurrentThread.CurrentCulture;
Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture;
//initialize workbook and worksheet
Workbook wb = new Workbook();
wb.Version = ExcelVersion.Version2016;
wb.LoadFromFile("record.csv", ";", 1, 1, ExcelVersion.Version2016, System.Text.Encoding.UTF8);
Worksheet sheet = wb.Worksheets[0];
sheet.Range[1, 1, max_row, max_col].ConvertToNumber();
sheet.Range[2,2].Formula = "RACINE(2*0.01*(C2-1)))";
Result is :
- Code: Select all
=@RACINE(2*0.01*(C2-1))
Thanks,
Simon