Load CSV file with CELL multi lines

Aspose.Cells Product Family
1

i would like un fiche CSV wint sepataeur TEXT and Cell multi line.

the result is ko on annexeDesktop.zip (6.9 KB)

Thanks.

My code
String csvFile = “Export Campagne 1.csv”;
TxtLoadOptions opts = new TxtLoadOptions(LoadFormat.CSV);
opts.setSeparator(’;’);
opts.setSeparatorString(""");
opts.setMultiEncoded(true);
Workbook workbook = new Workbook(csvFile, opts);
workbook.save(“out.xlsx”, SaveFormat.XLSX);

2

@groupamapj

Please provide us your good and expected output CSV file so that we could know what results you want. We will then look into it and provide you a sample code for your needs.

3

@groupamapj

We have looked into your code and found, there is one obvious error in your code:

Java

TxtLoadOptions opts = new TxtLoadOptions(LoadFormat.CSV);
opts.setSeparator(’;’);
opts.setSeparatorString("""); //There is no need of it and it is incorrect

Removing this line of code will generate the correct result for you.

4

Thank you for your prompt response.
the problem is now fixed.

5

@hajrasabirandroid

It is good to know that your issue is sorted out now. Let us know if you encounter any other issue, we will be glad to look into it and help you further.