export mysql data to excel from Java using Apache POI

Question

I have the class MysqlToXls copied from here: http://mikescode.wordpress.com/2008/02/16/exporting-a-mysql-table-to-excel-xls-in-java/

I edited the class making a constructor that doesn't need any parameter in this way:

public MysqlToXls()
throws ClassNotFoundException, SQLException {

    // Create MySQL database connection
    Class.forName("com.mysql.jdbc.Driver");

    String url = "jdbc:mysql://localhost/Spinning?user=root&useUnicode=true&characterEncoding=utf8";
    connection = DriverManager.getConnection(url);
}

While there is not any guide I try to do myself and I'm not able.

  MysqlToXls m=new MysqlToXls();
  m.generateXls("utente", "utenti.xls");

But there are no errors and the file utenti.xls remains blank. Does someone know where is the problem?

Do you have any data in the table utente? Does the ResultSet in generateXls() contain any results? — harpun
– harpun, Commented Feb 9, 2013 at 13:01

hijack · Accepted Answer · 2013-02-09 13:12:00Z

1

It is possible that you have to explicitly close the outputStream, so insted of doing this:

xlsWorkbook.write(new FileOutputStream(filename));

you should try to do something like this:

FileOutputStream fos = new FileOutputStream(filename);
xlsWorkbook.write(fos);
fos.close();

answered Feb 9, 2013 at 13:12

hijack

3212 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

hijack Over a year ago

Actually I tried the linked code and it worked like a charm. So closing the output stream will not resolve your problem.

hijack Over a year ago

Yes, no problem at all with the original code. Sorry, I have no clue.

Martina · Accepted Answer · 2013-02-10 11:37:41Z

1

the only problem was the path of the file. I was trying to save the file in one folder of the project (with a relative path), while if I give the absolute path (f.e. on the desktop) it works perfectly!

answered Feb 10, 2013 at 11:37

Martina

1,9289 gold badges45 silver badges84 bronze badges

Collectives™ on Stack Overflow

export mysql data to excel from Java using Apache POI

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related