Hi,
First, i must admit that i'm new to Java world. So a beginner.
I'm trying to extract data from my JTable to Microsoft excel using below code.
The problem is that i don't have any errors but it does not export anything.
Would you be able to help me?
Thank you
import javax.swing.JFrame;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
import javax.swing.JButton;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import javax.swing.*;
import java.io.File;
public class test_no_1 {
/**
* Launch the application.
*/
public static void main(String[] args) {
String[][] data = {{"Desks", "Rs.1275.00"},
{"Tools", "Rs.125.00"}, {"Electronics", "Rs.2533.00"},
{"Woods", "Rs.497.00"}
};
String[] headers = {"Departement", "Revenue"};
JFrame frame = new JFrame("JTable to Excel");
DefaultTableModel model = new DefaultTableModel(data, headers);
final JTable table = new JTable(model);
JScrollPane scroll = new JScrollPane(table);
JButton export = new JButton("Export");
export.addActionListener(new ActionListener() {
@Override
public void actionPerformed(ActionEvent evt) {
try {
ExcelExporter exp = new ExcelExporter();
exp.fillData(table, new File("C:\\result.xls"));
JOptionPane.showMessageDialog(null, "Data saved to " +
"'C:\\result.xls' correctly", "Message",
JOptionPane.INFORMATION_MESSAGE);
} catch (Exception ex) {
ex.printStackTrace();
}
}
});
frame.getContentPane().add("Center", scroll);
frame.getContentPane().add("South", export);
frame.pack();
frame.setVisible(true);
// frame.setDefaultCloseOperation(frame.EXIT_ON_CLOSE);
;
}
}
I'm under Eclipse version: 2018-09(4.9.0)