Export to Multiple Excel Sheets

I saw a post with this same subject line, posted in July of 2006, but with no replies. I am now having precisely the same problem.

I am importing data from an OLE DB source. I want to directly store this data in an Excel file. There are far more than 65,536 rows in the DB table, but the version of Excel I have only tolerates a maximum of that many. My solution is to divide the data into separate worksheets within the same Excel file. At any given time, I do not know exactly how many rows are moving from the database to the Excel file, so is there a way to dynamically create a new worksheet every time I reach 65,536 rows?

Thank you.

Hi Allen,

there is no an easy way to do this.

I can give you a couple of not-so-easy options though:

1. Build a script or custom destination that will know how to split data, create and load sheets. You will need to talk to the OLE DB JET provider directly.

2. Do it in two passes:

- First pass; partiotion data by adding a new column to identify divided partitions and stage the new data in a table or flat file.

- Second pass; Build a package to find out how many partitions there is, create the destination sheets, and run a loop with number of iterations equal to number of partitions created in the previous step. In each iteration, run a child package that can filter data for its partition ans load it into an appropriate Excel sheet.

I am sure there are additional approaches to implement this. It depends on restrictions you are bound with: are you willing to write code, can you stage or preprocess data, etc.

Thanks.

|||Actually I've already gotten the data divided up through a script. Currently, I have 65,000 rows being sent to one Excel file, and all the excess rows offset to a temporary flat file. Then, I reiterate and draw another 65,000 lines out of that flat file and store it into a new Excel file. So basically I have everything set up, and I have multiple Excel file outputs, but I would prefer to combine all of this into a single Excel file with multiple worksheets. Is there an easy way to do this?

Thank you for the help.
|||

That should not be too hard: instead of generating new Excel files, per iteration, create sheets in the existing file. Use Execute SQL Task to create those sheets (DDL example: create table `<sheet_name>` (`<col1> VarChar[50], ...) ).

Let me know if you need more assistance.

|||

Hi Allen,

Myself facing similar problem wants to know how you achieved this task. Had you been successful achieving this task. Is it possible to post me lines of code or atleast provide the url which has:

1) Code that estimates the size of the data and divide the data based on size

2) Code that talks to Jet Provider for Excel directly to create and populate the worksheets using loop.

Many thanks

Subhash Subramanyam

|||It took me a few days of playing around in SSIS before I modified the process for my personal situation, but most of the methodology I got from here:
http://blogs.conchango.com/jamiethomson/archive/2005/12/04/SSIS-Nugget_3A00_-Splitting-a-file-into-multiple-files.aspx

I have no idea what Jet Provider is. Sorry I'm still very new to data manipulation.

If you have any other specific questions about how I modified the process for my own situation, feel free to ask after checking out that blog entry.

Export to Multiple Excel Sheets

I saw a post with this same subject line, posted in July of 2006, but with no replies. I am now having precisely the same problem.

I am importing data from an OLE DB source. I want to directly store this data in an Excel file. There are far more than 65,536 rows in the DB table, but the version of Excel I have only tolerates a maximum of that many. My solution is to divide the data into separate worksheets within the same Excel file. At any given time, I do not know exactly how many rows are moving from the database to the Excel file, so is there a way to dynamically create a new worksheet every time I reach 65,536 rows?

Thank you.

Hi Allen,

there is no an easy way to do this.

I can give you a couple of not-so-easy options though:

1. Build a script or custom destination that will know how to split data, create and load sheets. You will need to talk to the OLE DB JET provider directly.

2. Do it in two passes:

- First pass; partiotion data by adding a new column to identify divided partitions and stage the new data in a table or flat file.

- Second pass; Build a package to find out how many partitions there is, create the destination sheets, and run a loop with number of iterations equal to number of partitions created in the previous step. In each iteration, run a child package that can filter data for its partition ans load it into an appropriate Excel sheet.

I am sure there are additional approaches to implement this. It depends on restrictions you are bound with: are you willing to write code, can you stage or preprocess data, etc.

Thanks.

|||Actually I've already gotten the data divided up through a script. Currently, I have 65,000 rows being sent to one Excel file, and all the excess rows offset to a temporary flat file. Then, I reiterate and draw another 65,000 lines out of that flat file and store it into a new Excel file. So basically I have everything set up, and I have multiple Excel file outputs, but I would prefer to combine all of this into a single Excel file with multiple worksheets. Is there an easy way to do this?

Thank you for the help.
|||

That should not be too hard: instead of generating new Excel files, per iteration, create sheets in the existing file. Use Execute SQL Task to create those sheets (DDL example: create table `<sheet_name>` (`<col1> VarChar[50], ...) ).

