File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

using Apache POI to save Excel data

 
Nash kumar
Greenhorn
Posts: 20
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am trying to read an excel and write the columns to Database (server 2008). I am using Apache POi and able to read the excel sheet. Could any one help me in reading and writing the columns to database from excel? thank you.

I have 9 columns in excel and want to save these 9 columns to database table that I created.
 
Ulf Dittmer
Rancher
Pie
Posts: 42966
73
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Since you're able to read the file, is this question purely about storing data to a DB? If so, are you familiar with the JDBC API?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic