ods excel - read/import file metadata

[xxformat_com]

Hi,

ods excel allows us to create xlsx file metadata (title, keywords, status, category, author...).

Is there a way to import / extract this information from an xlsx file using SAS ?

Best Regards

[Cynthia_sas]

Hi:
Don't you have the original file that created these document-level elements?

It will not be easy to do what you want. Assuming you used SAS to create the XLSX file in the first place, you need to read the CORE.XML file that is in the docProps folder of the XLSX archive (since an XLSX file is not one file, but is a collection of compressed files), as shown below:

Once you get to the CORE.XML file, then you'll need to read/parse it with SAS.

Cynthia