First, I will convert Excel data to JSON.
After that, we insert that JSON into the DB table with FireDAC.This time DB uses MySQL.
They all program with Delphi.
Excel is like this.
TRect is used to acquire data only for that area.
Why do we write applications? One answer could be "for fun", but not always we are in such a comfortable situation of doing something without a real (business) reason. This is where "Creating Value from Programming" comes in.
Recently we've done a joint session with Jeroen Pluimers on the Software Developer Event "Office Stuff!!" about different ways of automating Excel and Word from Delphi. Lots of people in banks, insurance companies, corporate headquarters and similar institutions spend mo...