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

对于给定的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); } }

输出如下：