https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-use-ods-tagsets-excelXP-to-generate-xlsx-file/m-p/8571#M2860 I find ods tagsets.excelXP statement can't support xlsx as file extension, or the output file can't be opened correctly. Fri, 23 Apr 2010 06:12:03 GMT qkaiwei 2010-04-23T06:12:03Z https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-use-ods-tagsets-excelXP-to-generate-xlsx-file/m-p/8571#M2860 I find ods tagsets.excelXP statement can't support xlsx as file extension, or the output file can't be opened correctly. Fri, 23 Apr 2010 06:12:03 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-use-ods-tagsets-excelXP-to-generate-xlsx-file/m-p/8571#M2860 qkaiwei 2010-04-23T06:12:03Z https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-use-ods-tagsets-excelXP-to-generate-xlsx-file/m-p/8572#M2861 Hi:<BR /> ODS TAGSETS.EXCELXP creates Excel 2002/2003 Spreadsheet Markup Language XML files -- this conforms to an XML standard that existed -before- the newest Office 2007 XML standard.<BR /> <BR /> You cannot create .XLSX files using ODS TAGSETS.EXCELXP. An XLSX file is actually a zip archive of a set of related files -- all of which taken together make up a workbook/worksheet definition in Office 2007 XML. This is a different standard than the 2003 standard.<BR /> <BR /> The only way to create XLSX files for Office 2007 is to use the SAS Excel Libname engine (or other methods) as described in this Tech Support note:<BR /> <A href="http://support.sas.com/kb/32/455.html" target="_blank">http://support.sas.com/kb/32/455.html</A><BR /> <BR /> cynthia Fri, 23 Apr 2010 07:52:35 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/How-to-use-ods-tagsets-excelXP-to-generate-xlsx-file/m-p/8572#M2861 Cynthia_sas 2010-04-23T07:52:35Z