package com.test;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
public class Test2 {
public static void main(String[] args) throws IOException {
// TODO Auto-generated method stub
//将源文件读入工作蒲
FileInputStream fileInputStream=new FileInputStream("C:\\Users\\Administrator.Win7-2017CVNAPK.000\\Desktop\\bbb.xls");
@SuppressWarnings("resource")
HSSFWorkbook hssfWorkbook=new HSSFWorkbook(fileInputStream);
//得到工作表
HSSFSheet sheet=hssfWorkbook.getSheet("工作表888");
//得到行
HSSFRow row=sheet.getRow(2);
//得到单元格
HSSFCell cell=row.createCell(3);
//设置单元格内容
cell.setCellValue("张艺兴");
//再次输出
FileOutputStream fileOutputStream = new FileOutputStream("C:\\Users\\Administrator.Win7-2017CVNAPK.000\\Desktop\\bbb.xls");
hssfWorkbook.write(fileOutputStream);
//hssfworkbook.write(fileInputStream);
//hssfworkbook.close();
//关闭资源
fileInputStream.close();
fileOutputStream.close();
}
}
利用java在excel中追加数据
最新推荐文章于 2024-05-22 17:18:31 发布