Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.
Course Of The Month
5 days, 23 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Delphi Excel connection
Posted on 2016-08-16
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?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
3 Comments
Active 2 days ago
There is a complete manual for delphi and excel on about.com
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
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
like this , for example:
procedure TForm1.HandleData;
var
Sheet: Variant;
i: Integer;
begin
Sheet := XLApp.Workbooks[1].Worksheets['Delphi Data'];
for i := 1 to 10 do
Sheet.Cells][i, 1] := i;
end;
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Do you use a spreadsheet like Microsoft's Excel? Have you ever wanted to link out to a non excel file on your computer or network drive? This is the way I found to do it!
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…
Suggested Courses
Course of the Month5 days, 23 hours left to enroll
707 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.