ServiceNow - Export to Excel with Excel formatting

[KB18]

Dear All,

we have requirement to generate excel template for Invoice creation from the ServiceNow Record.

From the Invoice table record, need to populate the values dynamically into attached excel template.

while generating the excel template, it should display the excel template formatting as per the attached template like colour, font text formatting should be same.

Please give me some insights and better solutions to implement.

Quick help will be appreciated.

@Chuck Tomasi @Pradeep Sharma @Ankur Bawiskar @Maik Skoddow 

[VivekSattanatha · Accepted solution]

You can go through the article which I posted about it

https://www.servicenow.com/community/developer-articles/custom-excel-export-or-import-in-client-side...

[KB18]

Thank Vivek for the link provided.

Any other solution and ideas will be appreciated..

Thanks,

KB

[JohnnyP]

I want to export data from ServiceNow to Excel and keep that nice formatting. It can be tricky sometimes. The trick is to use the built-in export options in ServiceNow, which usually lets you choose how you want the data to appear in Excel. If you'll have that polished look immediately, you should play around with Excel templates after the export. I’ve found that customizing your Excel file can save you a lot of time in the long run.

Also, check out myexcelonline for some great formatting tips. It’s a handy resource to make your spreadsheets look professional without much hassle.

[KB18]

@JohnnyP Hi Johnny,

I am looking for the server-side script to generate the excel with formatting the cell values like color, merge cell, font etc. 

Use case: 1. To generate excel or read the excel template from ServiceNow.

2. Read the columns values from the template or create new excel with columns 

3. Read the cell value from the excel template or newly created excel to populate values from the table.

eg. worksheet.getCell('B5').value and so on.

Basically, I am looking to populate the values at the 4 rows.

4. Download or attached excel template in the email.

Please let me know if you have any ideas.

Thanks, Kailas