Is it possible to extract the signer 'Signature' used in an Excel file?

[carlos_jimenez]

All,

We use a large number of excel files provided by vendors that include their respective signature as shown below.  I was wondering if their is a way of getting that information out of the xlsx file.

Thanks.

[Reeza]

Yes and No.
Easily, not that I'm aware of.
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.

[ChrisNZ · Accepted solution]

To complete @Reeza 's reply, 2 methods::

1- Read the xlsx file as a zip file and read the xml files inside, see https://blogs.sas.com/content/sasdummy/2015/05/11/using-filename-zip-to-unzip-and-read-data-files-in...

2- Write a vbs script that reads the xlsx file and run it from SAS

[carlos_jimenez]

I was able to obtain pieces of information useful in my process. Thank you!