Site icon Embarcadero RAD Studio, Delphi, & C++Builder Blogs

Using Delphi, from Excel to JSON, then FireDAC[JAPAN]

Author: John D7279

 

[crayon-672aad54296e0391803593/]

It is a code for excel to JSON.

[crayon-672aad54296e8170792739/]

Now you get the Excel data.

[crayon-672aad54296eb838110397/]


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-672aad54296f2886124199/]

 

[crayon-672aad54296f4193486827/]

https://gist.github.com/mojeld/66acc0959e9f7a09c1ee4dfddb57b413

 

 

Call this method.

[crayon-672aad54296f5054544860/]

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

 

 

 

 

 

Exit mobile version