I am creating a custom report using SuiteQL in a Suitelet script. Previously I have successfully created the report using CSV, but as we know CSV does not support multiple sheets. I want the result to be an Excel file (XLS/XLSX) so I could make it multiple sheets in a single file.

I have tried using ExcelJS workbook.xlsx.writeBuffer() but it does not execute in the Suitelet.

How can I achieve this?

Thank you