I would like to create an excel file from a transa...
# suitescript
s
I would like to create an excel file from a transaction, like a Purchase Order for example. My approach would be to run a saved search on that record including the columns I want as result, format into comma separated list, and use file.Create to store csv file in file cabinet, then possibly download. Has anyone had a similar use case before? I'd love to know how you accomplished this.
b
your approach sounds reasonable. If emails work, you can try getting an excel like file from the search
if you need an actual excel file, you can try creating one using https://sheetjs.com/
if you want a more formal csv solution, you can try something like https://www.papaparse.com/
c
You can also use CloudExtend Excel for NetSuite (I work there) Here’s an artice and video showing how it works with quotes. Same process for invoices. https://intercom.help/celigo/cloudextend-excel-for-netsuite/business-use-cases/creating-editing-and-viewing-netsuite-quotes-in-excel