java操作Excel【POI】——第一讲

谁践踏了优雅 2022-02-05 07:37 249阅读 0赞

新建maven项目：  
在pom.xml中导入POI包

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
      <modelVersion>4.0.0</modelVersion>
    
      <groupId>com.java1234</groupId>
      <artifactId>PoiDemo</artifactId>
      <version>0.0.1-SNAPSHOT</version>
      <packaging>jar</packaging>
    
      <name>PoiDemo</name>
      <url>http://maven.apache.org</url>
    
      <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
      </properties>
    
      <dependencies>
        <dependency>
          <groupId>junit</groupId>
          <artifactId>junit</artifactId>
          <version>3.8.1</version>
          <scope>test</scope>
        </dependency>
        
        <dependency>
    	    <groupId>org.apache.poi</groupId>
    	    <artifactId>poi</artifactId>
    	    <version>3.17</version>
    	</dependency>
        
      </dependencies>
    </project>

package com.java1234;
    
    import java.io.FileOutputStream;
    
    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 PoiTest1 {
    
    	public static void main(String[] args) throws Exception{
    		Workbook wb=new HSSFWorkbook();
    		Sheet sheet=wb.createSheet("第一个sheet");
    		wb.createSheet("第二个sheet");
    		
    		Row row=sheet.createRow(0);
    		Cell cell=row.createCell(0);
    		cell.setCellValue("你好啊");
    		row.createCell(1).setCellValue(false);
    		row.createCell(2).setCellValue(1.6);
    		FileOutputStream fileout=new FileOutputStream("d:\\用poi搞出来的工作簿.xls");
    		wb.write(fileout);
    		fileout.close();
    		wb.close();
    	}
    }

效果：  
![在D:盘生成对应的Excel文件][D_Excel]

[D_Excel]: /images/20220205/91cdcefe687d42ba8f9998e787698f0c.png