export to excel

[Mariusz]

Hi,

I'm looking for some way to export data from my asp.net page to excel
speadsheet. I'm generating some table containing raports and other tabular
data and I need some way to export it to excel and maybe to acces. Can
anyone give me some clues? I'v tried to change content of page to
application/excel (or something like this - don't remember right now), it
works for some data, but for larger or more complex tables it ends up with
'unable to open file' error. I was wondering what causes that. Maybe some
rowspans or nested tables?

 

[Elton W]

Hi Mariusz,


Look at

http://support.microsoft.com/default.aspx?scid=kb;en-
us;317719

HTH

Elton Wang
(e-mail address removed)

 

[Steve C. Orr [MVP, MCSD]]

There are a variety of ways to export ASP.NET content to Excel.
Most of the techniques are described in detail here:
http://SteveOrr.net/articles/ExcelExport.aspx
http://SteveOrr.net/articles/ExportPanel.aspx

 

[Mariusz]

Hi,

Thanx.
Actually I did almost the same but I forgot to turn off the viewstate and
this was the reason why i was unable to open exported files.