Has anyone found a (simple) way to generate Excel ...
# general
j
Has anyone found a (simple) way to generate Excel (.xls or .xlsx) files out of NetSuite dynamically without the “The file format and extension of ‘<filename>.xls’ don’t match.” message coming up when you try to open it in Excel? I know it’s because it’s actually an XML file underneath. I just need a simple Excel file, much like you’d get if you downloaded a CSV, opened in Excel, and immediately did a Save-As and saved as .xls, no formatting required (though I might add some later). I already have a .xls generating, but it has the above warning, like you get when downloading Excel files from built-in NetSuite tools such as Saved Searces. I’m hoping to avoid using an overly complex external library. I just want a one-step solution to create this file without someone having to open it and fix anything in Excel.
s
lol im also looking for this