Let me know if you need more assistance.

|||

Hi Allen,

Myself facing similar problem wants to know how you achieved this task. Had you been successful achieving this task. Is it possible to post me lines of code or atleast provide the url which has:

1) Code that estimates the size of the data and divide the data based on size

2) Code that talks to Jet Provider for Excel directly to create and populate the worksheets using loop.

Many thanks

Subhash Subramanyam

|||It took me a few days of playing around in SSIS before I modified the process for my personal situation, but most of the methodology I got from here:
http://blogs.conchango.com/jamiethomson/archive/2005/12/04/SSIS-Nugget_3A00_-Splitting-a-file-into-multiple-files.aspx

I have no idea what Jet Provider is. Sorry I'm still very new to data manipulation.

If you have any other specific questions about how I modified the process for my own situation, feel free to ask after checking out that blog entry.

Export to Mulitple Sheets in Excel

Hi,

I want to export data from SQL to Excel using Data Flow Task. But Excel file can only contains max. of 65,536 rows per sheet. How can I transfer data to multiple sheets if SQL table contains more that 650000 rows.

I am also looking for an answer to this. Very good question....

Export to Excel with Mutiple Sheets

Hi,
I have encountered this problem of not being able to export my different sub
reports to individual work sheets within excel. I have tried to put Page
breaks after each table, as this is all the sub reports contain. Thus after
each table a page break is inserted. If I preview the Report, containing all
the sub reports, it shows the correct page breaks. However when I export this
to Excel it gives me the following:
Sheet 1 - Document Map
Sheet 2 - First Sub Report
Sheet 3 - All the remainder of the Sub Reports straight after each other all
in one sheet.
I need to have the Sub Reports all in seperate sheets. Can anyone help,
please'
Thanks,
NatNat, I am experiencing the exact same problem. Have you gotten any info/reply
from experts? I really need answers, too.
thanks
"Nat" wrote:
> Hi,
> I have encountered this problem of not being able to export my different sub
> reports to individual work sheets within excel. I have tried to put Page
> breaks after each table, as this is all the sub reports contain. Thus after
> each table a page break is inserted. If I preview the Report, containing all
> the sub reports, it shows the correct page breaks. However when I export this
> to Excel it gives me the following:
> Sheet 1 - Document Map
> Sheet 2 - First Sub Report
> Sheet 3 - All the remainder of the Sub Reports straight after each other all
> in one sheet.
> I need to have the Sub Reports all in seperate sheets. Can anyone help,
> please'
> Thanks,
> Nat

Export to Excel -multiple sheets

Hi,

I am using .rdlc report in ASP.NET 2.0.

My report consists of 10 subreport and 1 main report. I want to export each subreport in separate sheets like Shee1 is Subreport1 and Sheet2 is Subreport2 etc... How can i do this.

Thanks.

The Excel renderer creates new worksheet tabs for each page in your report. To get a new page for each Subreport, put each of them inside a Rectangle and set PageBreakAtStart on the Rectangle to True.

-Chris

|||

I haven't been able to get the sub reports to show when exported to excel. Is there a trick to this?

Dwayne

|||

This works for me. However, what does not work, is using a subreport in a cell of a table and export that to Excel.

Regards, Jeroen

Export to Excel -multiple sheets

Hi,

I am using .rdlc report in ASP.NET 2.0.

My report consists of 10 subreport and 1 main report. I want to export each subreport in separate sheets like Shee1 is Subreport1 and Sheet2 is Subreport2 etc... How can i do this.

Thanks.

The Excel renderer creates new worksheet tabs for each page in your report. To get a new page for each Subreport, put each of them inside a Rectangle and set PageBreakAtStart on the Rectangle to True.

-Chris

|||

I haven't been able to get the sub reports to show when exported to excel. Is there a trick to this?

