Hi Team,
I am using PB 2022 Build R2 2828.
When I export datawindow data to excel file (see attachment) using the powerbuilder SaveAs feature (type Excel5!), I come across the following issue:
All data in excel cells ends with null byte character (NUL).
So I can’t use these files for comparison (vlookup method) with other excel files. Also when I copy from excel, only the first cell of the data copied.
At this point I should note that when the export is done with the XLSX! format, the generated file does not have the above issue. Ι αlso did not face this problem in previous versions (etc PB2019).
Any help will be appreciated.
Thanks,
Jonh