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

Resolved DLLS needed to export as XLSX?

  1. How-to
0
Votes
Undo
  1. Troy Cowan
    Troy Cowan
  2. PowerBuilder
  3. Monday, 5 August 2024 12:12 PM UTC

We are trying to export the contents of a DataWindow to XLSX via SaveAs(). It's not working (no new files, no error message). My educated guess is that I am not deploying some necessary DLLs.

What are the DLLs needed for this functionality?

C0176: Badly ordered TYPE and VARIABLE declaration...
Orphan excel.exe process after creating it via ole...
Responses (4)
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Monday, 5 August 2024 12:40 PM UTC
  2. PowerBuilder
  3. # 1

pbDWExcel12Interop.dll

Sybase.PowerBuilder.DataWindow.Excel12.dll

 

Comment
There are no comments made yet.
René Ullrich
René Ullrich Accepted Answer Pending Moderation
  1. Monday, 5 August 2024 12:47 PM UTC
  2. PowerBuilder
  3. # 2

Keep in mind that you have to load Sybase.PowerBuilder.DataWindow.Excel12.dll into GAC or to deploy it in the exe directory!

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Monday, 5 August 2024 13:15 PM UTC
Plus, you'll also need the .Net framework runtime (ie: 4.8.n).
  1. Helpful
There are no comments made yet.
Troy Cowan
Troy Cowan Accepted Answer Pending Moderation
  1. Monday, 5 August 2024 13:14 PM UTC
  2. PowerBuilder
  3. # 3

Are we sure there aren't more needed? I copied those two into the same directory as my exe and it hasn't fixed the problem. 

As a shot in the dark I also copied PBDWExcel12Interop170.dll but no change. 

Comment
Troy Cowan
  1. Troy Cowan
  2. Monday, 5 August 2024 14:34 PM UTC
Never mind, I got it working. I guess I found an older version of one or both of these DLLs to try at first? Anyways I re-copied these files from C:\Program Files (x86)\Appeon\Common\PowerBuilder\Runtime 21.0.0.1509 into my folder where my EXE resides, and it all works now.
  1. Helpful
Roland Smith
  1. Roland Smith
  2. Tuesday, 6 August 2024 02:21 AM UTC
You'll definitely need the interop dll that goes with the version your app is compiled with.
  1. Helpful
There are no comments made yet.
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Monday, 5 August 2024 13:20 PM UTC
  2. PowerBuilder
  3. # 4

Hi, Troy -

For future reference, check the PB Help topic named "runtime files". The information is well organized. For example:

Best regards, John

 

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Wednesday, 7 August 2024 03:57 AM UTC
Thanks John for the great help!
  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.