export an excel file from sharepoint

There is some code/werbparts on our site that display a lot of data in a grid on our site.  In addition, they have another page with a few charts.

I need a way to create functionality to export this to excel so the user can click a button and save everything.

The chart will actually have to be built in excel, I can't just grab the picture from the website and display it.

Also, the data from the grid will have to be put into a spreadhseet.  I am not as worried about this part.

I have exported to excel before, but it was just basically printing some data which was tab delimited with a certain doc type .

This actually will need to use different work sheets and use some excel functionality.

(I need a better answer than use excel services)
Thanks!
jackjohnson44Asked:
Who is Participating?
 
dj_alikConnect With a Mentor Commented:
You can use a library called ExcelLibrary. It's a free, open source library posted on Google Code:
http://code.google.com/p/excellibrary/
0
 
dj_alikCommented:
Export SharePoint List to Excel Spreadsheet Programmatically using C#
http://www.etechplanet.com/blog/export-sharepoint-list-to-excel-spreadsheet-programmatically-using-c.aspx
0
 
jackjohnson44Author Commented:
Thanks, but that is not what I am looking for.  That creates an xls file with only text.  I am looking to make a compled xlsx document.
0
All Courses

From novice to tech pro — start learning today.