CData TDV Adapter for Microsoft SharePoint Excel
SharePoint Excel Services Adapter
SharePoint Excel Services Version Support
The adapter supports retrieving Excel data from SharePoint On-Premises through the REST API and through the OData API introduced in SharePoint 2013. Excel files must have the .xlsx format used in Excel 2007 and later.Note: Microsoft has stated that they plan to sunset the Excel Services API for SharePoint Online in February 2022. Please consider migrating to the CData adapter for Excel Online for future access to your SharePoint data.