<@UASKHQ3MX> <https://netsuiteprofessionals.slack....
# suitescriptm
michoel
11/07/2019, 5:56 AMj
JM
11/07/2019, 5:57 AMCan you help me on how i can convert it into CSV?
m
michoel
11/07/2019, 5:59 AMIs this from a saved search you are exporting?
michoel
11/07/2019, 5:59 AMJust to make sure - you do realise that you can just click "Yes" to open the file?
j
JM
11/07/2019, 6:05 AMwe are using Scheduled script the creates the file then saves in the file cabinet
m
michoel
11/07/2019, 6:35 AMPost your code that is creating the file
h
heckytect
11/07/2019, 6:35 AMhey @JM I have still my code in there, is @jhie not around?
👍 1
j
JM
11/07/2019, 6:35 AMmejo busy sir
👍 1
j
jhie
11/07/2019, 2:56 PMHi JM, As @michoel said, the file format is actually an xml although you set the extension as .xls so when you lunch the file is giving you an alert or an information that your opening an XML file. Microsoft implemented a special handler to view and open those files in corresponding application. This handler looking inside the XML and searches for an XML processing instruction which is named mso-application can specify as progid. In your script equivalent is <?mso-application progid="Excel.Sheet"?>.
2 Views