POI修改Excel内容

POI修改Excel内容

1.编写对象和方法

readexcel

package excel;


import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.FileInputStream;
import java.io.FileOutputStream;

public class readexcel {

    public void testread()throws Exception {
    //1.复制要修改Excel的文件路径，创建输入流
        String MyPath = "/Users/apple/Downloads/zidongtongji/src/main/java/excel/1.xlsx";
        FileInputStream fis = new FileInputStream(MyPath);

//2.创建一个工作簿
        Workbook workbook = new XSSFWorkbook(fis);
        Sheet sheet1 = workbook.getSheet("Sheet1");
//3.通过行下标和列下标返回cell对象
        Cell cell = sheet1.getRow(13).getCell(3);

        cell.setCellValue("呵呵呵呵呵呵呵");


/*Row row1 = sheet1.createRow(9);
//4.创建一个单元格
Cell cell1 = row1.createCell(3);
cell1.setCellValue("trewaswgfvqerf");*/

        FileOutputStream fos = new FileOutputStream(MyPath);
        workbook.write(fos);
        fis.close();
    }
}

编写main函数，创建对象调用read方法

package excel;

public class mainExcel {


    public static void main(String[] args) throws Exception {

        readexcel readexcel = new readexcel();
       readexcel.testread();


    }
}