ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Retrieve xml data from SharePoint (https://www.excelbanter.com/excel-worksheet-functions/81930-retrieve-xml-data-sharepoint.html)

JimDandy

Retrieve xml data from SharePoint
 

I would like to be able to extract data from a series of XML files
contained within a SharePoint library. Each of the XML files have
fields like StartDate, EndDate and checkbox fields that I’d like to
extract. I’ve been able to get a spreadsheet to pull data from one xml
file but I’d like to capture the data from all the files in the
SharePoint library so I can report on the number of forms that meet
certain criteria. What I can’t figure out how to do is to read through
the list and create one row of data per xml form.

:confused:


--
JimDandy
------------------------------------------------------------------------
JimDandy's Profile: http://www.excelforum.com/member.php...o&userid=16578
View this thread: http://www.excelforum.com/showthread...hreadid=530536


JimDandy

Retrieve xml data from SharePoint
 

Is there maybe a better forum to post this kind of question?


--
JimDandy
------------------------------------------------------------------------
JimDandy's Profile: http://www.excelforum.com/member.php...o&userid=16578
View this thread: http://www.excelforum.com/showthread...hreadid=530536



All times are GMT +1. The time now is 06:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com