package com.hwtest.files; import org.apache.poi.hssf.usermodel.*; import org.apache.poi.hssf.util.HSSFColor; import org.apache.poi.poifs.filesystem.POIFSFileSystem; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.CellStyle; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.util.CellRangeAddress; import javax.swing.plaf.synth.Region; import java.io.FileInputStream; import java.io.FileOutputStream; /** * Created by dell on 2018/5/3. */ public class CreateExcel { public static void main(String args[]) { CreateExcel createExcel = new CreateExcel(); String path = "C:\\Users\\dell\\Desktop\\test.xlsx";//路径可随意替换 try { //随意创建一个Excel createExcel.createExcel(path); //读取上一行创建的Excel createExcel.getExcel(path); System.out.println("----------我是分割线----------"); //创建Excel的表头 createExcel.createExcelTop(path); //读取上一行创建的Excel createExcel.getExcel(path); } catch (Exception e) { e.printStackTrace(); } } //创建Excel文件 public void createExcel(String path) throws Exception { //创建Excel文件对象 HSSFWorkbook wb = new HSSFWorkbook(); //用文件对象创建sheet对象 HSSFSheet sheet = wb.createSheet("第一个sheet页"); //用sheet对象创建行对象 HSSFRow row = sheet.createRow(0); //创建单元格样式
用Java创建一个Excel
最新推荐文章于 2024-04-23 10:41:00 发布