We have a number of scheduled scripts (and e-mailed saved searches) that generate XLS file attachments and mail to a group. When these are opened all users get the message ...
"The file you are trying to open fileName.xls is in a different format than specified by the file extension."
The file is created within the scripts using:
var xlsFile = nlapiCreateFile('Monthly NPS Reporting for ' + dateStringForMonthlyReport + '.xls', 'EXCEL', nlapiEncrypt(xmlString, 'base64'));
or in the Saved Searches under the e-mail tab and selecting an Excel file format to be attached.
In addition they are unable to open the file depending on the device they are opening it on.
Is there any way to force NS to generate a true Excel format file?
Thanks
AGMNS