Date:         Thu, 1 Oct 2009 13:09:23 -0400
Reply-To:     Stephen Dybas <skd02@HEALTH.STATE.NY.US>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Stephen Dybas <skd02@HEALTH.STATE.NY.US>
Subject:      Re: ODS tagsets.excelxp: What is possible and what not?
Comments: To: Alexander Konn <alexander.konn@IEA-DPC.DE>
Content-Type: text/plain; charset=ISO-8859-1

Alexander,

Sounds like a tall order.

I would start by running a Google search on:

Creating Multi-Sheet Excel Workbooks the Easy Way with SAS

( http://support.sas.com/rnd/papers/sgf07/sgf2007-excel.pdf )

or

You Use SAS®, Your Boss Uses Excel. Guess Where Your Results Are
Going to Appear! Using ODS to Create Your Results in Excel

Steve Dybas



On Thu, 1 Oct 2009 08:36:03 -0700, Alex <alexander.konn@IEA-DPC.DE> wrote:

>Hi everyone,
>
>Today I looked into ODS markup for the first time and tried to figure
>out whether I could fulfill my current task with ODS tagsets.excelxp.
>I read through the help text that I generated with "ods
>tagsets.excelxp options ( doc = 'help' ) ;" and my impression is that
>I can't fulfill my requirements like this. My alternative to using ODS
>would be to create a basic xls workbook without the fancy stuff
>described below and then format this using VB.Net or C#. But I would
>much prefer to solve this in SAS.
>
>Here's what I need to do:
>- Create one Excel workbook containing dozens of sheets, each one
>containing the cells from a SAS data set
>- Create table of contents sheets for subsets of data sets which
>belong together. These special sheets must contain one row per sheet
>belonging to the subset, a hyperlink to every sheet of the subset, and
>the row count for every sheet. It should look more or less like this:
>SHEET_NAME, ROW_COUNT, LINK, ... <more columns>
>Sheet1, 25, <Link>, ...<more values>
>Sheet2, 13, <Link>, ...<more values>
>- One overall toc sheet linking to the several toc sheets for the
>subsets
>- Every "normal" sheet (not the toc sheets) must contain a header
>above the data values which has to span across multiple lines and must
>contain a hyperlink to the toc sheet for its subset
>- Some columns in the "normal" sheets must be hidden
>- several color, formatting and highlighting requirements...
>
>Now how would you guys solve this? Any ideas will greatly be
>appreciated!
>
>Thanks a lot!
>Alex