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

 

 

 

 

 


What's New for RAD Studio 11

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++Delphi

Developer and Development News - Sunday, November 14, 2021

CodeDelphiRAD Studio

This Is How To Easily Process CSV Data Using FireDAC

C++Code

This Week's New C++ Post Picks From LearnCPlusPlus.org

CodeDatabaseDelphiRAD Studio

6 Easy Ways to Connect to the Top Databases You Should Know

Leave a Reply

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

IN THE ARTICLES