01public static String readXLSX(String path) {
02 String str = "";
03 String v = null;
04 boolean flat = false;
05 List<String> ls = new ArrayList<String>();
06 try {
07 ZipFile xlsxFile = new ZipFile(new File(path));
08 ZipEntry sharedStringXML = xlsxFile
09 .getEntry("xl/sharedStrings.xml");
10 InputStream inputStream = xlsxFile.getInputStream(sharedStringXML);
11 XmlPullParser xmlParser = Xml.newPullParser();
12 xmlParser.setInput(inputStream, "utf-8");
13 int evtType = xmlParser.getEventType();
14 while (evtType != XmlPullParser.END_DOCUMENT) {
15 switch (evtType) {
16 case XmlPullParser.START_TAG:
17 String tag = xmlParser.getName();
18 if (tag.equalsIgnoreCase("t")) {
19 ls.add(xmlParser.nextText());
20 }
21 break;
22 case XmlPullParser.END_TAG:
23 break;
24 default:
25 break;
26 }
27 evtType = xmlParser.next();
28 }
29 ZipEntry sheetXML = xlsxFile.getEntry("xl/worksheets/sheet1.xml");
30 InputStream inputStreamsheet = xlsxFile.getInputStream(sheetXML);
31 XmlPullParser xmlParsersheet = Xml.newPullParser();
32 xmlParsersheet.setInput(inputStreamsheet, "utf-8");
33 int evtTypesheet = xmlParsersheet.getEventType();
34 while (evtTypesheet != XmlPullParser.END_DOCUMENT) {
35 switch (evtTypesheet) {
36 case XmlPullParser.START_TAG:
总结失败的原因能够让人越来越谨慎。
