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

 

 

 

 

 


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
C++Code

2021 Annual C++ Developer Survey "Lite" by ISOCpp.org - Results summary

C++DelphiRAD Studio

Easy Serialization From Query To JSON

C++RAD Studio

LearnCPlusPlus.org :: Learn FireDAC, MyDAC Components And MySQL, PostgreSQL, InterBase Databases, And Much More

C++CodeRAD Studio

LearnCPlusPlus.org :: Color to Alpha Example, Learn to Use Clipboard + Much More

Leave a Reply

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

IN THE ARTICLES