BookmarkSubscribeRSS Feed
anandbillava
Fluorite | Level 6
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
4 REPLIES 4
Cynthia_sas
SAS Super FREQ
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
anandbillava
Fluorite | Level 6
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.
Cynthia_sas
SAS Super FREQ
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
anandbillava
Fluorite | Level 6
Thanks Cynthia. But I am working to create a single file. I might use other programming language and try to call it from SAS.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1001 views
  • 0 likes
  • 2 in conversation