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)
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Monday, 5 August 2024 13:20 PM UTC
  2. PowerBuilder
  3. # 1

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.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Monday, 5 August 2024 12:40 PM UTC
  2. PowerBuilder
  3. # 2

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. # 3

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. # 4

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.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.