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

Aspose.Cells Product Family
1

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

2

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.