1. John Mavropoulos
  2. PowerBuilder
  3. Wednesday, 3 April 2024 11:27 AM UTC

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

Attachments (1)
Accepted Answer
Andreas Mykonios Accepted Answer Pending Moderation
  1. Wednesday, 3 April 2024 11:54 AM UTC
  2. PowerBuilder
  3. # Permalink

Hi.

You should not use excel5! but excel8! in your saveas command.

excel! and excel5! are producing xls in older formats.

Andreas.

Comment
There are no comments made yet.


There are replies in this question but you are not allowed to view the replies from this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.