Naming Sheets in Excel Export

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob - 27 Feb 2007 12:28 GMT

Can anyone tell me how to name the sheets on an export to Excel? Lets
say I have two tables and my interactive format is set to 8.5,0 on
each so the output will contain sheet1 and sheet2, one for each table?

Is there a way to name the sheets the table name or some field within?

Thanks
Bob

Reply to this Message

Wayne Snyder - 27 Feb 2007 13:47 GMT

I am a little hesitant to tell you this, because I am old, and may not be
remembering well...

But I thought I read something a while back, that said to create a report,
and add subreports. When exported to Excel, each subreport became a sheet
with the name of the subreport..

Might be worth testing to see..

Signature

Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC

I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.

> Can anyone tell me how to name the sheets on an export to Excel? Lets
> say I have two tables and my interactive format is set to 8.5,0 on
[quoted text clipped - 4 lines]
> Thanks
> Bob

Reply to this Message

Amarnath - 28 Feb 2007 09:05 GMT

Depending on the pagination you get no of sheets and the default is the
sheet1, sheet2 etc.. no name change

Amarnath

> Can anyone tell me how to name the sheets on an export to Excel? Lets
> say I have two tables and my interactive format is set to 8.5,0 on
[quoted text clipped - 4 lines]
> Thanks
> Bob

Reply to this Message