1. Tomáš Podzimek
  2. PowerBuilder
  3. Tuesday, 5 December 2023 14:38 PM UTC

Hi all,

we are trying to upgrade our export to xls functionality. Our goal is to replace old xls format generated using pb2xls library with current xlsx format.

We use this syntax:

idw_requestor.saveas(as_filename, XLSX!, true)

For simple DWs and reports, it works. The problem is when a report has some groups and no visible data in detail band. The exported xlxs file contains no valid data.

Pb2xls seems to be a predecessor of dw2xls. Is there another way besides upgrading to dw2xls, which should support xlxs?

 

Any help will be appreciated.

Tomáš

 

John Fauss Accepted Answer Pending Moderation
  1. Tuesday, 5 December 2023 15:12 PM UTC
  2. PowerBuilder
  3. # 1

Hi Tomáš -

I've not tried it, but you may wish to check into this post in the Tech Articles section of the Community:

https://community.appeon.com/index.php/articles-blogs/tutorials-articles/2-powerbuilder/190-exporting-datawindows-to-excel-html-without-loosing-format

Best regards, John

 

Comment
  1. Tomáš Podzimek
  2. Wednesday, 6 December 2023 09:39 AM UTC
Thanks, John, I will give it a try.

Regards, Tomáš
  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.