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

Resolved DATAWINDOW SAVEAS XLSX FORMAT

  1. Advice
0
Votes
Undo
  1. Jinu Nair
    Jinu Nair
  2. PowerBuilder
  3. Wednesday, 12 August 2020 06:32 AM UTC

Hi,

 

I tried saving datawindow as XLSX! format in PB2019. But the return value is -1.

Can anybody guide me the script for Saveas XLSX! format?

Awaiting your valuable response.

 

Regards

Jinu Nair

PowerBuilder 2019 R3 32 Bit generation issue
Application close event not firing when run from P...
Responses (2)
René Ullrich
René Ullrich Accepted Answer Pending Moderation
  1. Wednesday, 12 August 2020 10:49 AM UTC
  2. PowerBuilder
  3. # 1

Hi Jinu,

SaveAs to XLSX doesn't need a special script.

There difference between SaveAs to XLS and XLSX is, that export to XLSX uses a .NET assembly in background.

The export fails with -1 if the .NET runtime is not installed or the Sybase.PowerBuilder.DataWindow.Excel12.dll or the PBDWExcel12Interop190.dll is missing.

If you use the Runtime packager to deploy the runtime for your application it installs the files if "MS Excel 12 Support" is checked. The Sybase.PowerBuilder.DataWindow.Excel12.dll file will be installed to the Windows GAC folder. 

You may also try to install the Sybase.PowerBuilder.DataWindow.Excel12.dll in the same directory as your EXE.

HTH,

René

Comment
Florine Rivaux
  1. Florine Rivaux
  2. Friday, 12 March 2021 15:03 PM UTC
Yes, Adding this dll in the EXE directory solved my issue.
  1. Helpful
There are no comments made yet.
Jinu Nair
Jinu Nair Accepted Answer Pending Moderation
  1. Wednesday, 12 August 2020 11:02 AM UTC
  2. PowerBuilder
  3. # 2

Dear Rene,

Thanks you very much for the quick response.

I guess, your response is in the context to EXE file.

We are using Appeon, in this case how do we manage at the client browser?

Should it resolve if we add the .dll while compiling?

 

Regards/Jinu Nair

Comment
René Ullrich
  1. René Ullrich
  2. Wednesday, 12 August 2020 11:49 AM UTC
Yes, I talked about a client application.

Maybe this helps you: https://community.appeon.com/index.php/qna/q-a/saveas-to-xlxs-in-powerserver-2020
  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.