Hi all--
I was just wondering if someone could tell me what the differences between/ pros and cons of MSOFFICE2K vs tagsets.excelxp when creating ecxel spreadsheets/workbooks.
Thank you--
Hi:
There have been MANY previous forum postings about the differences. The features are really up to you whether they're pros or cons. If the inclusion of images or logos is important to you than you might stick with HTML methods and ODS MSOFFICE2K. If multi-sheet workbooks is important to you and you do not have graphs or images to include, then ODS TAGSETS.EXCELXP is a better choice.
Bottom line is that neither method creates "true, binary, proprietary" Excel files. When you use ODS methods, you are creating ASCII text files that Excel knows how to open and render so that you report looks like a workbook with worksheets. If you open your files from ODS with Notepad you will see either HTML tags or XML tags in the file:
ODS MSOFFICE2K creates Microsoft "flavor" of HTML tags
ODS TAGSETS.EXCELXP creates Microsoft "flavor" of XML tags for Spreadsheet Markup Language 2003
cynthia
Short Comparison:
ODS MSOFFICE2K ODS TAGSETS.EXCELXP
What Is Created Microsoft "flavor" HTML Microsoft "flavor" of XML
created in Office 2000 created for Spreadsheet Markup
XML as defined in Office 2003
How Excel renders Uses SAS style Uses SAS style
Only 1 sheet in 1 workbook Multiple sheets in 1 workbook
Include Images? Yes No
How to override
Excel defaults STYLE= override (HTMLSTYLE) STYLE= override (TAGATTR)
Version Excel Office 2000 and higher Office 2003 and higher
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.