Reading SharePoint List data programmatically thru Excel 2007
-
Hi, I'm working on how to read a SharePoint list view data programmatically thru Excel 2007 VBA/ macros. Could you provide me few pointers to get how to implement this? Thanks Arut
-
Hi, I'm working on how to read a SharePoint list view data programmatically thru Excel 2007 VBA/ macros. Could you provide me few pointers to get how to implement this? Thanks Arut
Since, there were no replies on this post, I'm posting the solution I had tried out on this. May be it'll be helpful to some one. (a) Open or access the SharePoint site list in a browser, from which you want to export the data. (b) Click 'Export to spreadsheet' under 'Actions' in the list tool bar. This action allows you to export the data and before exporting the data, it'll prompt you to save or open the web query. Click 'Open' button and export the query as a data connection file to a local folder. This saves the data connection file to the local folder as .odc file. (c) You can later import this data connection file into Excel's data connections, which can be called from the VBA to get the latest data from SharePoint list. Thanks Arut
-
Since, there were no replies on this post, I'm posting the solution I had tried out on this. May be it'll be helpful to some one. (a) Open or access the SharePoint site list in a browser, from which you want to export the data. (b) Click 'Export to spreadsheet' under 'Actions' in the list tool bar. This action allows you to export the data and before exporting the data, it'll prompt you to save or open the web query. Click 'Open' button and export the query as a data connection file to a local folder. This saves the data connection file to the local folder as .odc file. (c) You can later import this data connection file into Excel's data connections, which can be called from the VBA to get the latest data from SharePoint list. Thanks Arut
Can the same option be used to get the document library and use it in excel or crystal reports.?
Riyaz Zujer Patanwala I.T.Programmer Al Jaber Energy Services P.O.Box 47467 Abu Dhabi U.A.E.
-
Can the same option be used to get the document library and use it in excel or crystal reports.?
Riyaz Zujer Patanwala I.T.Programmer Al Jaber Energy Services P.O.Box 47467 Abu Dhabi U.A.E.
Riyaz, It should be quite possible as the underlying base object is SPList, irrespective of custom list or document library. However, I guess you might need to have fields in the document library that display information. Thanks Arut