1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
| 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 = {{"Meubles", "Rs.1275.00"},
{"Outils", "Rs.125.00"}, {"Électroniques", "Rs.2533.00"},
{"Bois", "Rs.497.00"}
};
String[] headers = {"Départment", "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 sauvegardé vers " +
"'C:\\result.xls' successfully", "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);
;
}
} |
Partager