开发者

export to excel from sharepoint - complex

开发者 https://www.devze.com 2023-04-09 11:35 出处:网络
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 开发者_C百科few charts.

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 开发者_C百科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!


Use Epplus is a third party library for creating and manipulating excel files(xlsx)


Dunno about sharepoint, but the OpenXML SDK might be what you're after:- http://msdn.microsoft.com/en-us/library/bb448854.aspx

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号