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

Resolved Save datawindow visuals to excel file XLSX type

  1. How-to
0
Votes
Undo
  1. John Vanleeuwe
    John Vanleeuwe
  2. PowerBuilder
  3. Saturday, 17 February 2024 06:51 AM UTC

Using PB2019 R3

 

We have implemented dw2xls in the past which generates perfectly the .xls files for us.

A recent new customer insisted on us to start using the .xlsx extension.

What are my options in PB 2019 R3 to save a datawindow with all of its layout (so not just the data) into an .XLSX file please ?

 

 

TIA

John

 

 
PB2022R3 Tabbed view close all issue
Deploy Power builder version
Responses (1)
mike S
mike S Accepted Answer Pending Moderation
  1. Saturday, 17 February 2024 14:41 PM UTC
  2. PowerBuilder
  3. # 1

create an external datawindow at runtime with the layout that your report has - but instead of creating computed fields, create columns in the external datawindow.  then copy the data (columns and computes) over from the report. 

You probably want to name the external columns the display name from the report so that excel uses those names.  You can also use lookupdisplay to get the display values of ddlb and dddw and copy that over instead of any codes that might be used in a report.

 

 

Comment
Load more comments
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Saturday, 17 February 2024 16:26 PM UTC
We use dw2xls and it exports perfectly well to xlsx.
  1. Helpful 1
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Saturday, 17 February 2024 16:49 PM UTC
Thanks Miguel! Maybe all they need to do is upgrade to the latest release then. :-)
  1. Helpful
mike S
  1. mike S
  2. Saturday, 17 February 2024 18:48 PM UTC
" we are having 200+ reports already available in our software"

Sorry, i wasn't clear: You build the external datawindow dynamically at runtime. Even if you only had 5 reports you would want to do this at runtime. No one in their right mind wants to maintain both the report and an external datawindow for exports.



We have at least 200 reports (plus dynamically built ones that we don't even know about).



It isn't perfect since everyone wants to export to excel in different ways. Raw or formatted or exact. so we provide all the options.
  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.