Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Excel File Type - Notice when opening
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.
0