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

新建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();
	}
}

效果：