?
Solved

export an excel file from sharepoint

Posted on 2011-09-30
3
Medium Priority
?
379 Views
Last Modified: 2012-05-12
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!
0
Comment
Question by:jackjohnson44
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 18

Expert Comment

by:dj_alik
ID: 36896023
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
 

Author Comment

by:jackjohnson44
ID: 36905154
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
 
LVL 18

Accepted Solution

by:
dj_alik earned 2000 total points
ID: 36907860
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

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question