- 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.
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();
}
mardi 31 mars 2015
how to export Filtered data to excel in java
Inscription à :
Publier les commentaires (Atom)
Aucun commentaire:
Enregistrer un commentaire