Can I start an Excel session from Visual Studios 2005 (C#)?

[Steve Kershaw]

Hi,

I have a need to start and load with data an Excel spreadsheet from a
ASP.NET application. Is that possible in XP and if so how?

Thanks

Steve

 

[Mark Rae [MVP]]

I have a need to start and load with data an Excel spreadsheet from a
ASP.NET application. Is that possible in XP and if so how?

Firstly, you can't do Office Automation with ASP.NET:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2

However, it's easy enough to create an Excel spreadsheet using ASP.NET -
there are, essentially, three ways:

1) Use HTML
Create your data as an HTML document, and give it an xls extension - Excel
will treat it just like a "real" worksheet...

2) Use XML
http://www.microsoft.com/downloads/...52-3547-420a-a412-00a2662442d9&displaylang=en
http://www.microsoft.com/downloads/...80-f2c0-4b80-9ad1-2cb0c300aef9&displaylang=en

3) Use Aspose
http://www.aspose.com/Products/Aspose.Cells/Default.aspx

 

[Steve C. Orr [MCSD, MVP, CSM, ASP Insider]]

Yes, there are a variety of ways to do it depending on your needs. I've
covered most of the techniques here:
http://SteveOrr.net/articles/ExcelExport.aspx