Open Excel file and append data (Delphi)

I have an excel file (xlsx) that used as template. It has column header with dropdown (for filtering). If you open template in cell M2 there is a math type I need to change the word "720" with any other number (the same for all records).

Then, I can manually copy data from file [url removed, login to view] and right click on Cell A2 and select paste value. Then the data appends to the file.

At the end I need to know the total amount (sumary) on the bottom of excel file.

I want all these automatically using Delphi.

I am using Delphi XE7. If a commercial component required you have to inform me first.


Skills: Delphi

About the Employer:
( 125 reviews ) Petrich, Greece

Project ID: #10712525