Java通过jxl.jar写入Excel数据

Java通过jxl.jar写入Excel数据，代码如下：

package Excel;



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 WriteExcel {

	public static void main(String[] args) {
		try {
			writeExcel();
		} catch (WriteException | IOException e) {
			e.printStackTrace();
		}

	}
	private static void writeExcel() throws IOException, RowsExceededException,WriteException {
		File xlsFile = new File("jxl.xlsx");
		// 创建一个工作簿
		WritableWorkbook workbook = Workbook.createWorkbook(xlsFile);
		// 创建一个工作表
		WritableSheet sheet0 = workbook.createSheet("价格", 0);
		WritableSheet sheet1 = workbook.createSheet("水果", 0);
		// 向行和列中写数据
		for (int row = 0; row < 10; row++) {
			for (int col = 0; col < 10; col++) {
				// 向工作表中添加数据
				sheet0.addCell(new Label(col, row, "sheet0"+"行：" + row +"列："+ col));
				sheet1.addCell(new Label(col, row,  row + col+""));
			}
		}
		workbook.write();
		workbook.close();
	}

}

所使用的jar包为jxl-2.6.12.jar、jxl-2.6.12-sources.jar，下载地址：https://download.csdn.net/download/qq_42017767/12662474