Excel open doesnt work for en-US culture

[Murat]

Hi dera syncfusion Team,

We have a problem, when we open an excel file in local it works but in server it doesnt.the error is

"Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseDecimal(String value, NumberStyles options, NumberFormatInfo numfmt) at System.Convert.ToDecimal(String value) at Syncfusion.EJ.Export.SheetImport.ProcessSheetContent(Int32 sheetIdx, IWorkbook workbook, IWorksheet worksheet, DataContainer container, Sheet sheetmodel) at Syncfusion.EJ.Export.SheetImport.ProcessSheet(Int32 sheetIdx, IWorkbook workbook, IWorksheet worksheet, Sheet sheetProp, DataContainer container, Dictionary`2 datasheets) at Syncfusion.EJ.Export.SheetImport.ProcessWorkBook(IWorkbook workbook, ImportRequest importRequest) at Syncfusion.EJ.Export.Spreadsheet.processRequest(ImportRequest importRequest) at Syncfusion.EJ.Export.Spreadsheet.Open(ImportRequest importRequest) at AutoRfq.WebApp.Controllers.TemplateController.GetExcelFile(ImportRequest importRequest) in D:\TFS Workspace\Seaproc\Source\AutoRfq\AutoRfq.WebApp\Controllers\TemplateController.cs:line 209"

Then i checked culture of server is en-US, but local is en-GB, if i set thread cultureinfo to en-GB it is working. But the problem is i am not sure if i change culture it will give same type of error for another file or not.. as you know i cant estimate the date time format or decimal symbol in an excel file. i am attaching the file for you. Please help. Also i got error "unsupported file" if file is xlsm, i am attaching it to..

Attachment: Files_19ece019.zip

[Janakiraman Sakthivel]

Hi Murat, 

 

Thank you for contacting Syncfusion support. 

 

Query1: 

 

We have checked your reported query and your attached Excel file opens properly from our side. 

Please share the clear details about the issue you faced in the Spreadsheet component while opening the Excel file. Based on that, we will check and provide you with a better solution quickly.

So please share us the following details to proceed further. 

 

1. Please share the codes, if you have done any customization in sample level. 

2. If possible, please share the video demonstration of this issue. 

3. Please share us your Essential studio product version and other details. 

 

Query2: 

 

We have checked query and excel file. We would like to let you know that your excel file is issue at file level because of this unable to process this Excel document. But, while opening the document in Microsoft Excel, it is autocorrected. We suggest you resave this document in Microsoft Excel before opening in Spreadsheet. The resaved file will open properly in Spreadsheet without exception.So, it is opened correctly 

 

Regards, 

Janakiraman S.