java jxl 写 excel文件_Java使用jxl写入Excel文件

首先添加jxl的maven依赖：

net.sourceforge.jexcelapi

jxl

2.6.12

示例代码：

import java.io.File;

import java.io.IOException;

import jxl.Workbook;

import jxl.write.Label;

import jxl.write.WritableSheet;

import jxl.write.WritableWorkbook;

import jxl.write.WriteException;

import jxl.write.biff.RowsExceededException;

public class JxlTest {

public static void main(String[] args) throws IOException, RowsExceededException, WriteException {

File xlsFile = new File("D:\\jxl.xls");

// 创建一个工作簿

WritableWorkbook workbook = Workbook.createWorkbook(xlsFile);

// 创建一个工作表

WritableSheet sheet = workbook.createSheet("sheet1", 0);

for (int row = 0; row < 10; row++)

{

for (int col = 0; col < 10; col++)

{

// 向工作表中添加数据

sheet.addCell(new Label(col, row, "zifeiy" + row + "," + col));

}

}

workbook.write();

workbook.close();

}

}