Learn more
 

CData Software - Knowledge Base

Recent Spark Excel Articles

Excel Spreadsheet Automation with the QUERY Formula

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

How to work with SharePoint Excel Services in Apache Spark using SQL

Access and process SharePoint Excel Services in Apache Spark using the CData Software JDBC Driver.

How to import SharePoint Excel Services into Apache Solr

Use the CData Software JDBC Driver for SharePoint Excel Services in Data Import Handler and create an automated import of SharePoint Excel Services to Apache Solr Enterprise Search platform.

How to connect to Spark from MS Excel on Mac OS X

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

Access Live Spark in Excel (Desktop)

Use CData Connect Cloud to gain access to live Apache Spark SQL from your Excel spreadsheets.

Use the CData ODBC Driver for Spark from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Spark to connect to Apache Spark SQL from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Apache Spark SQL in Excel.

How to import Excel into Apache Solr

Use the CData Software JDBC Driver for Excel in Data Import Handler and create an automated import of Microsoft Excel to Apache Solr Enterprise Search platform.

Access Live Spark in Excel 365 Online (Excel for the web)

Connect to Apache Spark SQL from Excel 365 Online (Excel for the web) with CData Connect Cloud.

How to work with Excel in Apache Spark using SQL

Access and process Excel in Apache Spark using the CData Software JDBC Driver.

How to work with Excel Online in Apache Spark using SQL

Access and process Excel Online in Apache Spark using the CData Software JDBC Driver.

How to update Spark from Excel

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