• Word,Excel,pdf,txt等文件上传并提取内容


    近期项目需求:1.要用到各种文件上传,下载。

    2.并对文件进行搜索。

    3.仅仅要文件里包括有搜索的内容,所有显示出来。



    今天正好有时间整理一下,方便以后阅读,及对须要用到的朋友提供微薄之力。首先在实现文件上传时,使用的struts2自带的文件上传功能,通过流的方式将文件保存,在下载的时候通过流的方式写出就可以。这个实现起来不是非常难,主要是对各种文件内容的提取比較麻烦,比方word,excel,pdf等文件,不能使用普通的BufferedReader,BufferedWriter等流的方式读写提取,由于这些文件的格式不是普通的文本,他们有自定义的格式,必须使用他们自己提供的jar包进行操作,Word,Excel使用的是Apache提供的poi进行操作,当然在操作的过程中要注意一些使用的方法,比方Word,Excel有不同的版本号,操作的方式也不同,这里会出现非常多问题,在上一篇中我整理了一些,我在操作过程出现的问题,并提供了解决方式,还有提供了本人操作这些文件的源代码,下载就可以使用。

    一下是我在操作过程用到的具体信息:


    struts.xml配置:

    <action name="upload" class="lucenesAction" method="upload">
    <!-- 此处能够限制上传文件类型

    <interceptor-ref name="fileUpload">
    上传单个文件的大小
    <param name="maximumSize">500000</param>
    文件的扩展名
    <param name="allowedExtensions">.jsp</param>
    文件的类型
    <param name="allowedTypes">image/pjpeg,image/gif,text/xml,text/plain,application/msword,application/vnd.ms-excel</param>
    </interceptor-ref>
    <interceptor-ref name="defaultStack"/> -->
    <result name="input">/demo/lucenes/upload_fail.jsp</result>
    <result name="success">/demo/lucenes/upload_ok.jsp</result>
    </action>



    Action中用到的操作文件信息:

    //下载使用的流

    public InputStream tInputStream;


    // 上传文件,必须的三个字段。
    private File data;
    // 文件名称
    private String dataFileName;
    // 文件类型
    private String dataContentType;

    //省略set/get.............


    Word操作类:

    import java.io.File;
    import java.io.FileInputStream;
    import java.io.FileOutputStream;
    import java.io.IOException;
    import org.apache.poi.POIXMLDocument;
    import org.apache.poi.POIXMLTextExtractor;
    import org.apache.poi.hwpf.HWPFDocument;
    import org.apache.poi.hwpf.extractor.WordExtractor;
    import org.apache.poi.hwpf.usermodel.CharacterProperties;
    import org.apache.poi.hwpf.usermodel.HWPFList;
    import org.apache.poi.hwpf.usermodel.ParagraphProperties;
    import org.apache.poi.hwpf.usermodel.Range;
    import org.apache.poi.openxml4j.opc.OPCPackage;
    import org.apache.poi.xwpf.extractor.XWPFWordExtractor;
    import org.junit.Test;


    /**
     * 提取word内容
     * 
     * @author wangshouhai
     * @Version 2014-4-17:下午12:07:04
     */
    public class ReadWord {


    public static void main(String[] args) {


    File file = new File("C:\Users\Administrator\Desktop\測试文档.docx");
    // readWord2003(file);


    readWord2007(file);

    }


    /**
    * 支持word-2003

    * @param args
    */
    private static void readWord2003(File file) {
    try {
    FileInputStream fis = new FileInputStream(file);
    // 创建WordExtractor对象
    WordExtractor wordExtractor = new WordExtractor(fis);
    // 取得全部文本内容
    String text = wordExtractor.getText();
    System.out.println("readWord2003--------------->"+text);
    } catch (Exception e) {
    e.printStackTrace();
    }
    }


    @Test
    // 支持word-2003
    public static void readWordExtractor(File file) {
    try {
    FileInputStream fis = new FileInputStream(file);
    // 创建WordExtractor对象
    WordExtractor wordExtractor = new WordExtractor(fis);
    // 通过getParagraphText()提取每一个段落
    String[] paragraph = wordExtractor.getParagraphText();
    System.out.println("该Word文件共同拥有" + paragraph.length + "段。");


    for (int i = 0; i < paragraph.length; i++) {
    System.out.println("readWordExtractor--------------->"+paragraph[i]);
    }
    } catch (Exception e) {
    e.printStackTrace();
    }
    }


    /**
    * word 2007解决方式

    * @param args
    */
    @Test
    public static void readWord2007(File file) {
    try {
    // word 2007,读取word中字符
    OPCPackage opcPackage = POIXMLDocument.openPackage("D:\apache-tomcat-6.0.18\webapps\GOVWBWeb\upload\user\2014\04\18\08\193b299f-e8fc-4a32-a7ba-f951beeec1d9");
    POIXMLTextExtractor extractor = new XWPFWordExtractor(opcPackage);
    String text2007 = extractor.getText();
    System.out.println("readWord2007--------------->"+text2007);
    } catch (Exception e) {
    e.printStackTrace();
    }
    }

    }



    Excel操作类:

    import java.io.File;
    import java.io.FileInputStream;
    import org.apache.poi.hssf.usermodel.HSSFCell;
    import org.apache.poi.hssf.usermodel.HSSFRow;
    import org.apache.poi.ss.usermodel.Sheet;
    import org.apache.poi.ss.usermodel.Workbook;
    import org.apache.poi.ss.usermodel.WorkbookFactory;
    import org.apache.poi.xssf.usermodel.XSSFCell;
    import org.apache.poi.xssf.usermodel.XSSFRow;
    import org.apache.poi.xssf.usermodel.XSSFSheet;
    import org.apache.poi.xssf.usermodel.XSSFWorkbook;


    /**
     * 读取excel内容
     * @author wangshouhai
     * @Version 2014-4-18:下午12:56:23
     */
    public class ReadExcel {

    // 文件上传
    public static void readExcel2007(File file) {


    try {
    // 创建工作区,读取上传文件
    XSSFWorkbook wb= new XSSFWorkbook(new FileInputStream(file));
    XSSFSheet sheet =wb.getSheetAt(0); 
    int rows = sheet.getPhysicalNumberOfRows();// 获取全部的行
    if (rows > 0) {
    for (int i = 1; i < rows; i++) {
    XSSFRow row=sheet.getRow(i);
    if (row == null) {
    continue;
    }
    try {
    XSSFCell idCell = row.getCell(0);
    if (idCell != null) {
    double id = idCell.getNumericCellValue();
    //int id = Integer.parseInt(idCell.getRichStringCellValue().toString());
    System.out.println("id----------->"+id);
    }


    // 账号
    XSSFCell accountsCell = row.getCell(1);
    String accounts = null;
    if (accountsCell != null) {
    accounts = accountsCell.getRichStringCellValue().toString();
    System.out.println("accounts----------->"+accounts);
    }


    // password
    XSSFCell passwordCell = row.getCell(2);
    if (passwordCell != null) {
    String password = passwordCell.getRichStringCellValue().toString();
    System.out.println("password----------->"+password);
    }


    // 姓名
    XSSFCell nameCell = row.getCell(3);
    if (nameCell != null) {
    String name = nameCell.getRichStringCellValue().toString();
    System.out.println("name----------->"+name);
    }


    // 性别
    XSSFCell sexCell = row.getCell(4);
    if (sexCell != null) {
    double sex = idCell.getNumericCellValue();
    //String sex = sexCell.getRichStringCellValue().toString();
    //int sexs = Integer.parseInt(sex);
    System.out.println("sex----------->"+sex);
    }


    // 邮箱
    XSSFCell emailCell = row.getCell(5);
    if (emailCell != null) {
    String email = emailCell.getRichStringCellValue().toString();
    System.out.println("email----------->"+email);
    }


    // 手机
    XSSFCell phoneCell = row.getCell(6);
    if (phoneCell != null) {
    String phone = phoneCell.getRichStringCellValue().toString();
    System.out.println("phone----------->"+phone);
    }


    } catch (Exception e) {
    throw new RuntimeException(e);
    }
    }
    }
    } catch (Exception e) {
    throw new RuntimeException(e);
    }
    }



    public static void readExcel2003(File file) {


    try {
    // 创建工作区,读取上传文件
    Workbook wb = WorkbookFactory.create(new FileInputStream(file));
    Sheet sheet = wb.getSheetAt(0);
    int rows = sheet.getPhysicalNumberOfRows();// 获取全部的行


    if (rows > 0) {
    for (int i = 1; i < rows; i++) {
    //获取每一行
    HSSFRow row = (HSSFRow) sheet.getRow(i);
    if (row == null) {
    continue;
    }
    try {
    //获取列数開始
    HSSFCell idCell = row.getCell(0);
    if (idCell != null) {
    double id = idCell.getNumericCellValue();
    // int id =
    // Integer.parseInt(idCell.getRichStringCellValue().toString());
    System.out.print("id: "+id+",");
    }


    // 账号
    HSSFCell accountsCell = row.getCell(1);
    String accounts = null;
    if (accountsCell != null) {
    accounts = accountsCell.getRichStringCellValue().toString();
    System.out.print("accounts: "+accounts+",");
    }


    // password
    HSSFCell passwordCell = row.getCell(2);
    if (passwordCell != null) {
    String password = passwordCell.getRichStringCellValue().toString();
    System.out.print("password: "+password+",");
    }


    // 姓名
    HSSFCell nameCell = row.getCell(3);
    if (nameCell != null) {
    String name = nameCell.getRichStringCellValue().toString();
    System.out.print("name: "+name+",");
    }


    // 性别
    HSSFCell sexCell = row.getCell(4);
    if (sexCell != null) {
    double sex = idCell.getNumericCellValue();
    // String sex =
    // sexCell.getRichStringCellValue().toString();
    // int sexs = Integer.parseInt(sex);
    System.out.print("sex: "+sex+",");
    }


    // 邮箱
    HSSFCell emailCell = row.getCell(5);
    if (emailCell != null) {
    String email = emailCell.getRichStringCellValue().toString();
    System.out.print("email: "+email+",");
    }


    // 手机
    HSSFCell phoneCell = row.getCell(6);
    if (phoneCell != null) {
    String phone = phoneCell.getRichStringCellValue().toString();
    System.out.println("phone: "+phone);
    }
    } catch (Exception e) {
    throw new RuntimeException(e);
    }
    }
    }
    } catch (Exception e) {
    throw new RuntimeException(e);
    }
    }

    /**
    * 读取Excel2007
    * @param args
    */

    public static void main(String[] args) {
    File file = new File("D:\apache-tomcat-6.0.18\webapps\GOVWBWeb\upload\user\2014\04\18\11\adcc6bc6-bd5e-43e9-9a53-3ba879dfa62d.xlsx");
    //readExcel2007(file);
    readExcel2003(new File("C:\Users\Administrator\Desktop\export.xls"));
    }
    }



    Pdf操作类:

    import java.io.FileInputStream;
    import org.apache.pdfbox.cos.COSDocument;
    import org.apache.pdfbox.pdfparser.PDFParser;
    import org.apache.pdfbox.pdmodel.PDDocument;
    import org.apache.pdfbox.util.PDFTextStripper;


    /**
     * 提取pdf中的内容
     * @author wangshouhai
     * @Version 2014-4-18:下午12:47:27
     */
    public class ReadPdf {
    public String readFdf(String file) {
    try {
    PDFParser parser = new PDFParser(new FileInputStream(file));
    parser.parse();
    COSDocument doc=parser.getDocument();
    PDFTextStripper stripper = new PDFTextStripper();
    String docText = stripper.getText(new PDDocument(doc));
    docText= convertorSymbol(docText); 
    return docText;
    } catch (Exception e) {
    throw new RuntimeException(e);
    }
    }




    /**
    * 处理特殊字符

    * @param sub
    * @param docText
    */
    public static String convertorSymbol(String docText) {
    StringBuilder sub = new StringBuilder();
    char[] ch = docText.toCharArray();
    for (int i = 0; i < ch.length; i++) {
    char buf = ch[i];
    if (9 == buf || 10 == buf || 13 == buf || 32 <= buf && !Character.isISOControl(buf)) {
    sub.append(buf);
    }
    }
    return sub.toString().replaceAll("\s*", "");
    }

    public static void main(String args[]) {
    String text =new ReadPdf().readFdf("D:\html2.pdf");
    System.out.println("ReadPdf---------->"+text);
    }
    }


    文本操作类:



    import java.io.BufferedReader;
    import java.io.File;
    import java.io.FileInputStream;
    import java.io.IOException;
    import java.io.InputStreamReader;


    public class ReadText {
    /**
    * 读取文本内容

    * @param dataFile
    * @return
    */
    public static String readText(File file) {
    StringBuilder sub = new StringBuilder();
    BufferedReader bufReader = null;
    try {
    bufReader = new BufferedReader(new InputStreamReader(new FileInputStream(file), "utf-8"));
    String str;
    while ((str = bufReader.readLine()) != null) {
    sub.append(str);
    }
    return convertorSymbol(sub.toString());
    } catch (Exception e) {
    throw new RuntimeException(e);
    } finally {
    if (bufReader != null) {
    try {
    bufReader.close();
    } catch (IOException e) {
    throw new RuntimeException(e);
    }
    }
    }
    }

    /**
    * 处理特殊字符

    * @param sub
    * @param docText
    */
    public static String convertorSymbol(String docText) {
    StringBuilder sub = new StringBuilder();
    char[] ch = docText.toCharArray();
    for (int i = 0; i < ch.length; i++) {
    char buf = ch[i];
    if (9 == buf || 10 == buf || 13 == buf || 32 <= buf && !Character.isISOControl(buf)) {
    sub.append(buf);
    }
    }
    return sub.toString();
    }



    public static void main(String[] args) {
    File file = new File("C:/Users/Administrator/Desktop/异常信息列表.txt");
    String text = readText(file);
    System.out.println("text-->"+text);
    }
    }


  • 相关阅读:
    揭开Socket编程的面纱(留着自己慢慢看)
    XML 新手入门基础知识
    RocketMQ集群平滑下线或重启某个节点
    RocketMQ borker配置文件
    ES:在线迁移集群索引,数据不丢失
    SQL命令汇总
    Redis过期key淘汰策略
    中间件服务器内核参数优化
    在线做RAID命令
    CPU网卡亲和绑定
  • 原文地址:https://www.cnblogs.com/zfyouxi/p/4298214.html
Copyright © 2020-2023  润新知