Java Swing -Export JTable To Excel File

Java Swing - Export JTable To Excel File

Run The Code and you get this JFrame.

Output In Exported Spreadsheet File

______________________________________________________________

Write ExcelExporter Class:-

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.io.File;

import javax.swing.*;
import javax.swing.table.*;

import jxl.*;
import jxl.write.*;

public class ExcelExporter {

    void fillData(JTable table, File file) {

        try {

            WritableWorkbook workbook1 = Workbook.createWorkbook(file);
            WritableSheet sheet1 = workbook1.createSheet("First Sheet", 0);
            TableModel model = table.getModel();

            for (int i = 0; i < model.getColumnCount(); i++) {
                Label column = new Label(i, 0, model.getColumnName(i));
                sheet1.addCell(column);
            }
            int j = 0;
            for (int i = 0; i < model.getRowCount(); i++) {
                for (j = 0; j < model.getColumnCount(); j++) {
                    Label row = new Label(j, i + 1,
                            model.getValueAt(i, j).toString());
                    sheet1.addCell(row);
                }
            }
            workbook1.write();
            workbook1.close();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    public static void main(String[] args) {
        String[][] data = {{"Housewares", "Rs.1275.00"},
            {"Pets", "Rs.125.00"}, {"Electronics", "Rs.2533.00"},
            {"Menswear", "Rs.497.00"}
        };
        String[] headers = {"Department", "Daily 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 at " +
                            "'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);
    }
}

______________________________________________________________

Here When you Click on Export Button then whole JTable Data will be transfered to result.xls file in your C Drive.....

So try & Enjoy.........

Leave Comments if you like.....

Thank you....

----------------------------------------------------------------------------------

Follow Other Java Swing Tricks....

< < MySQL Dynamic Data in JTable Tutorial> >

< < MySQL Data In JTable Tutorial> >

< < UnDo/ReDo in JTextArea Tutorial> >

< < JScrollPane Tutorial> >

< < Infinite JProgressBar Tutorial> >

< < JProgressBar Tutorial> >

< < JTabbedPane Tutorial> >

< < GridBag Layout Tutorial> >

< < Image Preview In JFilechooser> >

< < Resize JTable Columns > >

< < Create Animated Notify Window > >

< < Create Vibrating JDialog > >

< < Export JTable To Excel File > >

< < Create Image JButton > >

< < Create Image JPanel > >