Apache POI(1):工作簿(workbook)和电子表(spreadsheet)

1 演示代码

package com.hthk.iisz.util;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.util.Iterator;
import java.util.Map;
import java.util.Set;
import java.util.TreeMap;

import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

/*
 * Workbook 工作簿
 * Spreadsheet 电子表格,电子表格是在Excel文件中的页面;它包含具有特定名称的行和列。
 * Row,Cell 行,列
 * 
 */
public class WorkBookAndSheet {


	public static void main(String[] args) throws Exception{
		//File file = createBlankWorkbook();
		//Workbook workbook = openExistingWorkbook(file);
		//createSheetAndFillData();
		readExcelData();
	}
	
	//创建一个空白的Workbook
	public static File createBlankWorkbook() throws Exception {
		//Create Blank WorkBook
		XSSFWorkb