int startRow=Integer.parseInt(nvl(request.getParameter("startRow"),"0"));//指定开始行
int endRow=Integer.parseInt(nvl(request.getParameter("endRow"),"-1"));//结束行
int startCol=Integer.parseInt(nvl(request.getParameter("startCol"),"0"));//指定开始列
int endCol=Integer.parseInt(nvl(request.getParameter("endCol"),"-1"));//结束列
int sheetNum=Integer.parseInt(nvl(request.getParameter("sheetNum"),"0"));//指定工作薄
File sourcefile=new File(filePath);
InputStream is = new FileInputStream(sourcefile);
jxl.Workbook rwb = Workbook.getWorkbook(is);
Sheet rs = rwb.getSheet(sheetNum);//页
int col = rs.getColumns();//列
int row = rs.getRows();//行
out.println("row="+row);
for(int i=startRow;i<row;i++){
if(i==endRow)break;
if(rs.getCell(0,i).getContents().equals(""))break;
for(int j=startCol;j<col;j++){
Cell cell = rs.getCell(j, i);
String strC=cell.getContents();
out.print(strC+"|");
if(j==endCol)break;
}
out.println("<br>");
}
is.close();