mardi 31 mars 2015

how to export Filtered data to excel in java


  1. I have retrieved a data from excel to my jtable, now in my jtable i do a bit of filtering, after doing the filtering part, i want to export its data into an excel file.


  2. But the problem is that data exported is not filtered but its the same that was retrieved from excel.



    DefaultTableModel model =(DefaultTableModel)TABLE1.getModel();
    JTable table =new JTable(model);
    table.getModel().getValueAt(table.convertRowIndexToModel(0),5);
    table.setModel(model);

    try{

    File file = new File("ECN320C.xls");
    try (FileWriter excel = new FileWriter(file)) {
    for(int i = 0; i <model.getColumnCount(); i++){
    excel.write(model.getColumnName(i) + "\t");
    }

    excel.write("\n");

    for(int i=0; i<model.getRowCount(); i++)
    {
    for(int j=0; j < model.getColumnCount(); j++)
    {
    excel.write(model.getValueAt(i,j).toString()+"\t");
    }
    excel.write("\n");
    }
    }
    JOptionPane.showMessageDialog(this, "Your Data Is Saved.");
    }

    catch(Exception e)
    {
    e.printStackTrace();
    }



Aucun commentaire:

Enregistrer un commentaire