1. Mario Parietti
  2. PowerBuilder
  3. Wednesday, 28 November 2018 15:20 PM UTC

Hi, i am trying to export a dw into an excel file, and i have problems handlig carriage returns and line feed characters. I also gave a look at the code samples but in the example i found the CRLF characteres are remuved. Can You help me please?

How can I export without losing CR-LF characters?

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 28 November 2018 17:17 PM UTC
  2. PowerBuilder
  3. # 1

Hi Mario;

  Can you tell us ...

  1. What version of PB are you using?
  2. What O/S & Excel version are you using?
  3. What mechanism are you using to export the data to Excel?

Regards ... Chris

Comment
There are no comments made yet.
Mario Parietti Accepted Answer Pending Moderation
  1. Thursday, 29 November 2018 09:16 AM UTC
  2. PowerBuilder
  3. # 2

Hi Chris,

I use the datawindow SaveAs() function choosing "Excel8 with Headers" type

I try with these versions:

  1. Powerbuilder version 2017 Build 1666
  2. Windows 10
  3. Office 2016

but I also tried with different versions and it works the same.

It ignores CR-LF and put the text all in a line.

 

I give a look to Your example "saveas_excel" using OLE, but i see that CR-LF are removed

before exporting into the Excel file, so it is not useful for me.

 

 

Thanks in advance for Your help.

Mario

 

 

 

 

 

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.