Problem:

If you are using RPG2SQL's Excel functions (anything that starts with XLS_) in a program to write XLS files, the PC running RPG2SQL PC Component has Excel 2007, but the users viewing the generated spreadsheet are running Excel 2003 or earlier, the users may get the following message:
 
The file you are trying to open, '[filename]', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?
 

Solution:

When you use FILESAVEAS in XLS_Command in RPG2SQL, use an extra value to specify the file format. RJS Software has defined a number of these in the copy member RPGSQLH in the source file RJSRPQSQL/SOURCE. RJS Software has traditionally used xlExcel9795 (represented by the value 43), but Excel 2007 no longer accepts this value. Use xlExcel8 (represented by the value 56, and referring to XLS files from Office 97-2003) instead.
 
It is also possible to change a registry entry to disable this message, but you need registry access to the PCs viewing the spreadsheet.
 
See the following articles for more information or search Google.

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: December 10, 2016