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();
}
}