How to generate Excel file(.xlsx) using script without any third party lib.?

ahan · ‎10-14-2024

Hi, I need a way to generate an excel file(not CSV) with certain columns and rows. Values of the cells are not directly from tables.

Can anyone help here?

Isaac Vicentini · ‎10-14-2024

Hi @ahan!

To do this without using a third-party lib, you need to use a Servicenow solution.

See if you have a license and can use the following Spoke:

https://docs.servicenow.com/bundle/xanadu-integrate-applications/page/administer/integrationhub-stor...

If my answer helped you in any way, please mark it as Helpful / Accept as Solution 🎯

Regards,

Isaac Vicentini.

Best regards,

Isaac Vicentini
MVP 2025 ✨

If my answer was helpful, mark it as Helpful or Accept as Solution.

View solution in original post

Hitoshi Ozawa · ‎10-17-2024

To generate a xlsx file without using third party solution, you'll need to send the data via a MID server and have a script to generate a xlsx file and send it back.

I'm actually doing something similar in my production instance.