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

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

Author: John D7279

 

[crayon-6740227dad668051419544/]

It is a code for excel to JSON.

[crayon-6740227dad670522086355/]

Now you get the Excel data.

[crayon-6740227dad673254606773/]


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-6740227dad675776513629/]

 

[crayon-6740227dad677780476343/]

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

 

 

Call this method.

[crayon-6740227dad679735034123/]

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