https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-read-import-file-metadata/m-p/618250#M23705 <P>Hi:<BR />Don't you have the original file that created these document-level elements?</P> <P>&nbsp;</P> <P>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:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="where_document_properties.png" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/35436iA7360E4A9A95F69F/image-size/large?v=v2&amp;px=999" role="button" title="where_document_properties.png" alt="where_document_properties.png" /></span></P> <P>Once you get to the CORE.XML file, then you'll need to read/parse it with SAS.</P> <P><BR />Cynthia</P> Sat, 18 Jan 2020 13:49:09 GMT Cynthia_sas 2020-01-18T13:49:09Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-read-import-file-metadata/m-p/618211#M23704 <P>Hi,</P><P>ods excel allows us to create xlsx file metadata (title, keywords, status, category, author...).</P><P>Is there a way to import / extract this information from an xlsx file using SAS ?</P><P>Best Regards</P> Fri, 17 Jan 2020 22:06:42 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-read-import-file-metadata/m-p/618211#M23704 xxformat_com 2020-01-17T22:06:42Z https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-read-import-file-metadata/m-p/618250#M23705 <P>Hi:<BR />Don't you have the original file that created these document-level elements?</P> <P>&nbsp;</P> <P>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:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="where_document_properties.png" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/35436iA7360E4A9A95F69F/image-size/large?v=v2&amp;px=999" role="button" title="where_document_properties.png" alt="where_document_properties.png" /></span></P> <P>Once you get to the CORE.XML file, then you'll need to read/parse it with SAS.</P> <P><BR />Cynthia</P> Sat, 18 Jan 2020 13:49:09 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/ods-excel-read-import-file-metadata/m-p/618250#M23705 Cynthia_sas 2020-01-18T13:49:09Z