Author: John D7279
[crayon-691b925d7d59a143935140/]
It is a code for excel to JSON.
[crayon-691b925d7d5a0606560743/]
Now you get the Excel data.
[crayon-691b925d7d5a1336449076/]
It inserts this acquired JSON data further into the DB table with FireDAC.
I made the above table.This is MySQL.
Insert from TJSONObject into MySQL table.
It is a code.
[crayon-691b925d7d5a2201018311/]
[crayon-691b925d7d5a3107364114/]
https://gist.github.com/mojeld/66acc0959e9f7a09c1ee4dfddb57b413
Call this method.
[crayon-691b925d7d5a4123483842/]
Insertion to the database succeeded.
[I also write in Japanese]
http://qiita.com/mojeld/items/50ccdea274a17f9d9bbd
[If you use C++Builder, please use the following URL]
https://community.embarcadero.com/blogs/entry/use-the-excel-application-in-c-builder-bcc64