I am writing a c#.net 2005 desktop application and I need to take data from
sql server 2005 and and export the data to excel 2003 spreadsheets. I see
that there is a report viewer control. Can I use a report viewer control to
export the data to excel? (Note: The rows in the excel spreadsheet would be
wider that a regular 8" by 11" paper and probably wider than legal paper.)
Can the report viewer control handle this width option? If so, can you show
me some code that I use as a reference to follow? If not, can you make a
recommendation for me on what to try?
(*Note: Orignally I was going to use a crystal report object to setup the
excel spreadsheet. However I found out that you would only export the crystal
report information to excel that is only the width of 8" by 11" size paper.

thanks!

So you are basically saying the report viewer control will only produce
reports the width of 8" by 11" paper or possible the width a landscape
paper,coreect? I am saying that since you are suggesting I need to buy the
Aspose product to be able to produce reports that are wider than 'legal' size
paper correct?

"Mark Rae [MVP]" wrote:

> "Jesse Houwing" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>
> > I used Aspose 4 years ago, and back then it had some problems they were
> > still ironing out. Support was quick and bugs found often lead to fixes
> > released within a day or two. I can recommend them, if that hasn't changed
> > too much
>
> It hasn't - their suite of controls remains the industry standard method of
> Office file manipulation in .NET, especially in ASP.NET where there is often
> little choice because server-side Office automation is neither recommended
> nor supported by Microsoft for obvious reasons...
>
>
> --
> Mark Rae
> ASP.NET MVP
> http://www.markrae.net
>
>

Mark Rae:

Thank you very much!

"Mark Rae [MVP]" wrote:

> "douglas" <(E-Mail Removed)> wrote in message
> news:45706772-6275-4E78-B8C1-(E-Mail Removed)...
>
> >>>> I used Aspose 4 years ago, and back then it had some problems they were
> >>>> still ironing out. Support was quick and bugs found often lead to
> >>>> fixes
> >>>> released within a day or two. I can recommend them, if that hasn't
> >>>> changed
> >>>> too much
> >>>
> >>> It hasn't - their suite of controls remains the industry standard method
> >>> of
> >>> Office file manipulation in .NET, especially in ASP.NET where there is
> >>> often
> >>> little choice because server-side Office automation is neither
> >>> recommended
> >>> nor supported by Microsoft for obvious reasons...
> >>
> > So you are basically saying the report viewer control will only produce
> > reports the width of 8" by 11" paper or possible the width a landscape
> > paper,correct?
>
> I believe so...
>
> > I am saying that since you are suggesting I need to buy the Aspose product
> > to
> > be able to produce reports that are wider than 'legal' size paper correct?
>
> Aspose will allow you to create Excel workbooks of any size and dimension,
> with as many worksheets as you require.
>
>
> --
> Mark Rae
> ASP.NET MVP
> http://www.markrae.net
>
>