Error converting csv to xlsx when more than 2000 rows

[chrisguest]

Hi, when trying to convert a .csv file to xlsx, the following line produces an error "BH2194 String length max than 32K" where 2194 is the number of rows in the csv file.
workbook.LoadFromFile(pSourceFile, ",", 1, 1)
I am using the latest version.
Any assistance appreciated.
Chris

[Brian.Li]

Hello Chris,

Thanks for your inquiry.
I did an initial test with your input file, but I did not reproduce your issue. To help us investigate further and solve your issue, please provide your OS information (e.g. Windows7, 64bit) and your region setting (e.g. China, Chinese). Thanks in advance.

Sincerely,
Brian
E-iceblue support team

[chrisguest]

Hi Brian
I'm on Windows 10 Version 21H1 OS Build 19043.928 64 bit. Region is Australia.

[Brian.Li]

Hello,

Thank for your feedback.
I tested your case in a similar environment but I still did not encounter any issue. Here I uploaded my.exe file. Please click the "xls.exe" file to run it directly on your side and then let us know your result. Looking forward to your feedback.

Sincerely,
Brian
E-iceblue support team

[chrisguest]

Hi
Your executable works. However, I still get the error on trying to load from file as shown in the screenshot from Visual Studio when my code runs.

ice.PNG (13.46 KiB) Viewed 1030 times

[chrisguest]

Hi Again
Interesting - when I add an empty try/catch block, the error still happens, but the subsequent code gets executed and the workbook can be formatted - this solves my immediate problem, but it would be good to know why the error is thrown:

Code: Select all

Try
            workbook.LoadFromFile(pSourceFile, ",", 1, 1)

        Catch ex As Exception

        End Try

[Brian.Li]

Hello,

Thanks for your feedback.
To help us reproduce your issue so that we can locate the cause of this issue, could you please provide us with your runnable project? You could upload it to the DropBox or OneDrive and then share the download link with us. Thanks in advance.

Sincerely,
Brian
E-iceblue support team

[Brian.Li]

Hello,

Has your issue been resolved? If not, could you please provide your runnable project to us for further investigation?

Sincerely,
Brian
E-iceblue support team