I have connected Delphi to an Excel workbook usibng Ado. I can see the spreadsheet in Delphi DB Grid. But how in code do I refer to an Excel cell? So in Excel sheet 1 column is F18, and the row is 5, How do I retrieve the value of this cell to use in, say, an edit box?
http://delphi.about.com/od/database/l/aa090903a.htm
getting field info is in page 4
http://delphi.about.com/od/database/l/aa090903d.htm
and editing, modifying is in page 4
http://delphi.about.com/od/database/l/aa090903e.htm
basically you can query an excel spreadsheet using an ado table
and update/edit it via a dbgrid or sql updatestatements