Exporting .xlsx files with multiple worksheets

Matty3
Tera Contributor

My current requirement is to create a UI Action that queries a table and attaches the results to a form as an .xlsx attachment. I've seen a few suggestions on the forum for creating a spreadsheet from a query, but I couldn't find any questions about multiple worksheets. So, I guess I'm really asking two separate questions.

 

Is there a recommended way to create an .xlsx from a query?

Is it possible to create an .xlsx with two or more worksheets?

 

Thank you!

5 REPLIES 5

Matty3
Tera Contributor

Can you provide a reference to the Excel Export API? I was unable to find it in ServiceNow or online. Thank you!