Getting a "File is Corrupt" error from Excel when ...
# suitescriptn
Netsuite Tragic
07/07/2023, 10:45 PMGetting a "File is Corrupt" error from Excel when I open the XLS file that I'm creating. Can anyone see the issue with this code?
Netsuite Tragic
07/07/2023, 10:47 PMThis is the XML that gets encoded :
Copy code
<?xml version="1.0"?><?mso-application progid="Excel.sheet"?><Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="<http://www.w3.org/TR/REC-html40>"> <Worksheet Name="FirstTab"> <Table><Row><Cell>12</Cell></Row> </Table> </Worksheet></Workbook>a
Anthony OConnor
07/07/2023, 11:08 PMI don't think .xls format is just base64 encoded xml
maybe this will help?
https://stackoverflow.com/questions/39921856/conversion-of-base64-encoded-into-xslx
n
Netsuite Tragic
07/07/2023, 11:12 PMI was using this SA Article Create Excel File via SuiteScript 2.0 so I was thinking it would work with that code.
a
Anthony OConnor
07/07/2023, 11:44 PMumm okay, you're missing the
ss:Anthony OConnor
07/07/2023, 11:46 PMthat's the only difference i'm seeing
✅ 1
Anthony OConnor
07/07/2023, 11:47 PMumm I guess you also don't have the Data tag wrapper
✅ 1
c
CD
07/08/2023, 5:02 AMJust use sheets.js instead
☝️ 1
n
Netsuite Tragic
07/08/2023, 7:50 AM@Anthony OConnor you are onto it. ss: on the Data wrapper. thank you
👍 1
3 Views