DATA Step, Macro, Functions and more

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

Reply
Contributor
Posts: 72

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

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
SAS Super FREQ
Posts: 8,866

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

Posted in reply to anandbillava
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
Contributor
Posts: 72

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

Posted in reply to Cynthia_sas
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.
SAS Super FREQ
Posts: 8,866

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

Posted in reply to anandbillava
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
Contributor
Posts: 72

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

Posted in reply to Cynthia_sas
Thanks Cynthia. But I am working to create a single file. I might use other programming language and try to call it from SAS.
Ask a Question
Discussion stats
  • 4 replies
  • 329 views
  • 0 likes
  • 2 in conversation