[Java]九九乘法表输出到Excel表中，Excel后缀需要为：.xls

最新推荐文章于 2024-05-31 16:39:04 发布

现在是秋冬季

最新推荐文章于 2024-05-31 16:39:04 发布

阅读量514

点赞数

分类专栏： Java基础文章标签：输出输出excel表中九九乘法表

本文链接：https://blog.csdn.net/qq_24023751/article/details/81635984

版权

Java基础专栏收录该内容

32 篇文章 0 订阅

订阅专栏

package com.sj.zy;

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 九九乘法表 {

	public static void main(String[] args) throws RowsExceededException, WriteException, IOException {
		// TODO 自动生成的方法存根
		String path = "D://测试.xls";
		File file = new File(path);
		WritableWorkbook workbook = Workbook.createWorkbook(file);
		WritableSheet sheet = workbook.createSheet("第一页", 0);

		for (int i = 0; i <=8; i++) {
			for (int j = 0; j < i+1; j++) {

				Label label=new Label(j,i, j+1+"*"+(i+1)+"="+((i+1)*(j+1))+"  ");

				sheet.addCell(label);
			}
		}
		System.out.println("写入成功！");
		workbook.write();
		workbook.close();
		
	}

}