tagsets.msoffice2k_x and Multiple Sheets

KimLeBouton · Posted 08-01-2011 08:52 PM

Has anyone been able to get the following example, http://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/index.html#multiple, to work with either SAS 9.13 or SAS 9.2 (TS2M3) and Excel 2003?

Even after fixing the syntax error, Excel reports back that the spreadsheet has a serious error.

TIA,

Kim LeBouton

art297 · Posted 08-01-2011 11:20 PM

Kim,

Don't tell Vince, but I've been able to avoid tagsets all of these years. However, that said, if you post your code and a sample data set, I'd be glad to take a look.

Art

Andre · Posted 08-02-2011 06:36 AM

Kim,

i have tried the sample under 9.2.3 with the minor correction

and the opening was without problems under excel2010

and after transportation of the file upon a pc whith excel2003

the htm file (even with a .xls suffix) was opening well

perhaps has the office 2003 the addon for reading .xlsx files

but in our matter as the code is html, i have no idea why you have had trouble

HTH

Andre

procsort data=sashelp.classout=test;

by age;

run;

ods tagsets.msoffice2k path="d:\temp" file="temp.html" newfile=output;

proc print data=test;

by age;

run;

ods tagsets.msoffice2k close;

ods tagsets.msoffice2k_x file="d:\temp\tempmultiple.xls" style=statistical

options(worksheet_source="11#d:\temp\temp.html,

12#d:\temp\temp1.html,

13#d:\temp\temp2.html,

14#d:\temp\temp3.html,

15#d:\temp\temp4.html,

16#d:\temp\temp5.html"

);

data _null_;

file print;

put "test";

run;

ods tagsets.msoffice2k_x close;

the content of tempmultiple.xls is the following text

<head>

<title>SAS Output</title>

<!--

-->

</style>

<!--

function startup(){

}

function shutdown(){

}

//-->

</script>

<!--[if gte mso 9]><xml>

<x:ExcelWorkbook>

<x:ExcelWorksheets>

<x:ExcelWorksheet>

<x:Name>11</x:Name>

<x:WorksheetSource HRef="d:\temp\temp.html"/>

</x:ExcelWorksheet>

<x:ExcelWorksheet>

<x:Name>12</x:Name>

<x:WorksheetSource HRef="d:\temp\temp1.html"/>

</x:ExcelWorksheet>

<x:ExcelWorksheet>

<x:Name>13</x:Name>

<x:WorksheetSource HRef="d:\temp\temp2.html"/>

</x:ExcelWorksheet>

<x:ExcelWorksheet>

<x:Name>14</x:Name>

<x:WorksheetSource HRef="d:\temp\temp3.html"/>

</x:ExcelWorksheet>

<x:ExcelWorksheet>

<x:Name>15</x:Name>

<x:WorksheetSource HRef="d:\temp\temp4.html"/>

</x:ExcelWorksheet>

<x:ExcelWorksheet>

<x:Name>16</x:Name>

<x:WorksheetSource HRef="d:\temp\temp5.html"/>

</x:ExcelWorksheet>

</x:ExcelWorksheets>

<x:WindowHeight>12495</x:WindowHeight>

<x:WindowWidth>18900</x:WindowWidth>

<x:WindowTopX>60</x:WindowTopX>

<x:WindowTopY>45</x:WindowTopY>

<x:ProtectStructure>False</x:ProtectStructure>

<x:ProtectWindows>False</x:ProtectWindows>

</x:ExcelWorkbook>

</xml><![endif]-->

</head>

<!--

var _info = navigator.userAgent

var _ie = (_info.indexOf("MSIE") > 0

&& _info.indexOf("Win") > 0

&& _info.indexOf("Windows 3.1") < 0);

//-->

</script>

<h1 class="SystemTitle">Le Système SAS</h1>

<div>

<pre class="Batch" style=" padding: 7px; border-spacing: 1px; border: 1px solid #000000; text-align: left;">test

</pre></td></tr>

</table>

</div>

<br>

</div>

</body>

</html>