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.