Reading a List of Servers from Excel Spreadsheet

pradeepshokeen
Giga Contributor

Hello Everybody,

How could I read the list of servers from the attached excel spreadsheet and add it to the (affected ci table available as a related list in change), the intent is to bulk upload the data of affected CI's from a spread sheet --> verify it --> if available --> relate to affected CI table.

I am assuming there would be some functions to read it from spread sheets, although we can read excel in transform maps but that is something which is a different conversation and not related to Change management process.

any assistance would be highly appreciated.

Thanks,

Pradeep

10 REPLIES 10

Gurpreet07
Mega Sage

Hi Pradeep,



Here is something of your interest.


Parse Excel (xlsx) file.. with ease!