Hi:
When you use TAGSETS.EXCELXP within EG, you -cannot- open the XML file from the EG interface. The reason is that EG wants all XML files to be SASReport XML -- but the TAGSETS.EXCELXP file is NOT SASReport XML. If, however, you go to Windows Explorer and locate the file you just created and right-mouse click to open it -- or open the file from within Excel, then you should not have any problems. These Tech Support notes outline some of the issues that EG has with XML files:
http://support.sas.com/kb/32/924.html
http://support.sas.com/kb/32/133.html
As for your other question, you need to check out some of the sub-options that can be used with TAGSETS.EXCELXP, in particular, the sheet_name sub-option and, I believe, the sheet_interval sub-option. You use the sheet_interval sub-option to control how many tables should be put on one sheet. If you look at the internal documentation, you will see this description:
[pre]
Sheet_Interval: Default Value 'Table'
Values: Table, Page, Bygroup, Proc, None.
This option controls how many tables will go in a worksheet.
In reality only one table is allowed per worksheet. To get more
than one table, the tables are actually combined into one.
Specifying a sheet interval will cause the current worksheet to close.
It is recommended that this always be the first option to insure that
The options following it apply to the new worksheet rather than the
last worksheet.
[/pre]
A good paper that discusses the use of many of the EXCELXP suboptions is here:
http://www.nesug.org/proceedings/nesug08/ap/ap06.pdf (sheet_interval is discussed on page 9)
cynthia