mercredi 15 avril 2015

how to create table in mysql with the contents of first row in excel in java dynamicallly

how to create table in MySQL with the contents of first row in excel in java dynamically without hard-coding and creating and i have a excel in which columns are added or deleted frequently... so i need to update my table frequently with new columns.. anyone plz help. i am using spring-jdbc to connect to database and creating maven project... and how to read a cell value with date in it with format MM/DD/YYYY? for reading excel data i am using Apache-poi..


my excel is like this.. and having more than 100 rows


ID Employee Manager Onsite 4/15/2015 4/16/2015 4/17/2015 1 raju ram offshore 8 8 8


Aucun commentaire:

Enregistrer un commentaire