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

Resolved Exporting data from datawindow

  1. Issue
0
Votes
Undo
  1. radha rani
    radha rani
  2. PowerBuilder
  3. Thursday, 5 April 2018 21:23 PM UTC

Hi everyone!

created a window in which datawindow is of external type ,data is been fetched from database and retreving it on the basis of date.

In the datawindow result is looking fine with proper name but when I am saving it into excel its heading is coming as technical name.

Please help with this problem,where i need to make changes.

 

 

  1. Build
Smaller tabpage flaps in PB 2017 R2
Report Creation in powerbuilder
Responses (4)
Kim Berghall
Kim Berghall Accepted Answer Pending Moderation
  1. Thursday, 5 April 2018 23:38 PM UTC
  2. PowerBuilder
  3. # 1

It uses the value from the DB Name attribute in the datawindow,there is currently no way to override that. But you could potentially modify those values to match what you need. 

Comment
There are no comments made yet.
René Ullrich
René Ullrich Accepted Answer Pending Moderation
  1. Friday, 6 April 2018 05:27 AM UTC
  2. PowerBuilder
  3. # 2

Some workarounds:

- Try DW2XLS.

- Write your own export using OLE.

- Try to save as HTML with xls file extension (SaveAs("sheet.xls", HTMLTable!, True))

Comment
There are no comments made yet.
Eduardo G.
Eduardo G. Accepted Answer Pending Moderation
  1. Friday, 6 April 2018 11:14 AM UTC
  2. PowerBuilder
  3. # 3

Or check out the following article:

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

Comment
There are no comments made yet.
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Tuesday, 10 April 2018 16:35 PM UTC
  2. PowerBuilder
  3. # 4

This question was answered two posts down!  :) https://community.appeon.com/index.php/qna/q-a/how-to-change-the-technical-name-to-some-readable-name-in-the-datawindow-extraction-in-excel

 

Later -

Olan

Comment
radha rani
  1. radha rani
  2. Tuesday, 10 April 2018 20:29 PM UTC
Yeah!!



I posted it because I Thought  was not clear enough in explaining my question.,That's why i posted it again..and I figured it out the solution...



 



Thanks for the report making solution.As I am  3 months old to powerbuilder tech I am struggling with the basics of it and now i want to knwo how do i save it in database. I mean the code for saving the data. 

  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.