java 修改Excel表格的内容through poi

 

String fileToBeRead = "src//one.xls"; // 读入的文件名
        try {
            HSSFWorkbook workbook = new HSSFWorkbook(new FileInputStream(
                    fileToBeRead));
            HSSFSheet sheet = workbook.getSheet("Sheet1");//得到第一个sheet
 
            for (int i = 1; i <= sheet.getLastRowNum(); i++) {
                HSSFRow row = sheet.getRow((short) i);
                if (null == row) {
                    continue;
                } else {
                    HSSFCell cell1 = row.getCell(1);//得到第i+1行的第2列
                    HSSFCell cell2 =row.getCell(2);//得到第二列
                    if (null == cell1&&null==cell2) {
                        continue;
                    } else {
                        //System.out.println(cell1.getNumericCellValue());
                       // System.out.println(cell2.getNumericC