【poi第八节】poi对excel单元格的读写操作

x33g5p2x  于2021-12-28 转载在 其他  
字(1.1k)|赞(0)|评价(0)|浏览(331)

poi对excel单元格的读写操作

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.OutputStream;

import static javafx.scene.input.KeyCode.O;

/**
 * @ClassName 类名:ExcelDemo8
 * @Author作者: hzh
 * @Date时间:2018/12/4 15:33
 * 单元格的读写操作
 **/
public class ExcelDemo8 {

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

        InputStream inputStream = new FileInputStream("D://file//font.xls");
        POIFSFileSystem poifsFileSystem = new POIFSFileSystem(inputStream);

        Workbook wb = new HSSFWorkbook(poifsFileSystem);

        Sheet sheet = wb.getSheetAt(0);
        Row row = sheet.getRow(0);
        Cell cell = row.getCell(0);
        if(cell == null){
            row.createCell(4).setCellValue("hi 我被写入了");
        }

        FileOutputStream fileOutputStream = new FileOutputStream("D://file//font.xls");
        wb.write(fileOutputStream);
        wb.close();

    }
}

相关文章