We can use Jakarta COMMON POI to do it:
E.g. of Itertate over a file:
// load the excel
FileInputStream fin = new FileInputStream("simple1.xls");
POIFSFileSystem fs = new POIFSFileSystem(fin);
//create a Workbook
HSSFWorkbook wb = new HSSFWorkbook(fs);
// get a reference to the worksheet
int numberPage = wb.getNumberOfSheets();
// TODO:debug information
out.printf("Number Of Page %s%n", numberPage);
//read each sheet
for (int i = 0; i < numberPage; ++i) {
HSSFSheet sheet = wb.getSheetAt(i);
// TODO:debug information
int firstRow = sheet.getFirstRowNum();
int lastRow = sheet.getLastRowNum();
out.printf("FirstRow: %s, LastRow: %s%n", firstRow, lastRow);
out.printf("Physical Row: %s%n", sheet.getPhysicalNumberOfRows());
//read each Row
for (int j = firstRow; j <= lastRow; ++j) {
HSSFRow row = sheet.getRow(j);
//read each Cell
for (short k = row.getFirstCellNum(); k < row.getLastCellNum(); ++k) {
HSSFCell cell = (HSSFCell) row.getCell(k);
switch (cell.getCellType()) {
case (HSSFCell.CELL_TYPE_STRING): {
out.print(cell.getStringCellValue() + "\t");
break;
}
case (HSSFCell.CELL_TYPE_NUMERIC): {
out.print(cell.getNumericCellValue() + "\t");
break;
}
case (HSSFCell.CELL_TYPE_BOOLEAN): {
out.print(cell.getBooleanCellValue() + "\t");
break;
}
}
}
out.println();
}
}
fin.close();
Showing posts with label Jakarta. Show all posts
Showing posts with label Jakarta. Show all posts
Saturday, May 28, 2005
Sunday, May 15, 2005
Upload file in a JSP
利用 Oreilly MultiPartRequest 做的範例
http://www.javaworld.com.tw/Old/High/Upload.htm
利用 jspsmart SmartUpload 做的範例
http://www.javaworld.com.tw/Old/High/S_Upload.htm
Jakarta 當然也不能缺席嘛, 來個利用 Jakarta Commons FileUpload 做的範例
都是拿 browser 大大的東西來改的, 所以 File.html 拿這裡的就對了
http://www.javaworld.com.tw/Old/High/Upload.htm
也請參閱 jini 葛格的電子報
http://mychannel.pchome.com.tw/channel/class/class_paper_open.htm?d=2003-07-04&e=jakarta&t=.htm&j=17&f=main&v=1
解決了有些瀏覽器會傳送 path + filename 的問題
在電子報這行
// 因為不同的瀏覽器會造成傳遞 path + filename, 有些則只有 filename
註解下就是 jini 葛格加的程式碼
File.jsp (2.36k)
http://www.javaworld.com.tw/Old/High/Upload.htm
利用 jspsmart SmartUpload 做的範例
http://www.javaworld.com.tw/Old/High/S_Upload.htm
Jakarta 當然也不能缺席嘛, 來個利用 Jakarta Commons FileUpload 做的範例
都是拿 browser 大大的東西來改的, 所以 File.html 拿這裡的就對了
http://www.javaworld.com.tw/Old/High/Upload.htm
也請參閱 jini 葛格的電子報
http://mychannel.pchome.com.tw/channel/class/class_paper_open.htm?d=2003-07-04&e=jakarta&t=.htm&j=17&f=main&v=1
解決了有些瀏覽器會傳送 path + filename 的問題
在電子報這行
// 因為不同的瀏覽器會造成傳遞 path + filename, 有些則只有 filename
註解下就是 jini 葛格加的程式碼
Subscribe to:
Posts (Atom)