Dwayne

|||

This works for me. However, what does not work, is using a subreport in a cell of a table and export that to Excel.

Regards, Jeroen

|||Hi, related to Jeroen's Question...
"This works for me. However, what does not work, is using a subreport in a cell of a table and export that to Excel."

As a solution for this problem, we can have a rectangle within the table and place the subreport inside it, it allows to export. There is again few limitaions further but at least we can export the data of the subreport. Hope this helps.

Export to Excel -multiple sheets

Hi,

I am using .rdlc report in ASP.NET 2.0.

My report consists of 10 subreport and 1 main report. I want to export each subreport in separate sheets like Shee1 is Subreport1 and Sheet2 is Subreport2 etc... How can i do this.

Thanks.

The Excel renderer creates new worksheet tabs for each page in your report. To get a new page for each Subreport, put each of them inside a Rectangle and set PageBreakAtStart on the Rectangle to True.

-Chris

|||

I haven't been able to get the sub reports to show when exported to excel. Is there a trick to this?

Dwayne

|||

This works for me. However, what does not work, is using a subreport in a cell of a table and export that to Excel.

Regards, Jeroen

Export reports to excel with multiple sheets

I have read a bunch of posts here and never really found an answer on how you
export several reports to one excel spreadsheets with multiple worksheets. I
am sure this is possible but I have been unable to find out how to do it.
Thanks in advance.The Excel rendering extension will create one Excel file per report. You
cannot merge multiple reports into one Excel export file. If the report has
page breaks, it will split it into multiple worksheets.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
news:1902F02A-48CB-4417-BB13-80DA95EB6EAC@.microsoft.com...
>I have read a bunch of posts here and never really found an answer on how
>you
> export several reports to one excel spreadsheets with multiple worksheets.
> I
> am sure this is possible but I have been unable to find out how to do it.
> Thanks in advance.|||Thanks Robert that is exactly what I needed... In 2005 can you dynamically
rename the worksheets or do you know of any workaround (non 2005)?
"Robert Bruckner [MSFT]" wrote:
> The Excel rendering extension will create one Excel file per report. You
> cannot merge multiple reports into one Excel export file. If the report has
> page breaks, it will split it into multiple worksheets.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
> news:1902F02A-48CB-4417-BB13-80DA95EB6EAC@.microsoft.com...
> >I have read a bunch of posts here and never really found an answer on how
> >you
> > export several reports to one excel spreadsheets with multiple worksheets.
> > I
> > am sure this is possible but I have been unable to find out how to do it.
> > Thanks in advance.
>
>|||Sorry, this won't be in RS 2005. It is under consideration for a future
release.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
news:C679D12E-1E14-4644-9D4D-5267EA3DCB3D@.microsoft.com...
> Thanks Robert that is exactly what I needed... In 2005 can you
> dynamically
> rename the worksheets or do you know of any workaround (non 2005)?
> "Robert Bruckner [MSFT]" wrote:
>> The Excel rendering extension will create one Excel file per report. You
>> cannot merge multiple reports into one Excel export file. If the report
>> has
>> page breaks, it will split it into multiple worksheets.
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
>> news:1902F02A-48CB-4417-BB13-80DA95EB6EAC@.microsoft.com...
>> >I have read a bunch of posts here and never really found an answer on
>> >how
>> >you
>> > export several reports to one excel spreadsheets with multiple
>> > worksheets.
>> > I
>> > am sure this is possible but I have been unable to find out how to do
>> > it.
>> > Thanks in advance.
>>|||just a follow up question, robert. It seems like a very good 'feature' to
be able to name the worksheets from within Reporting Services. The lack of
this ability is a major issue for us at this shop.
dlr
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:O2wqqhzeFHA.3040@.TK2MSFTNGP14.phx.gbl...
> Sorry, this won't be in RS 2005. It is under consideration for a future
> release.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
> news:C679D12E-1E14-4644-9D4D-5267EA3DCB3D@.microsoft.com...
> > Thanks Robert that is exactly what I needed... In 2005 can you
> > dynamically
> > rename the worksheets or do you know of any workaround (non 2005)?
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> >> The Excel rendering extension will create one Excel file per report.
You
> >> cannot merge multiple reports into one Excel export file. If the report
> >> has
> >> page breaks, it will split it into multiple worksheets.
> >>
> >> -- Robert
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
> >> news:1902F02A-48CB-4417-BB13-80DA95EB6EAC@.microsoft.com...
> >> >I have read a bunch of posts here and never really found an answer on
> >> >how
> >> >you
> >> > export several reports to one excel spreadsheets with multiple
> >> > worksheets.
> >> > I
> >> > am sure this is possible but I have been unable to find out how to do
> >> > it.
> >> > Thanks in advance.
> >>
> >>
> >>
>|||There are two items that have prevented RS from being the complete Crystal
replacement where I work:
1- Multiple select parameter lists. This feature appears in 2005.
2- Being able to name worksheets. This feature does not.
I've seen this item requested numerous times and I'm disappointed that it's
not high enough on the wish list to get worked on. What I find especially
onerous is that for single-worksheet reports the sheet DOES get named so the
renderer, somewhere, knows how to do this. It shouldn't be that big of a
leap to be able to set the sheetname by the value determining the pagebreak.
I'm having to work through a process where we have the report rendered to
Excel and saved on the server, then directly modify the excel object, and
THEN return it to the requester.
"Dennis Redfield" wrote:
> just a follow up question, robert. It seems like a very good 'feature' to
> be able to name the worksheets from within Reporting Services. The lack of
> this ability is a major issue for us at this shop.
> dlr
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:O2wqqhzeFHA.3040@.TK2MSFTNGP14.phx.gbl...
> > Sorry, this won't be in RS 2005. It is under consideration for a future
> > release.
> >
> > -- Robert
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
> > news:C679D12E-1E14-4644-9D4D-5267EA3DCB3D@.microsoft.com...
> > > Thanks Robert that is exactly what I needed... In 2005 can you
> > > dynamically
> > > rename the worksheets or do you know of any workaround (non 2005)?
> > >
> > > "Robert Bruckner [MSFT]" wrote:
> > >
> > >> The Excel rendering extension will create one Excel file per report.
> You
> > >> cannot merge multiple reports into one Excel export file. If the report
> > >> has
> > >> page breaks, it will split it into multiple worksheets.
> > >>
> > >> -- Robert
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > >> rights.
> > >>
> > >>
> > >> "Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
> > >> news:1902F02A-48CB-4417-BB13-80DA95EB6EAC@.microsoft.com...
> > >> >I have read a bunch of posts here and never really found an answer on
> > >> >how
> > >> >you
> > >> > export several reports to one excel spreadsheets with multiple
> > >> > worksheets.
> > >> > I
> > >> > am sure this is possible but I have been unable to find out how to do
> > >> > it.
> > >> > Thanks in advance.
> > >>
> > >>
> > >>
> >
> >
>
>|||I was just searching for the answer to this question and see you are exactly
where I was. Since a single worksheet is named, I assumed that there must be
a way to get my group name to appear as the worksheet name. I guess I need
look no further.
MS, if you are listening, this would be a welcome feature in the next update.
"Todd" wrote:
> There are two items that have prevented RS from being the complete Crystal
> replacement where I work:
> 1- Multiple select parameter lists. This feature appears in 2005.
> 2- Being able to name worksheets. This feature does not.
> I've seen this item requested numerous times and I'm disappointed that it's
> not high enough on the wish list to get worked on. What I find especially
> onerous is that for single-worksheet reports the sheet DOES get named so the
> renderer, somewhere, knows how to do this. It shouldn't be that big of a
> leap to be able to set the sheetname by the value determining the pagebreak.
> I'm having to work through a process where we have the report rendered to
> Excel and saved on the server, then directly modify the excel object, and
> THEN return it to the requester.
> "Dennis Redfield" wrote:
> > just a follow up question, robert. It seems like a very good 'feature' to
> > be able to name the worksheets from within Reporting Services. The lack of
> > this ability is a major issue for us at this shop.
> >
> > dlr
> >
> > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> > news:O2wqqhzeFHA.3040@.TK2MSFTNGP14.phx.gbl...
> > > Sorry, this won't be in RS 2005. It is under consideration for a future
> > > release.
> > >
> > > -- Robert
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > >
> > > "Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
> > > news:C679D12E-1E14-4644-9D4D-5267EA3DCB3D@.microsoft.com...
> > > > Thanks Robert that is exactly what I needed... In 2005 can you
> > > > dynamically
> > > > rename the worksheets or do you know of any workaround (non 2005)?
> > > >
> > > > "Robert Bruckner [MSFT]" wrote:
> > > >
> > > >> The Excel rendering extension will create one Excel file per report.
> > You
> > > >> cannot merge multiple reports into one Excel export file. If the report
> > > >> has
> > > >> page breaks, it will split it into multiple worksheets.
> > > >>
> > > >> -- Robert
> > > >> This posting is provided "AS IS" with no warranties, and confers no
> > > >> rights.
> > > >>
> > > >>
> > > >> "Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
> > > >> news:1902F02A-48CB-4417-BB13-80DA95EB6EAC@.microsoft.com...
> > > >> >I have read a bunch of posts here and never really found an answer on
> > > >> >how
> > > >> >you
> > > >> > export several reports to one excel spreadsheets with multiple
> > > >> > worksheets.
> > > >> > I
> > > >> > am sure this is possible but I have been unable to find out how to do
> > > >> > it.
> > > >> > Thanks in advance.
> > > >>
> > > >>
> > > >>
> > >
> > >
> >
> >
> >|||I've seen several places on the Net where different Microsoft reps have said
that the rename feature was under consideration.
Since this is apparently such a widely requested thing, why is it not being
put into a version. It continually is up for being in "the next version".
Why not just put it in?
"William" wrote:
> I was just searching for the answer to this question and see you are exactly
> where I was. Since a single worksheet is named, I assumed that there must be
> a way to get my group name to appear as the worksheet name. I guess I need
> look no further.
> MS, if you are listening, this would be a welcome feature in the next update.
> "Todd" wrote:
> > There are two items that have prevented RS from being the complete Crystal
> > replacement where I work:
> >
> > 1- Multiple select parameter lists. This feature appears in 2005.
> > 2- Being able to name worksheets. This feature does not.
> >
> > I've seen this item requested numerous times and I'm disappointed that it's
> > not high enough on the wish list to get worked on. What I find especially
> > onerous is that for single-worksheet reports the sheet DOES get named so the
> > renderer, somewhere, knows how to do this. It shouldn't be that big of a
> > leap to be able to set the sheetname by the value determining the pagebreak.
> >
> > I'm having to work through a process where we have the report rendered to
> > Excel and saved on the server, then directly modify the excel object, and
> > THEN return it to the requester.
> >
> > "Dennis Redfield" wrote:
> >
> > > just a follow up question, robert. It seems like a very good 'feature' to
> > > be able to name the worksheets from within Reporting Services. The lack of
> > > this ability is a major issue for us at this shop.
> > >
> > > dlr
> > >
> > > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> > > news:O2wqqhzeFHA.3040@.TK2MSFTNGP14.phx.gbl...
> > > > Sorry, this won't be in RS 2005. It is under consideration for a future
> > > > release.
> > > >
> > > > -- Robert
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > >
> > > >
> > > > "Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
> > > > news:C679D12E-1E14-4644-9D4D-5267EA3DCB3D@.microsoft.com...
> > > > > Thanks Robert that is exactly what I needed... In 2005 can you
> > > > > dynamically
> > > > > rename the worksheets or do you know of any workaround (non 2005)?
> > > > >
> > > > > "Robert Bruckner [MSFT]" wrote:
> > > > >
> > > > >> The Excel rendering extension will create one Excel file per report.
> > > You
> > > > >> cannot merge multiple reports into one Excel export file. If the report
> > > > >> has
> > > > >> page breaks, it will split it into multiple worksheets.
> > > > >>
> > > > >> -- Robert
> > > > >> This posting is provided "AS IS" with no warranties, and confers no
> > > > >> rights.
> > > > >>
> > > > >>
> > > > >> "Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
> > > > >> news:1902F02A-48CB-4417-BB13-80DA95EB6EAC@.microsoft.com...
> > > > >> >I have read a bunch of posts here and never really found an answer on
> > > > >> >how
> > > > >> >you
> > > > >> > export several reports to one excel spreadsheets with multiple
> > > > >> > worksheets.
> > > > >> > I
> > > > >> > am sure this is possible but I have been unable to find out how to do
> > > > >> > it.
> > > > >> > Thanks in advance.
> > > > >>
> > > > >>
> > > > >>
> > > >
> > > >
> > >
> > >
> > >|||Not being able to name sheets has prevented migration of reports and to
really sell Reporting Services. My clients don't like change... they're used
to looking at sheetnames and are not fond of the index page. I can't sell my
clients on a server if they don't care for the reports.
Please put this feature in a service pack that RS 2000 can use.
Darren, one thing I believe I've read in the past is sheet names were
dropped due to crashes from international character support in Excel.
"Darren" wrote:
> I've seen several places on the Net where different Microsoft reps have said
> that the rename feature was under consideration.
> Since this is apparently such a widely requested thing, why is it not being
> put into a version. It continually is up for being in "the next version".
> Why not just put it in?
>
> "William" wrote:
> > I was just searching for the answer to this question and see you are exactly
> > where I was. Since a single worksheet is named, I assumed that there must be
> > a way to get my group name to appear as the worksheet name. I guess I need
> > look no further.
> >
> > MS, if you are listening, this would be a welcome feature in the next update.
> >
> > "Todd" wrote:
> >
> > > There are two items that have prevented RS from being the complete Crystal
> > > replacement where I work:
> > >
> > > 1- Multiple select parameter lists. This feature appears in 2005.
> > > 2- Being able to name worksheets. This feature does not.
> > >
> > > I've seen this item requested numerous times and I'm disappointed that it's
> > > not high enough on the wish list to get worked on. What I find especially
> > > onerous is that for single-worksheet reports the sheet DOES get named so the
> > > renderer, somewhere, knows how to do this. It shouldn't be that big of a
> > > leap to be able to set the sheetname by the value determining the pagebreak.
> > >
> > > I'm having to work through a process where we have the report rendered to
> > > Excel and saved on the server, then directly modify the excel object, and
> > > THEN return it to the requester.
> > >
> > > "Dennis Redfield" wrote:
> > >
> > > > just a follow up question, robert. It seems like a very good 'feature' to
> > > > be able to name the worksheets from within Reporting Services. The lack of
> > > > this ability is a major issue for us at this shop.
> > > >
> > > > dlr
> > > >
> > > > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> > > > news:O2wqqhzeFHA.3040@.TK2MSFTNGP14.phx.gbl...
> > > > > Sorry, this won't be in RS 2005. It is under consideration for a future
> > > > > release.
> > > > >
> > > > > -- Robert
> > > > > This posting is provided "AS IS" with no warranties, and confers no
> > > > rights.
> > > > >
> > > > >
> > > > > "Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
> > > > > news:C679D12E-1E14-4644-9D4D-5267EA3DCB3D@.microsoft.com...
> > > > > > Thanks Robert that is exactly what I needed... In 2005 can you
> > > > > > dynamically
> > > > > > rename the worksheets or do you know of any workaround (non 2005)?
> > > > > >
> > > > > > "Robert Bruckner [MSFT]" wrote:
> > > > > >
> > > > > >> The Excel rendering extension will create one Excel file per report.
> > > > You
> > > > > >> cannot merge multiple reports into one Excel export file. If the report
> > > > > >> has
> > > > > >> page breaks, it will split it into multiple worksheets.
> > > > > >>
> > > > > >> -- Robert
> > > > > >> This posting is provided "AS IS" with no warranties, and confers no
> > > > > >> rights.
> > > > > >>
> > > > > >>
> > > > > >> "Shoeman" <Shoeman@.discussions.microsoft.com> wrote in message
> > > > > >> news:1902F02A-48CB-4417-BB13-80DA95EB6EAC@.microsoft.com...
> > > > > >> >I have read a bunch of posts here and never really found an answer on
> > > > > >> >how
> > > > > >> >you
> > > > > >> > export several reports to one excel spreadsheets with multiple
> > > > > >> > worksheets.
> > > > > >> > I
> > > > > >> > am sure this is possible but I have been unable to find out how to do
> > > > > >> > it.
> > > > > >> > Thanks in advance.
> > > > > >>
> > > > > >>
> > > > > >>
> > > > >
> > > > >
> > > >
> > > >
> > > >