Have an amazing solution built in RAD Studio? Let us know. 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

 

 

 

 

 


Coding Boot Camp

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

   Free Delphi Community Edition   Free C++Builder Community Edition

Related posts
CodeDelphiTech Partner

This Is How To Store Cross Platform App Settings In JSON

How-To'sInterBaseNewsRAD Studio

Using FireDAC Connection Pooling with RAD Server

C++CodeIDEInterBaseRAD Studio

How To Design Screens For Cross Platform C++ Apps And More

DatabaseDelphiTech Partner

This Is How To Use ADO And FireDAC With Databases

Leave a Reply

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

IN THE ARTICLES