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.