RAD Studio 10.4.1 is now available! Learn more. Looking for discounts? Visit our Special Offers page!
Delphi

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

Author: John D7279

 

It is a code for excel to JSON.

Now you get the Excel data.


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.

 

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

 

 

Call this method.

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

 

 

 

 

 


Reduce development time and get to market faster with RAD Studio, Delphi, or C++Builder.
Design. Code. Compile. Deploy.
Start Free Trial   Learn More About Upgrading

Deep Dive Webinar: Boost C++Builder Compile Speed with TwineCompile
Related posts
CodeDelphiRAD Studio

Learn How To Send Arrays To A PostgreSQL Database Server Using FireDAC In Delphi On Windows

CodeDelphiRAD Studio

TFDBatchMove Is A Powerful Way To Move Data Between Text Files And Tables Using Datasets In Delphi

CodeDelphiRAD Studio

Learn How To Use FireDAC In The Dynamic-Link Libraries With DLL Sharing Sample In Delphi

CodeDelphiRAD Studio

Learn How To Use Connection Pooling With A Multi-threaded Environment In Delphi

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

IN THE ARTICLES