Import an excel table to the database, more sheet but not fixed, but they are all the corresponding entity class object, ask the import how to write? Online thank humbly

CodePudding user response:

Program to read out the batch inserts, don't need the program to run, with the database interface tool can directly import excel, or converted into a CSV file with the command after import, the baidu

CodePudding user response:

reference 1st floor wildyy response:

program reads out the batch inserts, don't need the program to run, with the database interface tool can directly import excel, or converted into a CSV file after the command import, specific baidu

Is to write a program to different objects, inserted into the correct list, do not know this how to do ah

CodePudding user response:

Use POI, get all the sheet, and then obtain the sheet inside line, cell, final assembly into object to execute insert
Or you can search for EasyPOI API

CodePudding user response:

Import is low frequency behavior, now that you've made, requires accurate some artificial do

May be agreed upon entry into different object, or a file name, name of the sheet is fixed

CodePudding user response:

Give you refer to: https://blog.csdn.net/mr_zql/article/details/100588356