Learn more
 

CData Software - Knowledge Base



Recent Excel ADO.NET Articles

Import SharePoint Excel Services Data into SQL Server using SSIS

Easily back up SharePoint Excel Services to SQL Server using the SSIS components for SharePoint Excel Services.

DataBind Excel Online to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for Excel Online with the DevExpress Windows Forms and Web controls to provide Microsoft Excel Online to a chart.

Provide OData Services of Excel Online from a WCF Application

This article shows how to publish an OData feed of Microsoft Excel Online by creating a WCF Service Application.

Visualize SharePoint Excel Services in TIBCO Spotfire through ADO.NET

Integrate SharePoint Excel Services into dashboards in TIBCO Spotfire.

Explore Geographical Relationships in Adobe Commerce with Power Map

Create data visualizations with Adobe Commerce in Power Map.

Export Data from SQL Server to Excel through SSIS

Easily push SQL Server data to Excel using the CData SSIS Tasks for Excel.

Import and Visualize Adobe Analytics in Power View

Create data visualizations based on Adobe Analytics in Excel.

Build an OLAP Cube in SSAS from SharePoint Excel Services

Connect to SharePoint Excel Services in an Analysis Services project using the SharePoint Excel Services Data Provider and build OLAP cubes for use in analytics, reporting, and more.

LINQ to Excel

LINQ provides general-purpose query facilities in .NET Framework 3.0 and above and provides one easy way to programmatically access data through from CData ADO.NET Data Providers. This example uses LINQ to access information from the Excel Data Provider.

Provide OData Services of Excel from a WCF Application

This article shows how to publish an OData feed of Microsoft Excel by creating a WCF Service Application.

Deploy the ADO.NET Provider for Excel Online on an SSRS Report Server

Connect to Microsoft Excel Online from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.