java的jxl技术导入Excel
发布时间：2020-12-14 06:27:16 所属栏目：Java 来源：网络整理
导读：在项目中我们看到Reference Libraries中的jxl.jar包，它是我们自己外部引入的包。 com.b510; java.io.File; jxl.Workbook; jxl.format.Border; jxl.format.BorderLineStyle; jxl.format.Colour; jxl.write.Label; jxl.write.WritableCellFormat; jxl.write.W
|
在项目中我们看到Reference Libraries中的jxl.jar包，它是我们自己外部引入的包。
com.b510; java.io.File; jxl.Workbook; jxl.format.Border; jxl.format.BorderLineStyle; jxl.format.Colour; jxl.write.Label; jxl.write.WritableCellFormat; jxl.write.WritableFont; jxl.write.WritableSheet; jxl.write.WritableWorkbook; ExcelHandle { main(String[] args) { ExcelHandle excelHandle = ExcelHandle(); excelHandle.writeExcel(); } writeExcel() { { WritableWorkbook wwb = Workbook .createWorkbook( File("hello.xls")); WritableSheet ws = wwb.createSheet("Test Sheet 1",0); ws.setColumnView(0,14); ws.setColumnView(1,12); ws.setColumnView(2,25); ws.setColumnView(3,20); ws.setColumnView(4,12); ws.setColumnView(5,9); ws.setColumnView(6,12); WritableFont titleFont = WritableFont(WritableFont .createFont("微软雅黑"),24,WritableFont.NO_BOLD); WritableFont contentFont = WritableFont(WritableFont .createFont("楷体 _GB2312"),12,WritableFont.NO_BOLD); WritableCellFormat titleFormat = WritableCellFormat(titleFont); WritableCellFormat contentFormat = WritableCellFormat( contentFont); WritableCellFormat contentFormat2 = WritableCellFormat( contentFont); contentFormat.setBorder(Border.ALL,BorderLineStyle.THIN, Colour.BLACK); titleFormat.setAlignment(jxl.format.Alignment.CENTRE); contentFormat2.setAlignment(jxl.format.Alignment.CENTRE); ws.mergeCells(0,6,0); ws.addCell( Label(0,"广州XXX大学2009级研究生课程考试成绩册",titleFormat)); ws.addCell( Label(0,1,"课程名称",contentFormat2)); ws.mergeCells(1,1); ws.addCell( Label(1,"大学数学",contentFormat2)); ws.addCell( Label(0,2,"院所教研室",contentFormat2)); ws.mergeCells(1,2); ws.addCell( Label(0,3,"填表人",contentFormat2)); ws.addCell( Label(2,"教研室负责人",contentFormat2)); String th[] = { "学号","姓名","学院","平时成绩","期末成绩","总成绩","补考成绩" }; ( i = 0; i < 7; i++) { ws.addCell( Label(i,4,th[i],contentFormat2)); } xh = 200901; String xm = "王佳佳"; String xy = "XXX信息技术学院"; String space = " "; cj = 50; String bk = "补 80"; ( j = 5; j < 10; j++) { ws.addCell( Label(0,j,"" + xh + j + "",contentFormat)); ws.addCell( Label(1,xm+j,contentFormat)); ws.addCell( Label(2,xy,contentFormat)); ws.addCell( Label(3,space,contentFormat)); ws.addCell( Label(4,contentFormat)); ws.addCell( Label(5,"" + cj + j + "",contentFormat)); ws.addCell( Label(6,"" + bk + "",contentFormat)); } wwb.write(); wwb.close(); } (Exception e) { e.printStackTrace(); } } }
java的poi技术读取和导入Excel： （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |