使用Apache POI在Java中的Excel文件中创建图纸

2021年5月11日14:36:07 发表评论 337 次浏览

对于给定的Excel文件(此处极客), 则需要在其中创建表格。

步骤如下:

创建一个JAVA Maven项目

在pom.xml文件中添加依赖项

<!-- https://mvnrepository.com/artifact/org.apache.poi/poi --> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>3.12</version> </dependency> <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi-ooxml</artifactId> <version>3.12</version> </dependency>

在javaResource文件夹中创建一个类

import java.io.*; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; public class CreateSheet { public static void main(String[] args) throws FileNotFoundException, IOException { //Creating Workbook instances Workbook wb = new HSSFWorkbook(); //An output stream accepts output bytes and sends them to sink. OutputStream fileOut = new FileOutputStream( "Geeks.xlsx" ); //Creating Sheets using sheet object Sheet sheet1 = wb.createSheet( "Array" ); Sheet sheet2 = wb.createSheet( "String" ); Sheet sheet3 = wb.createSheet( "LinkedList" ); Sheet sheet4 = wb.createSheet( "Tree" ); Sheet sheet5 = wb.createSheet( "Dynamic Programing" ); Sheet sheet6 = wb.createSheet( "Puzzles" ); System.out.println( "Sheets Has been Created successfully" ); wb.write(fileOut); } }

输出如下:

Sheets Has been Created successfully

这里在geeks.xlsx文件中创建了6张纸:

使用Apache POI在Java中的Excel文件中创建图纸1

木子山

发表评论

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: