java 实现excel与txt 相互转化

pom依赖

<dependency>
    <groupId>net.sourceforge.jexcelapi</groupId>
    <artifactId>jxl</artifactId>
    <version>2.6.8</version>
</dependency>

样例excel转txt

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
import java.io.*;

public class ExcelToTxt {
    public static void main1(String[] args) {
        // 找到excel文件的路径
        String filepath = "D:\\data\\ln\\request\\eta.xls";
        try {
            Workbook workbook = Workbook.getWorkbook(new File(filepath));
            Sheet sheet = workbook.getSheet(0);
            //转成txt要保存的位置以及文件名
            File file = new File("D:/data/ln/request/eta.txt");
            FileWriter fw = new FileWriter(file);
            BufferedWriter bw = new BufferedWriter(fw);
            // j为行数，getCell("列号","行号")
            int j = sheet.getR