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

Resolved PBv12.1 b7055 - What's needed to SAVEAS ".xlsx"?

  1. How-to
0
Votes
Undo
  1. Olan Knight
    Olan Knight
  2. PowerBuilder
  3. Tuesday, 29 June 2021 19:05 PM UTC

PBv12.1, build 7055
Windows 10, 64 bit platform
Oracle 12C


We use SAVEAS to save reports we create. We can save as .XLS, which is Excel 5 and 8, but we cannot save in the .XLSX format (Excel 12).

I've read in this forum that PBv12.5.1 can SAVEAS to Excel12's format of .XLSX.

Is there a way to SAVEAS a .XLSX file from PBv12.1 using Ghostscript?


Thank You,

Olan

FYI: Create multiple DSNs from a single PostgreSQ...
Re: Calling an event in an (instance) window from...
Accepted Answer
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 29 June 2021 19:33 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Olan;

  Here are all the runtime details from my PB 12.x Help. Just change the DLL name numbering from 126 to 125, 121, 120 (as required) for your PB 12.x release ....

 

HTH

Regards ... Chris

 

Comment
Olan Knight
  1. Olan Knight
  2. Tuesday, 29 June 2021 22:11 PM UTC
Wonderful! Thanks, Chris!

This is greatly appreciated.
  1. Helpful
René Ullrich
  1. René Ullrich
  2. Wednesday, 30 June 2021 05:22 AM UTC
One more tip: If it doesn't work try to put Sybase.PowerBuilder.DataWindow.Excel12.dll in the same directory as the EXE file.
  1. Helpful
There are no comments made yet.
Responses (3)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 29 June 2021 19:20 PM UTC
  2. PowerBuilder
  3. # 1

Hi Olan;

  It's the same for PB 12.x as it is for Appeon PB. If you open the PB Help and search for the keyword "runtime", then follow the link to the "list of files" by feature, you will see that the XLSX format requires a few extra DLLs plus the .NET runtime to be installed.

HTH

Regards ... Chris

Comment
There are no comments made yet.
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Tuesday, 29 June 2021 19:23 PM UTC
  2. PowerBuilder
  3. # 2

Well, I tried that and got this:


This is the PBv10.5 HELP file. I don't seems to have a newer PB HELP file, and THIS one doesn't list what I need. I have looked.

 

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