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

Resolved Error While Exporting datawindow to Excel.

  1. Issue
0
Votes
Undo
  1. Shweta Jain
    Shweta Jain
  2. PowerBuilder
  3. Wednesday, 13 February 2019 09:55 AM UTC

When I export the DataWindow using function SaveAsFormattedText in excel format, Character "00", "01" is exported as 0,1 respectively (as Integer).

Please suggest the solution for exporting the data from DataWindow to excel  without losing format.

 

 

ImportFile XML Error
Connect to Workspace fails with "The specified dir...
Responses (2)
Marco Meoni
Marco Meoni Accepted Answer Pending Moderation
  1. Wednesday, 13 February 2019 10:31 AM UTC
  2. PowerBuilder
  3. # 1

Hello Shweta,

if your goal is to export "in excel format" you can use

dw_1.SaveAs("test.xls", XLSX!, True)

The leading zeros are retained.

Best,

.m

Comment
Shweta Jain
  1. Shweta Jain
  2. Wednesday, 13 February 2019 10:46 AM UTC
Hi Marco,

Thank you for your reply..

But my goal is to export only some specific fields which is displayed at runtime in datawindow

and if i am going to use function saveas then all fields of datawindow will be exported in excel.



Please suggest the solution for exporting the data from DataWindow to excel without losing format.
  1. Helpful
There are no comments made yet.
René Ullrich
René Ullrich Accepted Answer Pending Moderation
  1. Wednesday, 13 February 2019 11:41 AM UTC
  2. PowerBuilder
  3. # 2

Maybe this can help you:

https://community.appeon.com/index.php/articles-blogs/tips-tricks-techniques-articles/17-powerbuilder/190-exporting-datawindows-to-excel-html-without-loosing-format

 

Comment
Shweta Jain
  1. Shweta Jain
  2. Wednesday, 13 February 2019 16:26 PM UTC
Hi,

Thank you for reply but this technique did not work for me..

Please suggest.
  1. Helpful
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.