I want to generate an Excel from RITM Variables, in .xlsx format..Please help me with the solution.

nandhinikan
Mega Contributor

I want to generate an Excel from RITM Variables, in .xlsx format once the RITM generated

 

Already I have created an script include to generate .xls file, but not able to generate in .xlsx format.

4 REPLIES 4

nandhinikan
Mega Contributor

It would be helpful if I'm able to generate the file in tsv format from the RITM Variables

Ankur Bawiskar
Tera Patron

@nandhinikan 

XLSX some what difficult to generate.

I created blog on how to generate CSV

Generate csv file with the catalog variables and attaching to RITM record 

also check this link where script is there for XLSX -> response from AJAY

Generate Excel file (xls or xlsx) based on script 

AnkurBawiskar_0-1770903067676.png

 

AnkurBawiskar_1-1770903087402.png

Also check this in same thread.

AnkurBawiskar_2-1770903103057.png

 

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

But still the script is having only .xls extension

@nandhinikan 

then it's not feasible to generate XLSX within ServiceNow

Let me still explore

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader