A way to display an excel 2010 document in an asp.net web application
I am wanting to display an Excel 2010 document in an asp.net web application. This document uses the new slicer functionality which I want to be available to the user.
I know that Excel 2010 docs can be used within Shar开发者_开发技巧ePoint by inserting a web part which uses Excel services.
But can it be achieved without SharePoint ? Or can it be achieved using the the Excel services API to get the document from SharePoint and then somehow get it to the browser in .net?
Thanks, Tom.
I am not familiar with the Slicer functionality but.... Excel cells are available via a REST interface within SharePoint 2010 (not 2007). That may help you get to the data you want to expose.
More information on the Excel and Rest with SharePoint 2010 here.
From a non SharePoint perspective, the Skydrive based Web Office apps have Excel functionality. It is possible you may be able to impersonate a user, send a HTTP request to try and bring back the Excel data for display. You could possibly use an IFrame for display also. Having said that, I have never tried it and not sure how well it would work.
精彩评论