Question: how to export data from mysql database to excel sheet in java?
Answer: 5 Answers. You can use BIRT and generate your database to any format you want. If you are using struts2 you can use datagrid to export it to CSV or Excel. Alternatively you can implement code using JDBC or ORM that connects to DB, reads data and writes it using any format you want.