关于如何写.xls内的内容

Question

关于如何写.xls内的内容

public class AdminGradeinput extends HttpServlet {

private static final long serialVersionUID = 1L;

public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    this.doPost(request, response);
}

public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    response.setContentType("text/html");
    int pageSize = request.getParameter("pageSize") == null ? 5
            : Integer.parseInt(request.getParameter("pageSize").toString());
    int pageNo = request.getParameter("pageNo") == null ? 1
            : Integer.parseInt(request.getParameter("pageNo").toString());

    RecordDao recordDao = new RecordDaoImpl();
    PageModel<SupGrade> pm = recordDao.pageByLogname(pageSize, pageNo);
    pm.setPageNav(request.getRequestURI());
    String filename = "/upload/grade.xls";
    String action = request.getParameter("action");
    if(action == null){
        SmartUpload su = new SmartUpload();
        su.initialize(getServletConfig(), request, response);
        su.setAllowedFilesList("xls");
        try {
            su.upload();
            Files files = su.getFiles();
            files.getFile(0).saveAs(filename, SmartUpload.SAVE_VIRTUAL);
        } catch (SmartUploadException e1) {
            e1.printStackTrace();
        }
        try {
            GradeDaoImpl gradeImpl = new GradeDaoImpl();
            System.out.println(new File(this.getServletContext().getRealPath("/upload")+"\\grade.xls"));
            Workbook workbook = Workbook.getWorkbook(new File(this.getServletContext().getRealPath("/upload")+"\\grade.xls"));
            Sheet sheet = workbook.getSheet(0);
            for(int row = 1;row < sheet.getRows();++row){
                SupGrade supgrade = new SupGrade();
                supgrade.setTestcardnum(sheet.getCell(0,row).getContents().trim());
                supgrade.setSname(sheet.getCell(1,row).getContents().trim());
                supgrade.setCname(sheet.getCell(2,row).getContents().trim());
                supgrade.setScore(Integer.parseInt(sheet.getCell(3,row).getContents().trim()));
                supgrade.setNote(Integer.parseInt(sheet.getCell(4,row).getContents().trim()));
                gradeImpl.gradeAdd(supgrade);    
            }
        } catch (BiffException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

    request.setAttribute("pm", pm);
    request.getRequestDispatcher("/jadmin/grade.jsp").forward(request, response);
}

}
有没有帮我看一下，急！