怎样在Android中解析doc、docx、xls、xlsx格式文件？

最新推荐文章于 2024-11-05 17:54:15 发布

xiaomao5200

最新推荐文章于 2024-11-05 17:54:15 发布

阅读量556

点赞数

分类专栏： Android 文章标签： android string exception null path

本文链接：https://blog.csdn.net/xiaomao5200/article/details/7598816

版权

Android 专栏收录该内容

51 篇文章 0 订阅

订阅专栏

可以直接复制实验，
解析doc，要tm-extractors-0.4.jar这个包
解析xls，要jxl.jar这个包

 
   01public  static String readDOC(String path) { 
 
   02                // 创建输入流读取doc文件 
 
   03                FileInputStream in; 
 
   04                String text = null; 
 
   05//                Environment.getExternalStorageDirectory().getAbsolutePath()+ "/aa.doc") 
 
   06                try { 
 
   07                        in = new FileInputStream(new File(path)); 
 
   08                        int a= in.available(); 
 
   09                        WordExtractor extractor = null; 
 
   10                        // 创建WordExtractor 
 
   11                        extractor = new WordExtractor(); 
 
   12                        // 对doc文件进行提取 
 
   13                        text = extractor.extractText(in); 
 
   14                        System.out.println("解析得到的东西"+text); 
 
   15                } catch (FileNotFoundException e) { 
 
   16                        e.printStackTrace(); 
 
   17                } catch (Exception e) { 
 
   18                        e.printStackTrace(); 
 
   19                } 
 
   20                if (text == null) { 
 
   21                        text = "解析文件出现问题";  
 
   22                } 
 
   23                return text; 
 
   24        }

解析xls

 
   01public  static String readXLS(String path) { 
 
   02                String str = ""; 
 
   03                try { 
 
   04                        Workbook workbook = null; 
 
   05                        workbook = Workbook.getWorkbook(new File(path)); 
 
   06                        Sheet sheet = workbook.getSheet(0); 
 
   07                        Cell cell = null; 
 
   08                        int columnCount = sheet.getColumns(); 
 
   09                        int rowCount = sheet.getRows(); 
 
   10                        for (int  i = 0; i < rowCount; i++) { 
 
   11                                for (int  j = 0; j < columnCount; j++) { 
 
   12                                        cell = sheet.getCell(j, i); 
 
   13                                        String temp2 = ""; 
 
   14                                        if (cell.getType() == CellType.NUMBER) { 
 
   15                                                temp2 = ((NumberCell) cell).getValue() + ""; 
 
   16                                        } else if (cell.getType() == CellType.DATE) { 
 
   17                                                temp2 = "" + ((DateCell) cell).getDate(); 
 
   18                                        } else { 
 
   19                                                temp2 = "" + cell.getContents(); 
 
   20                                        } 
 
   21                                        str = str + "  " + temp2;  
 
   22                                } 
 
   23                                str += "\n"; 
 
   24                        } 
 
   25                        workbook.close(); 
 
   26                } catch (Exception e) { 
 
   27                } 
 
   28                if (str == null) { 
 
   29                        str = "解析文件出现问题";  
 
   30                } 
 
   31                return str; 
 
   32        }