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