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.