Extracting Images from Spreadsheet File
To view image reports from spreadsheet and need to display on ServiceNow UI to client its using java program on MID server and extracted images.
Some reports data is inputted into ServiceNow as Images in spreadsheet file and need to display on ServiceNow UI to client.
The problem was that data source of ServiceNow can read only textual data and ignores multimedia files data like images.
ServiceNow does not have inbuilt solution for extracting images from Spreadsheet file. So we have implemented it using java program on MID server and extracted images from the java program on MID server. Whenever email with spreadsheet containing images is received in ServiceNow inbox, it get processed and sent command to MID server to extract the images. The java program on MID server program extracts the image files from provided spreadsheet and send back to ServiceNow. We use this images in UI page to display reports.
Client can see his reports in the ServiceNow when it was not possible to view image reports from spreadsheet using standard approach to import data.