1. 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

 

 
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
  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
  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
  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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.