I want to build a custom web part which will export share point list contents to Excel. (Since excel services are not supported in SPF 2010.) Actually I have used
Htmltextwriter to achieve this (refer sample code shown below). I used Response.Appendheader to save a file in user defined location.
I have followed these steps to implement the above:
Step 1: Create empty Excel file in server.
Step 2: Load file with SPlist data (using htmltextwriter)
Step 3: Prompt “Save As” dialog to save the file (with data) in client defined location.
View Complete Post