package org.example.wordToExcel;
/**
 * @Auther: rll
 * @Date: 2022/1/11 10:57
 * @Description: 每行對(duì)象類(lèi)
 */
public class MyExcelBook {
 
    private String xuHao;
 
    private String yingYongMing;
 
    private String yiBenZhang;
 
    private String jianShu;
 
    private String jianShe;
 
    private String jiXiao;
 
    private String jinDu;
 
    private String qianTou;
 
    private String canYu;
 
    public String getXuHao() {
        return xuHao;
    }
 
    public void setXuHao(String xuHao) {
        this.xuHao = xuHao;
    }
 
    public String getYingYongMing() {
        return yingYongMing;
    }
 
    public void setYingYongMing(String yingYongMing) {
        this.yingYongMing = yingYongMing;
    }
 
    public String getYiBenZhang() {
        return yiBenZhang;
    }
 
    public void setYiBenZhang(String yiBenZhang) {
        this.yiBenZhang = yiBenZhang;
    }
 
    public String getJianShu() {
        return jianShu;
    }
 
    public void setJianShu(String jianShu) {
        this.jianShu = jianShu;
    }
 
    public String getJianShe() {
        return jianShe;
    }
 
    public void setJianShe(String jianShe) {
        this.jianShe = jianShe;
    }
 
    public String getJiXiao() {
        return jiXiao;
    }
 
    public void setJiXiao(String jiXiao) {
        this.jiXiao = jiXiao;
    }
 
    public String getJinDu() {
        return jinDu;
    }
 
    public void setJinDu(String jinDu) {
        this.jinDu = jinDu;
    }
 
    public String getQianTou() {
        return qianTou;
    }
 
    public void setQianTou(String qianTou) {
        this.qianTou = qianTou;
    }
 
    public String getCanYu() {
        return canYu;
    }
 
    public void setCanYu(String canYu) {
        this.canYu = canYu;
    }
}

package org.example.wordToExcel;
 
import java.beans.PropertyDescriptor;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.lang.reflect.Field;
import java.lang.reflect.Method;
import java.util.ArrayList;
 
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hwpf.HWPFDocument;
import org.apache.poi.hwpf.usermodel.Paragraph;
import org.apache.poi.hwpf.usermodel.Range;
import org.apache.poi.hwpf.usermodel.Table;
import org.apache.poi.hwpf.usermodel.TableCell;
import org.apache.poi.hwpf.usermodel.TableIterator;
import org.apache.poi.hwpf.usermodel.TableRow;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
 
/**
 * @Auther: rll
 * @Date: 2022/1/11 15:57
 * @Description: word表格轉(zhuǎn)excel
 */
public class ReadWordToWriteExcel {
 
    static String fileName = "C:\\Users\\Desktop\\testFile";
 
    public static void main(String[] args) throws Exception {
        readWord();
    }
 
    public static void readWord() {
 
        ArrayList<MyExcelBook> list = new ArrayList<>();
        list.clear();
        try {
 
            FileInputStream in = new FileInputStream(fileName + ".doc");//載入文檔
            POIFSFileSystem pfs = new POIFSFileSystem(in);
            HWPFDocument hwpf = new HWPFDocument(pfs);
            Range range = hwpf.getRange();
            TableIterator it = new TableIterator(range);
 
            //遍歷word
            while (it.hasNext()) {
                Table tb = it.next();
                //遍歷行
                for (int i = 0; i < tb.numRows(); i++) {
                    TableRow tr = tb.getRow(i);
                    //迭代列
                    MyExcelBook excelBook = new MyExcelBook();
                    Class aClass = excelBook.getClass();
                    for (int j = 0; j < tr.numCells(); j++) {
                        TableCell td = tr.getCell(j);//取得單元格
                        //取得單元格的內(nèi)容
                        Field[] fields = aClass.getDeclaredFields();
 
                        //遍歷單元格所有內(nèi)容放入一個(gè)sb
                        StringBuilder sb = new StringBuilder();
                        for (int k = 0; k < td.numParagraphs(); k++) {
                            Paragraph para = td.getParagraph(k);
                            String s = para.text();
                            sb.append(s);
                        }
                        //反射遍歷excel字段,賦值給book對(duì)象
                        //反射賦值和取值
                        Field field = fields[j];
                        String fieldName = field.getName();
                        PropertyDescriptor pd = new PropertyDescriptor(field.getName(),
                                aClass);
 
                        // 獲取set方法
                        Method setMethod = pd.getWriteMethod();
                        setMethod.invoke(excelBook, sb.deleteCharAt(sb.length() - 1).toString());//去掉最后一個(gè)標(biāo)記符號(hào)
 
                        sb.delete(0, sb.length());
                    }
                    list.add(excelBook);
                }
            }
 
            writeExecl(list);
 
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
 
    public static void writeExecl(ArrayList<MyExcelBook> list) throws Exception {
        //創(chuàng)建一個(gè)webbook，對(duì)應(yīng)一個(gè)Excel文件
        HSSFWorkbook wb = new HSSFWorkbook();
        //在webbook中添加一個(gè)sheet,對(duì)應(yīng)Excel文件中的sheet
        HSSFSheet sheet = wb.createSheet("sheet1");
 
        HSSFRow row = null;
 
        for (int i = 0; i < list.size(); i++) {
            //在sheet中添加行
            row = sheet.createRow(i);
            MyExcelBook excelBook = list.get(i);
 
            //反射取值
            Class aClass = excelBook.getClass();
            Field[] fields = aClass.getDeclaredFields();
            for (int j = 0; j < fields.length; j++) {
                Field field = fields[j];
                String fieldName = field.getName();
                PropertyDescriptor pd = new PropertyDescriptor(fieldName,
                        aClass);
                //get方法
                Method getMethod = pd.getReadMethod();
                //創(chuàng)建單元格
                row.createCell(j).setCellValue(String.valueOf(getMethod.invoke(excelBook)));
            }
 
        }
        //生成文件
        try {
            FileOutputStream fout = new FileOutputStream(fileName + ".xls");
            wb.write(fout);
            fout.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
 
    }
 
}