1. Agapita Papio
  2. PowerBuilder
  3. Monday, 14 November 2022 06:23 AM UTC

Hi,

 

Just want to ask what could be the possible cause of the error encountered during saving of the datawindow to Excel file when running the executable file.

If the application is being run within the Powerbuilder IDE, saving to Excel is successful. But  encountered an error like 'Error when converting to Excel..'  when running the compiled application.

Please help. Thank you.

 

 

Andreas Mykonios Accepted Answer Pending Moderation
  1. Monday, 14 November 2022 09:41 AM UTC
  2. PowerBuilder
  3. # 1

As you are running exe in some other machine note that you have to deploy the following runtime files:

  • PBDWExcel12Interop.dll
  • Sybase.PowerBuilder.DataWindow.Excel12.dll

Those files should be placed on the same folder where your executable resides. Also, as stated in help file, you must also have Microsoft .NET Framework 4.0 installed (should work with 4.8), if your application use components such as ADO.NET, MS Excel12 Support which rely on .NET Framework.

Another solution would be to use PB Runtime Packager which will generate an msi with all components needed. Just select parts of runtime that are required - used by your application:

Andreas.

Comment
There are no comments made yet.
Andreas Mykonios Accepted Answer Pending Moderation
  1. Monday, 14 November 2022 07:50 AM UTC
  2. PowerBuilder
  3. # 2

Hi.

First of all you should state version of PB, and saveastype used in dw.saveas command.

Also you run exe file on the same machine where PB is installed or on another machine?

Andreas.

 

Comment
  1. Agapita Papio
  2. Monday, 14 November 2022 09:22 AM UTC
I am using Powerbuilder 2021 and used XLSX! as the saveastype.

I am running exe from other machine.
  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.