{"id":95,"date":"2023-12-29T19:17:50","date_gmt":"2023-12-29T10:17:50","guid":{"rendered":"https:\/\/www.fideltech.com\/case-studies\/?p=95"},"modified":"2025-04-14T17:42:54","modified_gmt":"2025-04-14T08:42:54","slug":"extracting-images-from-spreadsheet-file","status":"publish","type":"post","link":"https:\/\/www.fideltech.com\/case-studies\/extracting-images-from-spreadsheet-file\/","title":{"rendered":"Extracting Images from Spreadsheet File"},"content":{"rendered":"\n[et_pb_section fb_built=&#8221;1&#8243; fullwidth=&#8221;on&#8221; _builder_version=&#8221;4.18.0&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_fullwidth_image src=&#8221;https:\/\/www.fideltech.com\/case-studies\/wp-content\/uploads\/2023\/12\/Exctract-images-from-Spreadsheet.jpg&#8221; alt=&#8221;Exctract images from Spreadsheet&#8221; _builder_version=&#8221;4.23.1&#8243; _module_preset=&#8221;default&#8221; custom_margin=&#8221;||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_fullwidth_image][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; fullwidth=&#8221;on&#8221; _builder_version=&#8221;4.18.0&#8243; _module_preset=&#8221;default&#8221; custom_margin=&#8221;2px||0px||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_fullwidth_post_title meta=&#8221;off&#8221; featured_image=&#8221;off&#8221; _builder_version=&#8221;4.18.0&#8243; _module_preset=&#8221;default&#8221; title_text_align=&#8221;left&#8221; custom_margin=&#8221;0px||||false|false&#8221; custom_padding=&#8221;30px||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_fullwidth_post_title][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.18.0&#8243; _module_preset=&#8221;default&#8221; custom_padding=&#8221;25px||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row column_structure=&#8221;1_2,1_2&#8243; module_class=&#8221;inner-page&#8221; _builder_version=&#8221;4.23.1&#8243; _module_preset=&#8221;default&#8221; custom_padding=&#8221;0px||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.18.0&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.23.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<iframe loading=\"lazy\" width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/i5MAi2kCK9U?si=tIzNVjjNDJaCYkdL\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.18.0&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.23.1&#8243; _module_preset=&#8221;default&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221;]<p>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.<\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row module_class=&#8221;inner-page&#8221; _builder_version=&#8221;4.18.0&#8243; _module_preset=&#8221;default&#8221; custom_padding=&#8221;0px||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.18.0&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.23.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<h3>Problems :<\/h3>\n<p>Some reports data is inputted into ServiceNow as Images in spreadsheet file and need to display on ServiceNow UI to client.<\/p>\n<p>The problem was that data source of ServiceNow can read only textual data and ignores multimedia files data like images.<\/p>\n<h3>Solution Provided :<\/h3>\n<p>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.<\/p>\n<h3>Result<\/h3>\n<p>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.<\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;Section&#8221; module_class=&#8221;footer-cnt&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#103e66&#8243; custom_margin=&#8221;||-27px||false|false&#8221; custom_padding=&#8221;||30px||false|false&#8221; hover_enabled=&#8221;0&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;][et_pb_row column_structure=&#8221;1_2,1_2&#8243; _builder_version=&#8221;4.17.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.17.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.19.5&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<h2 style=\"color: #ffffff;\">Is this Case Study interests you?<\/h2>\n<p style=\"color: #ffffff;\">If you found this case study similar to your requirement OR interested to get our services, please connect with us using form. We will be happy to respond.<\/p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;]<p><span><\/span><\/p>\n<h3 style=\"color: #ffffff;\"><i id=\"et-info-phone\"><\/i>Call us<\/h3>\n<p><a href=\"tel:03-6261-3309\" onclick=\"gtag('event', 'generate_lead', {'event_category': 'engagement','event_label': 'Footer Phone Japan','value': '03-6261-3309'});\">03-6261-3309<\/a><\/p>\n<p><span><\/span><\/p>\n<h3 style=\"color: #ffffff;\"><i id=\"et-info-email\"><\/i> Email us<\/h3>\n<p><a href=\"mailto:infofidel@fideltech.com\" onclick=\"gtag(('event', 'generate_lead', {'event_category': 'engagement','event_label': 'Footer Email Japan','value': 'infofidel@fideltech.com'});\">infofidel@fideltech.com<\/a><\/p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.17.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.23.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<div class=\"cf7sg-container\"><div id=\"cf7sg-form-footer-contact-form\" class=\"cf7-smart-grid has-grid key_footer-contact-form\">\n<div class=\"wpcf7 no-js\" id=\"wpcf7-f22-o1\" lang=\"en-US\" dir=\"ltr\" data-wpcf7-id=\"22\">\n<div class=\"screen-reader-response\"><p role=\"status\" aria-live=\"polite\" aria-atomic=\"true\"><\/p> <ul><\/ul><\/div>\n<form action=\"\/case-studies\/wp-json\/wp\/v2\/posts\/95#wpcf7-f22-o1\" method=\"post\" class=\"wpcf7-form init\" aria-label=\"Contact form\" novalidate=\"novalidate\" data-status=\"init\">\n<fieldset class=\"hidden-fields-container\"><input type=\"hidden\" name=\"_wpcf7\" value=\"22\" \/><input type=\"hidden\" name=\"_wpcf7_version\" value=\"6.1.5\" \/><input type=\"hidden\" name=\"_wpcf7_locale\" value=\"en_US\" \/><input type=\"hidden\" name=\"_wpcf7_unit_tag\" value=\"wpcf7-f22-o1\" \/><input type=\"hidden\" name=\"_wpcf7_container_post\" value=\"0\" \/><input type=\"hidden\" name=\"_wpcf7_posted_data_hash\" value=\"\" \/><input type=\"hidden\" name=\"_wpcf7_key\" value=\"footer-contact-form\" \/><input type=\"hidden\" name=\"_cf7sg_toggles\" value=\"\" \/><input type=\"hidden\" name=\"_cf7sg_version\" value=\"4.15.8\" \/><input type=\"hidden\" name=\"_wpnonce\" value=\"445482d3b5\" \/>\n<\/fieldset>\n<div class=\"container\">\n  <div class=\"row\">\n    <div class=\"columns full\">\n      <div class=\"container cnt-mt\">\n        <div class=\"row\" style=\"padding-bottom: 20px\">\n          <div class=\"columns one-half\">\n            <div class=\"field text required\"><span class=\"wpcf7-form-control-wrap\" data-name=\"your-name\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Your Name*\" value=\"\" type=\"text\" name=\"your-name\" \/><\/span>\n              <p class=\"info-tip\"><\/p>\n            <\/div>\n          <\/div>\n          <div class=\"columns one-half\">\n            <div class=\"field email required\"><span class=\"wpcf7-form-control-wrap\" data-name=\"email-669\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-email wpcf7-validates-as-required wpcf7-text wpcf7-validates-as-email\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Corporate Email*\" value=\"\" type=\"email\" name=\"email-669\" \/><\/span>\n              <p class=\"info-tip\"><\/p>\n            <\/div>\n          <\/div>\n        <\/div>\n      <\/div>\n      <div class=\"container\">\n        <div class=\"row\" style=\"padding-bottom: 20px\">\n          <div class=\"columns one-half\">\n            <div class=\"field text required\"><span class=\"wpcf7-form-control-wrap\" data-name=\"company-name\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Company Name*\" value=\"\" type=\"text\" name=\"company-name\" \/><\/span>\n              <p class=\"info-tip\"><\/p>\n            <\/div>\n          <\/div>\n          <div class=\"columns one-half\">\n            <div class=\"field tel required\"><span class=\"wpcf7-form-control-wrap\" data-name=\"tel-536\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-tel wpcf7-validates-as-required wpcf7-text wpcf7-validates-as-tel\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Phone*\" value=\"\" type=\"tel\" name=\"tel-536\" \/><\/span>\n              <p class=\"info-tip\"><\/p>\n            <\/div>\n          <\/div>\n        <\/div>\n      <\/div>\n    <\/div>\n  <\/div>\n<\/div>\n<div class=\"container\">\n  <div class=\"row\" style=\"padding-bottom: 20px\">\n    <div class=\"columns full\">\n      <div class=\"field textarea required\"><span class=\"wpcf7-form-control-wrap\" data-name=\"Message\"><textarea cols=\"40\" rows=\"2\" maxlength=\"2000\" class=\"wpcf7-form-control wpcf7-textarea wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Message*\" name=\"Message\"><\/textarea><\/span>\n        <p class=\"info-tip\"><\/p>\n      <\/div>\n    <\/div>\n  <\/div>\n<\/div>\n<div class=\"container\">\n  <div class=\"row\" style=\"padding-bottom: 20px\">\n    <div class=\"columns full\">\n      <div class=\"field\"><label><\/label><div id=\"cf7sr-69e1f39140f99\" class=\"cf7sr-g-recaptcha\" data-theme=\"light\" data-type=\"image\" data-size=\"normal\" data-sitekey=\"6LcW5JAUAAAAAHRCNkfrX7zI14Oxgh2dP0KQg8Av\"><\/div><span class=\"wpcf7-form-control-wrap cf7sr-recaptcha\" data-name=\"cf7sr-recaptcha\"><input type=\"hidden\" name=\"cf7sr-recaptcha\" value=\"\" class=\"wpcf7-form-control\"><\/span>\n        <p class=\"info-tip\"><\/p>\n      <\/div>\n    <\/div>\n  <\/div>\n<\/div>\n<div class=\"container\">\n  <div class=\"row\" style=\"padding-bottom: 20px\">\n    <div class=\"columns full\">\n      <div class=\"field\"><label><\/label><span id=\"wpcf7-69e1f39140eb8-wrapper\" class=\"wpcf7-form-control-wrap email-wrap\" style=\"display:none !important; visibility:hidden !important;\"><label for=\"wpcf7-69e1f39140eb8-field\" class=\"hp-message\">Please leave this field empty.<\/label><input id=\"wpcf7-69e1f39140eb8-field\"  class=\"wpcf7-form-control wpcf7-text\" type=\"text\" name=\"email\" value=\"\" size=\"40\" tabindex=\"-1\" autocomplete=\"new-password\" \/><\/span>\n        <p class=\"info-tip\"><\/p>\n      <\/div>\n    <\/div>\n  <\/div>\n<\/div>\n<div class=\"container\">\n  <div class=\"row\">\n    <div class=\"columns one-fourth\">\n      <div class=\"field\"><label><\/label><input class=\"wpcf7-form-control wpcf7-submit has-spinner\" type=\"submit\" value=\"Send\" \/>\n        <p class=\"info-tip\"><\/p>\n      <\/div>\n    <\/div>\n  <\/div>\n<\/div><div class=\"wpcf7-response-output\" aria-hidden=\"true\"><\/div>\n<\/form>\n<\/div>\n<\/div><\/div>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"<p>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.Problems : 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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":268,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"2880","footnotes":""},"categories":[14],"tags":[],"class_list":["post-95","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-software-development"],"_links":{"self":[{"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/posts\/95","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/comments?post=95"}],"version-history":[{"count":14,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/posts\/95\/revisions"}],"predecessor-version":[{"id":311,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/posts\/95\/revisions\/311"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/media\/268"}],"wp:attachment":[{"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/media?parent=95"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/categories?post=95"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/tags?post=95"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}