How to retrieve, display and edit Microsoft Excel spreadsheets with ADO (dbGO) and Delphi. This step-by-step article describes how to connect to Excel, retrieve sheet data, and enable editing of data (using the DBGrid). You'll also find a list of most common errors (and how to deal with them) that might pop up in the process.

Here's what you will learn about in this (lengthy) article:

• Methods for transferring data between Excel and Delphi. How to connect to Excel with ADO and Delphi.
• Creating an Excel spreadsheet editor using Delphi and ADO
• Retrieving the data from Excel. How to reference a table (or range) in an Excel workbook.
• A discussion on Excel field (column) types
• How to modify Excel sheets: edit, add, and delete rows.
• Transferring data from a Delphi application to Excel. How to create a worksheet, and fill it with "custom" (from an Access database) data.

A List of Free Online Softwares

If you go down to your local best buy, an office productivity suite could cost you hundreds of dollars. And, in years past, you were stuck with that type of bill.

Not anymore. Thanks to the recent trend toward Office 2.0, there is plenty of free online software available for the office. And the best part is that many of these online applications are just as feature-rich as their desktop counterparts.