export to excel file from asp.net

Question

I have an ASP.NET 3.5 site that needs to export data to a pre-formatted Excel sheet. I am not allowed to modify the excel sheet in any way, just drop data into specific cells.

My question is, What is the simplest way to do this from an ASP.NET site. The user will always have Excel on their machine.

Is a 3rd party control my best option or is this a relatively simple task using VB.NET ?

amantur · Accepted Answer · 2009-11-25 05:49:53Z

2

dear use ExcelPackage. It rocks!!! I've used it in my project. It can take a preformatted excel file and use it as template. It is also very easy to use.

answered Nov 25, 2009 at 5:49

amantur

40.6k22 gold badges136 silver badges192 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

richardtallent · Accepted Answer · 2009-11-25 06:01:04Z

1

Use NPOI (http://npoi.codeplex.com/) if you want Excel 2000-2003 compatibility, or ExcelPackage (http://excelpackage.codeplex.com/) if you're only targeting Excel 2007/2008.

I've also rolled my own XML output in the older SpreadsheetML format (Excel 2002/2003), it was MUCH easier than the newer OOXML (Excel 2007/2008) format.

answered Nov 25, 2009 at 6:01

richardtallent

35.5k14 gold badges87 silver badges126 bronze badges

Collectives™ on Stack Overflow

export to excel file from asp.net

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related