使用Java在Excel文件中的特定位置创建单元格

Apache POI可用于在指定位置的给定Excel文件中创建单元格。 Apache POI是Apache基金会提供的API。

在给定Excel文件中特定位置创建单元的步骤：

在Eclipse或安装了POI库的Java项目中创建一个Maven项目(Maven是主要用于Java项目的构建自动化工具)

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

<!-- 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文件夹中编写Java代码

import java.io.*; import org.apache.poi.hssf.usermodel.HSSFWorkbook; 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; public class CreateCellAtSpecificPosition { public static void main(String[] args) throws FileNotFoundException, IOException { //Create a workbook instances Workbook wb = new HSSFWorkbook(); OutputStream os = new FileOutputStream( "Geeks.xlsx" ); //Creating a sheet using predefined class provided by Apache POI Sheet sheet = wb.createSheet( "Company Prepration" ); //Creating a row at specific position //using predefined class provided by Apache POI //Specific row number Row row = sheet.createRow( 1 ); //Specific cell number Cell cell = row.createCell( 1 ); //putting value at specific position cell.setCellValue( "Geeks" ); //writing the content to Workbook wb.write(os); System.out.println( "given cell is created at position (1, 1)" ); } }

2. filter_none

   编辑 关

   play_arrow

   链接 亮度_4 代码

   chevron_right

   filter_none

3. filter_none

   编辑 关

   play_arrow

   链接 亮度_4 代码

   chevron_right

   filter_none

输出如下

given cell is created at position (1, 1)

Geeks.xlsx文件中的输出

---