samedi 18 avril 2015

Excel file read and show in jtable


DefaultTableModel model = (DefaultTableModel) TblModel.getModel();
model.setRowCount(0);
if(jTFpath.getText().isEmpty())
{
return;
}

try {
FileInputStream fs=new FileInputStream(jTFpath.getText());
HSSFWorkbook workbook = new HSSFWorkbook(fs);
HSSFSheet sheet = workbook.getSheetAt(0);
Iterator<Row> rowIterator = sheet.iterator();
boolean isHeader = true;`like_so_`
while (rowIterator.hasNext()) {
if (isHeader) {
isHeader = false;
rowIterator.next();
continue;
}
Row row = rowIterator.next();
System.out.println(row);
//model.addRow((Vector)row);
}
} catch (IOException ex) {
Logger.getLogger(Nextpage.class.getName()).log(Level.SEVERE, null, ex);
}

Aucun commentaire:

Enregistrer un commentaire