Java 解析Excel(xls、xlsx两种格式)
一、环境
JDK 1.8
二、JAR
1.commons-collections4-4.1.jar
2.poi-3.9-20121203.jar
3.poi-examples-3.9-20121203.jar
4.poi-excelant-3.9-20121203.jar
5.poi-ooxml-3.9-20121203.jar
6.poi-ooxml-schemas-3.9-20121203.jar
7.poi-scratchpad-3.9-20121203.jar
8.xmlbeans-2.3.0.jar
注意:jar版本为3.9
三、主要API
1.import org.apache.poi.ss.usermodel.Workbook,对应Excel文档;
2.import org.apache.poi.hssf.usermodel.HSSFWorkbook,对应xls格式的Excel文档;
3.import org.apache.poi.xssf.usermodel.XSSFWorkbook,对应xlsx格式的Excel文档;
4.import org.apache.poi.ss.usermodel.Sheet,对应Excel文档中的一个sheet;
5.import org.apache.poi.ss.usermodel.Row,对应一个sheet中的一行;
6.import org.apache.poi.ss.usermodel.Cell,对应一个单元格。
四、示例
package poi;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.IOException;import java.io.InputStream;import java.util.ArrayList;import java.util.LinkedHashMap;import java.util.List;import java.util.Map;import java.util.Map.Entry;import org.apache.poi.hssf.usermodel.HSSFWorkbook;import org.apache.poi.ss.usermodel.Cell;import org.apache.poi.ss.usermodel.DateUtil;import org.apache.poi.ss.usermodel.Row;import org.apache.poi.ss.usermodel.Sheet;import org.apache.poi.ss.usermodel.Workbook;import org.apache.poi.xssf.usermodel.XSSFWorkbook;public class Testpoi { public static void main(String[] args) { Workbook wb =null; Sheet sheet = null; Row row = null; List