Create an excel file through server side script

Jyothy S
Giga Contributor

‎12-15-2022 10:00 PM

Hi, 

We have a requirement to generate an excel file automatically from an HTML Table content created by processing data in certain table via scheduled job. The HTML table content has text differences between columns highlighted in different color. Need the excel file to contain these formatting.Once the file is created it should be sent via email. Any thoughts on how to achieve this.

JyothyS_0-1671170337448.png

 

Any help appreciated!

 

Thanks

JS

0 Helpfuls
  • 1,911 Views
4 REPLIES 4

Saurav11
Kilo Patron
Kilo Patron

‎12-15-2022 10:30 PM

Hello,

 

Please check the below article for the same:-

 

https://www.servicenow.com/community/developer-articles/convert-script-into-excel/ta-p/2330235

 

Please mark my answer as correct based on Impact.

0 Helpfuls

Jyothy S
Giga Contributor
In response to Saurav11

‎12-18-2022 05:44 PM

Hi Saurav,

Thanks for your reply. 

Here the requirement is to automatically create an excel spreadsheet with the intended styling(color) in columns, so CSV file generation doesnot help.

 

0 Helpfuls

Christian90
Tera Contributor

‎02-23-2023 11:17 AM

Any news on this?

 

 

0 Helpfuls