Spire.XLS not converting XLSX to CSV in case of double qoute

Wed Oct 19, 2022 5:35 am

HI Team ,
We are using Spire.XLS to convert XLSX to CSV. In case the XLSX columns contain a double quote , the output csv produced is not correct. The output csv file when opened with MS Excel , is showing the same content being shifted to other columns .
Example -

Input - dummy, dummy, "dummy"
Actual - ""dummy, dummy, ""dummy""""
Expected - "dummy, dummy, ""dummy"""

Wed Oct 19, 2022 7:50 am

Hello,

Thanks for your inquiry.
I did reproduce the behavior you mentioned when testing with our latest Spire.XLS version. I have logged this issue into our tracking system with the ticket SPIREXLS-4211. Our Dev team will do more investigations. Once there is any update, I will inform you asap. Sorry for the inconvenience caused.

Sincerely,
Simple
E-iceblue support team

Fri Nov 25, 2022 9:53 am

Hello,

Thanks for your patience!
Glad to inform you that we just released Spire.XLS Pack(Hotfix) Version:12.11.3 which fixes the issue with SPIREXLS-4211. Please download the new version from the following links to test.
Website download link: https://www.e-iceblue.com/Download/down ... t-now.html
Nuget download link: https://www.nuget.org/packages/Spire.XLS/12.11.3

Sincerely,
Simple
E-iceblue support team