Read the release
 

CData Software - Knowledge Base



Recent Excel ADO.NET Articles

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.

Build an OLAP Cube in SSAS from Excel Online

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

Import Excel Data into SQL Server using SSIS

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

Export Data from SQL Server to Excel through SSIS

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

Visualize Excel in TIBCO Spotfire through ADO.NET

Integrate Microsoft Excel into dashboards in TIBCO Spotfire.

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.

Import Real-Time Excel in ColdFusion to Build Applications

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

Access Excel Online with Entity Framework 6

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

Create Dynamic Excel Grids Using the Infragistics XamDataGrid

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

Work with Adobe Analytics in MS Excel on Mac OS X

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

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.

Visualize SharePoint Excel Services in TIBCO Spotfire through ADO.NET

Integrate SharePoint Excel Services into dashboards in TIBCO Spotfire.

Publish Crystal Reports on Excel

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

DataBind SharePoint Excel Services to the DevExpress Data Grid

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

DataBind Charts to Excel

Use the standard ADO.NET procedures for databinding to provide bidirectional access to Microsoft Excel from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.