Read the release
 

CData Software - Knowledge Base



Recent Excel ADO.NET Articles

Access Excel with Entity Framework 6

This article shows how to access Microsoft Excel using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

Export Data from SQL Server to Excel through SSIS

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

Back Up SharePoint Excel Services to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SharePoint Excel Services. In this article, we will employ an SSIS workflow to populate a database with SharePoint Excel Services data.

Create Dynamic Excel Online Grids Using the Infragistics XamDataGrid

Use the CData ADO.NET Provider for Excel Online and the Infragistics XamDataGrid to build dynamic grids.

Visualize Excel Online in TIBCO Spotfire through ADO.NET

Integrate Microsoft Excel Online into dashboards in TIBCO Spotfire.

Author and Share Power BI Reports on Real-Time Adobe Commerce

Use the CData ODBC Driver for Adobe Commerce to visualize Adobe Commerce in Power BI Desktop and then upload to the Power BI service.

Use the CData ODBC Driver for Adobe Commerce in Microsoft Power Query

You can use the CData Adobe Commerce ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Adobe Commerce into Microsoft Power Query.

Build an OLAP Cube in SSAS from SharePoint Excel Services

Establish a connection to SharePoint Excel Services data from SQL Server Analysis Services, and use the SharePoint Excel Services Data Provider to build OLAP cubes for use in analytics and reporting.

Transfer Data from Excel to Adobe Analytics

This article explains how to transfer data from Excel to Adobe Analytics using the Excel Add-In for Adobe Analytics.

LINQ to Excel Online

LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Excel Online Data Provider.

Publish Crystal Reports on Excel

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft Excel.

Excel Files as Data Sources Using CData ADO.NET Providers

Bjoern Meyer from Text Control explores using the CData Data Providers with TX Text Control Words, the Text Control Reporting template designer.

Provide OData Services of SharePoint Excel Services from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for SharePoint Excel Services by developing a WCF Service Application.

Author and Share Power BI Reports on Real-Time Adobe Analytics

Use the CData ODBC Driver for Adobe Analytics to visualize Adobe Analytics in Power BI Desktop and then upload to the Power BI service.

Import Excel Online Data into SQL Server using SSIS

Easily back up Microsoft Excel Online to SQL Server using the SSIS components for Excel Online.