Excel to Export Using ServiceNow Table - Server Side Script

[KB18]

Hi All, 

I am looking for the server-side script to generate the excel with formatting the cell values like color, merge cell, font and populate the data 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.

Thanks, Kailas

[kailas_samb]

Hi All,

   I am looking for the server-side solution to export to excel where i can read the cell, formatting (color and font) and populate the values into specific excel cell as per business requirement. Please refer the above excel sample.

  Thank you all for your help in advance                                                                                                                                                                

@Oscar Lopez . @Maik Skoddow , @Pradeep Sharma ,  @Ankur Bawiskar 

[Juan Miguel]

We are looking also for a solution for this, thanks.