开发是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