• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • DW to Excel export - carriage return and line feed characters

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved DW to Excel export - carriage return and line feed characters

  1. How-to
0
Votes
Undo
  1. Mario Parietti
    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?

PowerBuilder 2018
Powerbuilder discord server
Responses (2)
Chris Pollach @Appeon
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
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.