https://communities.sas.com/t5/SAS-Programming/Is-it-possible-to-extract-the-signer-Signature-used-in-an-Excel/m-p/775494#M246512 <P>All,</P><P>&nbsp;</P><P>We use a large number of excel files provided by vendors that include their respective signature as shown below.&nbsp; I was wondering if their is a way of getting that information out of the xlsx file.</P><P>&nbsp;</P><P>Thanks.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="carlos_m_jimenez_0-1634757854025.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/64900i55F59DC0328CB5DA/image-size/medium?v=v2&amp;px=400" role="button" title="carlos_m_jimenez_0-1634757854025.png" alt="carlos_m_jimenez_0-1634757854025.png" /></span></P><P>&nbsp;</P> Wed, 20 Oct 2021 19:27:01 GMT carlos_jimenez 2021-10-20T19:27:01Z https://communities.sas.com/t5/SAS-Programming/Is-it-possible-to-extract-the-signer-Signature-used-in-an-Excel/m-p/775494#M246512 <P>All,</P><P>&nbsp;</P><P>We use a large number of excel files provided by vendors that include their respective signature as shown below.&nbsp; I was wondering if their is a way of getting that information out of the xlsx file.</P><P>&nbsp;</P><P>Thanks.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="carlos_m_jimenez_0-1634757854025.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/64900i55F59DC0328CB5DA/image-size/medium?v=v2&amp;px=400" role="button" title="carlos_m_jimenez_0-1634757854025.png" alt="carlos_m_jimenez_0-1634757854025.png" /></span></P><P>&nbsp;</P> Wed, 20 Oct 2021 19:27:01 GMT https://communities.sas.com/t5/SAS-Programming/Is-it-possible-to-extract-the-signer-Signature-used-in-an-Excel/m-p/775494#M246512 carlos_jimenez 2021-10-20T19:27:01Z https://communities.sas.com/t5/SAS-Programming/Is-it-possible-to-extract-the-signer-Signature-used-in-an-Excel/m-p/775517#M246521 Yes and No.<BR />Easily, not that I'm aware of. <BR />However, an XLSX file is a zipped XML file, so you'll find it in the contents if you unzip it. You could probably also access it via VBS called from SAS. Wed, 20 Oct 2021 20:59:19 GMT https://communities.sas.com/t5/SAS-Programming/Is-it-possible-to-extract-the-signer-Signature-used-in-an-Excel/m-p/775517#M246521 Reeza 2021-10-20T20:59:19Z https://communities.sas.com/t5/SAS-Programming/Is-it-possible-to-extract-the-signer-Signature-used-in-an-Excel/m-p/775532#M246525 <P>To complete&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/13879">@Reeza</a>&nbsp;'s reply, 2 methods::</P> <P>1- Read the xlsx file as a zip file and read the xml files inside, see&nbsp;<A href="https://blogs.sas.com/content/sasdummy/2015/05/11/using-filename-zip-to-unzip-and-read-data-files-in-sas/" target="_blank">https://blogs.sas.com/content/sasdummy/2015/05/11/using-filename-zip-to-unzip-and-read-data-files-in-sas/</A></P> <P>2- Write a vbs script that reads the xlsx file and run it from SAS</P> <P>&nbsp;</P> Wed, 20 Oct 2021 23:59:15 GMT https://communities.sas.com/t5/SAS-Programming/Is-it-possible-to-extract-the-signer-Signature-used-in-an-Excel/m-p/775532#M246525 ChrisNZ 2021-10-20T23:59:15Z https://communities.sas.com/t5/SAS-Programming/Is-it-possible-to-extract-the-signer-Signature-used-in-an-Excel/m-p/775640#M246567 I was able to obtain pieces of information useful in my process. Thank you! Thu, 21 Oct 2021 13:14:18 GMT https://communities.sas.com/t5/SAS-Programming/Is-it-possible-to-extract-the-signer-Signature-used-in-an-Excel/m-p/775640#M246567 carlos_jimenez 2021-10-21T13:14:18Z