XLSDbRead5 : Non printing characters

[Noemie]

Dear all,

We are using XLSDbRead5 linked with XLSReadWriteII5 components to extract some of our SQLServer data to an xlsx file. It's working great so far.

Some of our customers got some strange non printing caracters (like ASCII #31 for example) in some varchar fields. It can comes from copy/past from other software or from the internet for example. In our software, this kind of characters doesn't cause any problem, they are not visible but the rest of the field content is shown.

Unfortunately, when we try to export this kind of field in Excel, the following message appears when we try to open the xlsx file :

Excel has found unreadable content in <filename.xlsx>. Do you want to recover the contents of this workbook?

And after that, if we click "yes", all the varchar columns are blank.

I woule like to manage this kind of data, without having to treat the database.

Is there a way to modify the data read from XLSDbRead5 before they are written in the xlsx file? or is there any solution to avoid this problem withou having to modify the initial DBField content?

Thank you for your answer.

Regards

Noémie

[larsa]

Hello

When you write text to a cell, the text is expected to be unicode. If not, you must convert it to unicode.