wood burning stoves 2.0*
The moose likes Java in General and the fly likes Java  MySQL  MS Excel Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "Java  MySQL  MS Excel" Watch "Java  MySQL  MS Excel" New topic
Author

Java MySQL MS Excel

rama krishnan
Ranch Hand

Joined: Mar 14, 2008
Posts: 68
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


MRK
Martijn Verburg
author
Bartender

Joined: Jun 24, 2003
Posts: 3274
    
    5

Hi there,

Have you looked at the Apache POI libraries?


Cheers, Martijn - Blog,
Twitter, PCGen, Ikasan, My The Well-Grounded Java Developer book!,
My start-up.
Jesper de Jong
Java Cowboy
Saloon Keeper

Joined: Aug 16, 2005
Posts: 14105
    
  16

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 ]

Java Beginners FAQ - JavaRanch SCJP FAQ - The Java Tutorial - Java SE 7 API documentation
Scala Notes - My blog about Scala
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19670
    
  18

You can also use a CSV file instead of a "real" Excel file. CSV is plain text with just special separator characters.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
 
Don't get me started about those stupid light bulbs.
 
subject: Java MySQL MS Excel