jxl创建读取excel文件

最新推荐文章于 2021-05-20 15:40:16 发布

ldz0414

最新推荐文章于 2021-05-20 15:40:16 发布

阅读量105

点赞数

分类专栏： other 文章标签： Excel

本文链接：https://blog.youkuaiyun.com/ldz0414/article/details/83837976

版权

other 专栏收录该内容

18 篇文章

订阅专栏


package test;

import java.io.File;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

public class JExcelTest {
	public static void main(String[] args) {
		//创建excel
		try {
			WritableWorkbook book = Workbook.createWorkbook(new File("test.xls"));
			WritableSheet sheet = book.createSheet("第一页", 0);
			Label label = new Label(0, 0, "test");
			sheet.addCell(label);

			jxl.write.Number number = new jxl.write.Number(1, 0, 123.2);
			sheet.addCell(number);

			book.write();
			book.close();
		} catch (Exception e) {
			e.printStackTrace();
		}

		//读取excel
		try {
			Workbook book = Workbook.getWorkbook(new File("test.xls"));
			Sheet sheet=book.getSheet(0);
			Cell cell1=sheet.getCell(1,0);
			String result=cell1.getContents();
			System.out.println(result);
			book.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}