java操作Excel的poi 创建一个sheet页

package com.java.poi;import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Workbook;import java.io.FileOutputStream;/**
* @author nidegui
* @create 2019-06-17 9:42
*/
public class Test2 {
/**
* 创建一个sheet页
* @param args
* @throws Exception
*/
public static void main(String[] args) throws Exception{
Workbook wb=new HSSFWorkbook();
wb.createSheet("第一个sheet页");
FileOutputStream fileOutputStream=new FileOutputStream("E:\\1.xls");
wb.write(fileOutputStream);
fileOutputStream.close();
}
}

package com.java.poi;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;import java.io.FileOutputStream;/**
* @author nidegui
* @create 2019-06-17 9:46
*/
public class Test3 {
public static void main(String[] args) throws Exception {
Workbook wb=new HSSFWorkbook();
Sheet sheet = wb.createSheet("创建sheet页");
Row row = sheet.createRow(0);//创建行
Cell cell = row.createCell(0);//创建一个单元格， 第一列
cell.setCellValue(1); //给单元格设置值 row.createCell(1).setCellValue(1.2); //创建一个单元格，第三列，值为1.2
row.createCell(2).setCellValue("这是一个字符串");
row.createCell(3).setCellValue(false); //4列 创建一个Boolean类型 FileOutputStream fileOutputStream=new FileOutputStream("E:\\3.xls");
wb.write(fileOutputStream);
fileOutputStream.close();
}
}