How much of an effort is involved in generating an...
# suitescriptr
rustyshackles
10/19/2023, 9:23 PMHow much of an effort is involved in generating an Excel file using SuiteScript? I have not done this before, so I have no idea. The sample file provided has two worksheets. Some cells have formulas and there is some formatting also.
b
burkybang
10/19/2023, 10:05 PMIt’s not terribly difficult. There are resources online explaining the format. What I’ve done is create a sample file in Excel, change the file extension to .xml, and open it with a text editor to see how it’s formatted.
m
michoel
10/19/2023, 10:29 PMSheetJS works nicely
j
jen
10/20/2023, 2:26 PMdoing it manually is a little finicky; you have to keep careful track of row and col ids
jen
10/20/2023, 2:26 PMbut you can achieve some cool results (nicely formatted sheets)
2 Views