Automate a Microsoft Excel Spreadsheet

File: SAMPLES\SOLUTION\OLE\OLEXL.SCX

This form shows two samples of Visual FoxPro calling an Excel worksheet through automation.

The Trend button performs a query followed by a cross-tab to create a dataset to pass to Excel through automation using the Excel.Sheet object. Once in Excel, Visual FoxPro can call a Trend function to perform a simple regression analysis.

The Chart button automates the Excel.Chart object to create a chart. Excel supports passing data through automation, but MS Graph does not. However, you can distribute MS Graph with your applications.