java+excel操作

/**
     * 读取指定行列
     *
     * @param col 列
     * @param row 行
     * @throws BiffException
     * @throws IOException
     */

    public String readRowsAndColums(int sheetNum, int row, int col) throws BiffException, IOException {

        //1:创建workbook
        Workbook workbook = Workbook.getWorkbook(new File("src/main/resources/excel/Excel.xls"));
        //2:获取第一个工作表sheet
        Sheet sheet = workbook.getSheet(sheetNum);
     
        Cell cell = sheet.getCell(col, row);
        String aa = cell.getContents();


        //最后一步：关闭资源
        workbook.close();
        return aa;
    }

/**
 * 将获取到的值写入到TXT或者xls中
 *
 * @param col
 * @param row
 * @param text
 * @throws Exception
 */
public void update_excel(int row, int col, String text) throws Exception {
    //1、创建Workbook
    HSSFWorkbook workbook = new HSSFWorkbook();
    //2、创建sheet,默认名字是sheet1，sheet2...
    HSSFSheet sheet = workbook.createSheet("基础数据");
    //3、创建row 参数是0代表第1行，参数是1代表第二行...
    Row row1 = sheet.createRow(row);
    //4、创建cell 第0列
    org.apache.poi.ss.usermodel.Cell cell = row1.createCell(col);
    //5、在cell中填充数据
    cell.setCellValue(text);
    //6、向文件中写入数据，以上步骤都是在内存中完成的，想要将文件持久化到磁盘需要文件输出流
    FileOutputStream outputStream = new FileOutputStream("src/main/resources/excel/存储数据.xls");
    workbook.write(outputStream);
    //7、关闭流
    outputStream.close();

}