txt转成excel表格

开发是idea,用maven

        <!--jxl-->
        <dependency>
            <groupId>net.sourceforge.jexcelapi</groupId>
            <artifactId>jxl</artifactId>
            <version>2.6.12</version>
        </dependency>

代码

package com.zte.work;

import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStreamReader;
import java.util.ArrayList;
import java.util.List;

import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.biff.RowsExceededException;
/**
 * @Author czx
 * @Date: 2022/01/14/ 12:03
 * @Description
 */
public class TxtToExcel {
    public static void readFileByLines(String fileName) throws IOException,
            RowsExceededException, WriteException {
        // 打开文件
        WritableWorkbook book = Workbook.createWorkbook(new File(
                // 输出路径
                "D:\\codebank\\Excel\\output\\ip.xls"));
        // 生成名为“第一页”的工作表，参数0表示这是第一页
        WritableSheet sheet = book.createSheet("第一页", 0);
        // 读入txt中的内容
        File file = new File(fileName);
        FileInputStream fis = new FileInputStream(file);
        InputStreamReader isr = new InputStreamReader(fis, "gbk");
        BufferedReader reader = null;
        try {
            reader = new BufferedReader(isr);
            String tempString = null;
            // 一次读入一行，直到读入null为文件结束
            int i = 0;
            while ((tempString = reader.readLine()) != null) {
                System.out.println(tempString);
                // 输入路径的文件的分隔符
                String[] str = tempString.split(",");
                // Label[] label = null;
                for (int j = 0; j < str.length; j++) {
                    // 在Label对象的构造子中指名单元格位置是第j列第i行(j,i)以及单元格内容为str[j]
                    Label label = new Label(j, i, str[j]);
                    // 将定义好的单元格添加到工作表中
                    sheet.addCell(label);
                }
                i++;
            }
            // 写入数据并关闭文件
            book.write();
            try {
                book.close();
            } catch (WriteException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
            reader.close();
        } catch (IOException e) {
            e.printStackTrace();
        } finally {
            if (reader != null) {
                reader.close();
            }
        }
    }

    public static void main(String[] args) throws RowsExceededException,
            WriteException {
        try {
            // 输入路径
            readFileByLines("D:\\codebank\\Excel\\input\\ipCount220110.txt");
        } catch (IOException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

}

 需要指定格式为.xls