• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Java MySQL MS Excel

 
rama krishnan
Ranch Hand
Posts: 68
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
how to export or transfer the MySQL database value into the MS Excel using the Java Code,
I can export the JTable values into MS Excel but I can't with Database to Excel
 
Martijn Verburg
author
Bartender
Posts: 3275
5
Eclipse IDE Java Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi there,

Have you looked at the Apache POI libraries?
 
Jesper de Jong
Java Cowboy
Saloon Keeper
Posts: 15216
36
Android IntelliJ IDE Java Scala Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
See JavaRanch FAQ: Accessing File Formats

To work with MySQL, you need a JDBC driver for MySQL. If you don't know how to use JDBC, see Sun's tutorial.

Your question is quite vague and general. If you explain in more detail with what part you have difficulties, it will be easier to give you a useful answer.
[ October 23, 2008: Message edited by: Jesper Young ]
 
Rob Spoor
Sheriff
Pie
Posts: 20512
54
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can also use a CSV file instead of a "real" Excel file. CSV is plain text with just special separator characters.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic