In SuiteScript, it is possible to allow downloadin...
# suitescriptl
Luis
07/01/2025, 2:00 PMIn SuiteScript, it is possible to allow downloading of a Suitelet table in XLS format in which the subtotals would show the Excel formulas instead of hardcoded values? For example, =SUM(A2:A5).
Note: The no. of rows to be subtotaled may vary. There are multiple subtotals in a column.
And if possible, is it super complicated? Any guidance? Thanks.
a
alien4u
07/01/2025, 4:06 PMIs complicated and not possible with native SuiteScript, you will need a third party library, something like https://sheetjs.com/
l
Luis
07/01/2025, 5:55 PMHmmm got it thanks
Luis
07/01/2025, 5:57 PMJust to confirm, does that apply even though the file format is XLS and not XLSX?
y
yagyakumarnag
07/02/2025, 12:51 AMWe can achieve it using sheets.js
Please DM for more information.