Thanks Nikc i made it an example in the userModel of the poi framework
project. Only one question if you know it, if i have this code:
public void process(String fileName){
try {
XSSFWorkbook wb = new XSSFWorkbook(fileName);
readIteration(wb);
} catch (IOException e) {
e.printStackTrace(); //To change body of catch statement use
File | Settings | File Templates.
}
}
private void readIteration(XSSFWorkbook wb){
Sheet sheet = wb.getSheetAt(0);
for (Iterator<Row> rit = sheet.rowIterator(); rit.hasNext(); ) {
Row row = rit.next();
for (Iterator<Cell> cit = row.cellIterator(); cit.hasNext();
) {
Cell cell = cit.next();
// Do something here
}
}
}
Sheet sheet = wb.getSheetAt(0); this will be the first sheet of my xlsx
right?
and the second question.
Cell will contain the information of column name, value etc, etc.
--
View this message in context:
http://old.nabble.com/Create-a-XSSFWorkbook-from-a-XSSFReder-tp29337186p29337854.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
