Automate a Microsoft Excel Spreadsheet Sample
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.
See Also
Tasks
Automate a Microsoft Word Document in a Form Sample
Automate Microsoft Word and Excel Sample