Excel文件（xls）解析JAVA

题目描述

提取表格中”岗位职责“一列的所有数据，以文本格式保存

工具

①JAVA ②jxl.jar包（一个java对excel文件编辑的基础工具包）

代码实现

import java.io.File;
import java.io.FileInputStream;
import java.io.FileWriter;
import java.io.IOException;
import java.io.InputStream;
import java.io.PrintWriter;
import java.util.ArrayList;

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;


public class test {
    public static void select_excel(File file) throws Exception {
        FileWriter fWriter = null;
        PrintWriter out = null;
        String fliename = file.getName().replace(".xls", "");
        fWriter = new FileWriter(file.getParent() + "/" + fliename + ".txt");
        out = new PrintWriter(fWriter);
        InputStream is = new FileInputStream(file.getAbsoluteFile());
        Workbook wb = null;
        wb = Workbook.getWorkbook(is);
        int sheet_size = wb.getNumberOfSheets();
        Sheet sheet = wb.getSheet(0);
        for (int j = 1; j < sheet.getRows(); j++) {
            String cellinfo = sheet.getCell(9, j).getContents();//岗位需求应该是在第10行，第二行是专业
            out.println(cellinfo);
        }
        out.close();
        fWriter.close();
        out.flush();
    }
    public static void main(String[] args) {
        try {
            select_excel(new File("E:\\original_info_copy1.xls"));
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}