View Full Version : Excel & DB file data interchage
How to transfer Grid Table data to Excel
sheet and Excel sheet data to TTable Grid
On Delphi Form.
Any Help !
I don't know of an automated way but you can use OLE to connect to Excel. Once connected, you can move data and formulas back and forth.
The COM interface to Excel (all office components) can be quite complex from the beginning but it is somewhat logically arranged. There are commercial components that can help with the connectivity but I wrote my own.
Use the Delphi Super Page and search for Excel. I believe there are several components for this procedure. The site is
http://sunsite.icm.edu.pl/delphi
This site should be among your favorites.
George
vBulletin® v3.8.7, Copyright ©2000-2013, vBulletin Solutions, Inc.