java 读取.xlsx_java 读取xlsx

(1)导入maven

org.apache.poi

poi

3.9

(2)代码

public static void main(String[] args) {

// 解压Book1.xlsx

ZipFile xlsxFile;

try {

xlsxFile = new ZipFile(new File("/Users/chengtao/downloads/教练入职时间.xlsx"));

DocumentBuilderFactory dbf = DocumentBuilderFactory.newInstance();

// 先读取sharedStrings.xml这个文件备用

ZipEntry sharedStringXML = xlsxFile.getEntry("xl/sharedStrings.xml");

InputStream sharedStringXMLIS = xlsxFile.getInputStream(sharedStringXML);

Document sharedString;

sharedString = dbf.newDocumentBuilder().parse(sharedStringXMLIS);

NodeList str = sharedString.getElementsByTagName("t");

String sharedStrings[] = new String[str.getLength()];

for (int n = 0; n < str.getLength(); n++) {

Element element = (E