1. Tony Pafumi
  2. InfoMaker
  3. Friday, 4 March 2022 18:17 PM UTC

What is the best method to save a report to Excel ? I keep getting this error.  

 

Tony Pafumi Accepted Answer Pending Moderation
  1. Friday, 4 March 2022 19:23 PM UTC
  2. InfoMaker
  3. # 1

I am using this build.

 

Under Windows 10

 

On your forth question I don't know how to check this ?

 

I have tried all excel versions and when I select CSV my session locked.

Comment
  1. Chris Pollach @Appeon
  2. Friday, 4 March 2022 19:36 PM UTC
Hi Tony;

If you were saving to Excel, you would be choosing a file with the suffix "XLS" or "XLS?". The CSV file format is just a common industry file format called "Command Separated Values" and has nothing to do with Excel (although Excel can read it).

Sounds like you might not be running from the IDE but instead, an Application executable made from IM. If so, the common reason for the failure could be that the runtime module that handles the exporting of files (like CSV) is missing OR your trying to save the file to a protected folder of your O/S or network where you do not have write privileges for. HTH

Regards ... Chris
  1. Helpful
  1. Roland Smith
  2. Monday, 7 March 2022 14:47 PM UTC
CSV = Comma Separated Values. It is a plain text file with commas between columns.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 4 March 2022 19:13 PM UTC
  2. InfoMaker
  3. # 2

Hi Tony;

  Can you tell us ....

  1. What version & build of IM are you using?
  2. What O/S is IM running under?
  3. What Excel file format are you choosing?
  4. Is the Report running in the IM IDE or within an App EXE built from the IM IDE?

Regards ... Chris

 

Comment
There are no comments made yet.
John Fauss Accepted Answer Pending Moderation
  1. Friday, 4 March 2022 19:11 PM UTC
  2. InfoMaker
  3. # 3

Hi, Tony - 

Are the following two runtime DLL's installed in the same folder as the other Infomaker runtime DLL's?

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

These are required in order to save data in Excel format. Alternatively, you can save data in Infomaker in CSV (comma-separated value) format, as Excel is able to read these files. From within Excel, you can then Save As XLSX, if desired.

Regards, John

Comment
  1. Tony Pafumi
  2. Friday, 4 March 2022 19:26 PM UTC
My software company controls the file location for the .dll
  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.