JAVA 小练习-10 POI 处理Excel文件-写入XLSX文件

最新推荐文章于 2023-01-04 20:02:34 发布

KathyLJQ

最新推荐文章于 2023-01-04 20:02:34 发布

阅读量258

点赞数

分类专栏： JAVA

本文链接：https://blog.csdn.net/KathyLJQ/article/details/109905562

版权

JAVA 专栏收录该内容

44 篇文章 0 订阅

订阅专栏

import java.io.IOException;

import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class WriteXLSX {
	public static void main(String[] args) {		
		try {
			File f = new File("C:\\Users\\Admin\\Desktop\\写入测试02.xlsx");
			FileOutputStream fop = new FileOutputStream(f);
			XSSFWorkbook xwb = new XSSFWorkbook();
			XSSFSheet xs = xwb.createSheet("写测试");
			for (int i = 0; i<10;i++){
				XSSFRow r = xs.createRow(i);
				for (int j = 0; j < 3;j++){
					XSSFCell xsc = r.createCell(j);
					xsc.setCellValue("hello"+"--"+i+"--"+j);
				}
			}
			xwb.write(fop);	
			xwb.close();
			fop.close();
		} catch ( Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
	
}