Excel from Delphi

I'm using the OLEauto in one of my Delphi applications and have no problems in CreateOLEObject('Excel.Application'), but I want to open an Excel XLS file and place the content of Edit1.Text in cell B4. How do I do?
rainbowsoftwareAsked:
Who is Participating?
 
ronit051397Connect With a Mentor Commented:
Try this. I didn't check it:
with CreateOLEObject('Excel.Application') do
begin
  Workbooks.Open('C:\somepath\something.xls');
  Range('B4').FormulaR1C1:=Edit1.Text;
end;
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.