jueves, 14 de abril de 2011 6:48How to programaticaly export SharePoint 2010 BCS list into excel
- Cambiado Clayton Cobb - MVP jueves, 14 de abril de 2011 8:51 Programmatic questions go in the programming forum (From:SharePoint 2010 - Using SharePoint Designer, Infopath, and other customization)
Todas las respuestas
jueves, 14 de abril de 2011 10:49
I think it is not possible, it is one of BCS limitation, see chakradeep article on BCS limitataions
Ashish Kanoongo, MCP, MCSD, MCTS
jueves, 14 de abril de 2011 11:15
Ashish is correct that this is not possible out of the box. However, External Lists are accessible through the SPList object, so you could access the data through SPList and then use the OpenXML file formats to put the data into Excel.
Author, Professional Business Connectivity Services
Author, Inside SharePoint 2010 Blog, www.shillier.com
SharePoint Trainer, Critical Path Training
- Marcado como respuesta GuYumingMicrosoft Contingent Staff, Moderator viernes, 29 de abril de 2011 7:27
miércoles, 22 de agosto de 2012 16:10Scot, can you elaborate a bit on this? I too am trying to export to excel the data from an external list. How do you get from SPList to OpenXML to excel??
martes, 12 de marzo de 2013 20:56
That is correct, the External list
cannot be exported , but it can be accessed like Soct mentioned. (PS Soct’s
presentation on BCS was an inspiration… THANK YOU )
The trick here is to create an
External List on a site (somehow) , that is the only you will ensure that the
(finder method ) is executed for all items on the external list.
Now with that said, you can then do
most analytics using SSRS straight against that list , but if you plan to use
any other code (custom C# or SSIS package etc.) to access the data , I
recommend you access the LOB data directly as coding against BCS to get to the
LOB system is just waste of time and adding complexity.
I am hoping Microsoft get that
feature in the new release of Office.
Best of luck
- Editado George Gergues martes, 12 de marzo de 2013 20:58 html