We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Load an Excel CSV file with semicolon delimited via Aspose.Cells in .NET

Hi,


I am not getting the correct datatable when using semicolon delimeted csv file for this below code

LoadOptions loadOptions = new LoadOptions(LoadFormat.CSV);
workbook = new Workbook(this.csvFile.FileContent, loadOptions);

Can you please let me know the options to get the Semicolon delimeted file data…


Regards
Gunasekaran

Hi,


Could you change your sample lines of code to:
e.g
Sample code:

TxtLoadOptions loadOptions = new TxtLoadOptions(LoadFormat.CSV);
loadOptions.Separator = Convert.ToChar(";");
workbook = new Workbook(this.csvFile.FileContent, loadOptions);

Let us know if you still have any issue.

Thank you.