Excel Spreadsheet Automation with the CDATAQUERY Formula
The CData Excel Add-In provides formulas that can pull data from different data sources into your spreadsheet. For example, the Google provider can create a spreadsheet of directions. In this article we show how to use the CDATAQUERY formula to automate spreadsheets.