search

patrickTingen / DataDigger

A dynamic dataviewer for your Progress / OpenEdge databases
https://datadigger.wordpress.com/
MIT License
50 stars 24 forks source link

Export to Excel #52

Closed dlabas2 closed 4 years ago

dlabas2 commented 4 years ago

When exporting to Excel using QueryTables, the TextFilePlatform attribute is set to 850. The export result is not good. I changed it temporarily to 1250 and now it's fine. It may be that the code page used is the one offered for export. Thank you.

image

image

image

image

patrickTingen commented 4 years ago

Thanks for submitting. The cp from the user cannot be used since Excel crashes if you try to export it with a valid codepage like IBM850. It seems to work only with a windows codepage like 1250, 1251 etc. I fixed this in the dev branch