Read the release
 

CData Software - Knowledge Base



Recent Excel ADO.NET Articles

Connect to Excel Online from PowerBuilder

This article demonstrates how to access Microsoft Excel Online from Appeon PowerBuilder using the CData ADO.NET Provider for Excel Online.

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.

Access SharePoint Excel Services with Entity Framework 6

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

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.

Publish Crystal Reports on SharePoint Excel Services

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

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.

Import and Visualize Adobe Commerce in Power View

Create data visualizations based on Adobe Commerce in Excel.

Work with Adobe Commerce in MS Excel on Mac OS X

Create a Data Source Name in iODBC with the CData ODBC Driver for Adobe Commerce and work with Adobe Commerce in Microsoft Excel on Mac OS X.

Automate Excel Online Integration Tasks from PowerShell

Are you in search of a quick and easy way to access Microsoft Excel Online from PowerShell? This article demonstrates how to utilize the Excel Online Cmdlets and the CData ADO.NET Provider for Excel Online for tasks like connecting to Microsoft Excel Online, automating operations, downloading data, and more.

Provide OData Services of Excel from a WCF Application

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

Import Real-Time Excel Online in ColdFusion to Build Applications

Use the CData ODBC Driver for Excel Online to import and use Microsoft Excel Online in ColdFusion.

Visualize Excel in TIBCO Spotfire through ADO.NET

Integrate Microsoft Excel into dashboards in TIBCO Spotfire.

Excel Spreadsheet Automation with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.

Transfer Data from Excel to Adobe Commerce

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

LINQ to Excel

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 Data Provider.