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);
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.
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.
Thank you for your prompt response.
the problem is now fixed.
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.