topic Re: ODs excelxp and msoffice2k_x (Image, multiple worksheet and paneling) in SAS Programming

ODs excelxp and msoffice2k_x (Image, multiple worksheet and paneling)

anandbillava — Thu, 23 Dec 2010 19:41:40 GMT

There are drawback from above ods tagsets.
Excelxp does not support image where as msofficex2k_k does.
Msofficex2k support paneling where as excelxp not.
Excelxp does support multiple worksheets but msofficex2k not.

I want to use all the three features in one of the program. Can anybody suggest some idea ?
Image, Paneling and Multiple worksheet.

Many thanks in advance

Re: ODs excelxp and msoffice2k_x (Image, multiple worksheet and paneling)

Cynthia_sas — Thu, 23 Dec 2010 20:28:32 GMT

Hi:
TAGSETS.MSOFFICE2K_X -does- support multiple worksheets -- not quite as seamlessly as TAGSETS.EXCELXP, but it does support multiple worksheets.

I suggest you update your template store to include TAGSETS.MSOFFICE2K_X, as described here and then run some of the examples, also found on this page:
http://support.sas.com/rnd/base/ods/odsmarkup/msoffice2k/index.html

The Introduction explains how to get the new TAGSET template for MSOFFICE2K_X and the list of examples shows how to create a multi-sheet workbook.

Do remember that the limitations of MSOFFICE2K, MSOFFICE2K_X and ExcelXP are inherent in the nature of each file specification, as determined by Microsoft. MSOFFICE2K and MSOFFICE2K_X both create HTML-based files (although the MSOFFICE2K_X mixes a bit of XML into the HTML mix -- per Microsoft design) and TAGSETS.EXCELXP creates pure Spreadsheet Markup Language XML -- also per Microsoft design. It is by Microsoft design that Spreadsheet Markup Language XML does not support image inclusion.

cynthia

Re: ODs excelxp and msoffice2k_x (Image, multiple worksheet and paneling)

anandbillava — Thu, 23 Dec 2010 20:33:00 GMT

Hi Cynthia, Thanks for the reply. I came across msoffice2k_x multiple worksheet. but this does not work as excelxp. What I am trying to say it creates links to the html files. I am trying to create a single file which will have everything.

Re: ODs excelxp and msoffice2k_x (Image, multiple worksheet and paneling)

Cynthia_sas — Thu, 23 Dec 2010 20:45:39 GMT

You might be able to use the technique designed in this presentation from a user-group a while ago:
http://support.sas.com/rnd/base/ods/excel/multisheet_excel_post.ppt

It describes how to create multi-sheet workbooks by creating multiple HTML files, storing the files in a special folder structure, creating a manual FILELIST.XML file and creating a "driver" HTML file. You still have to manually save the "linked" files as an XLS workbook. I have successfully used this technique and described it in more detail in previous forum postings:
http://support.sas.com/forums/thread.jspa?messageID=35199西
http://support.sas.com/forums/thread.jspa?messageID=8132ῄ
http://support.sas.com/forums/thread.jspa?messageID=18828䦌
http://support.sas.com/forums/thread.jspa?messageID=12780㇬

(But I don't do much anymore with the technique since the advent of TAGSETS.EXCELXP.)

That's the only thing I can think of.

cynthia

Re: ODs excelxp and msoffice2k_x (Image, multiple worksheet and paneling)

anandbillava — Fri, 24 Dec 2010 00:02:56 GMT

Thanks Cynthia. But I am working to create a single file. I might use other programming language and try to call it from SAS.