会python真的可以为所欲为0(回)
356天前
这里还有人吗1(回)
541天前这里还有人吗0(回)
541天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
766天前到处都是羊，不想上班0(回)
846天前
鸽子
0(回)
850天前import java.io.File; |
import jxl.Workbook; |
import jxl.format.Border; |
import jxl.format.BorderLineStyle; |
import jxl.format.Colour; |
import jxl.write.Label; |
import jxl.write.WritableCellFormat; |
import jxl.write.WritableFont; |
import jxl.write.WritableSheet; |
import jxl.write.WritableWorkbook; |
/** |
* |
* @author XHW |
* |
* @date 2012-2-29 |
* |
*/ |
public class ExcelHandle { |
/** |
* @param args |
*/ |
public static void main(String[] args) { |
ExcelHandle excelHandle = new ExcelHandle(); |
excelHandle.writeExcel(); |
} |
/** |
* 写入Excel |
* |
*/ |
public void writeExcel() { |
try { |
// 写入到那个Excel文件 如：c:\\hello.xls,或者hello.xls(这个是在项目的根目录下) |
WritableWorkbook wwb = Workbook |
.createWorkbook(new File("hello.xls")); |
// 创建Excel工作表 指定名称和位置 |
WritableSheet ws = wwb.createSheet("Test Sheet 1", 0); |
// 设置表格的列宽度 |
ws.setColumnView(0, 14);// 第一列宽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);// 第7列宽12 |
// **************往工作表中添加数据***************** |
// 定义字体格式：字体为：微软雅黑，24号子，加粗 |
WritableFont titleFont = new WritableFont( |
WritableFont.createFont("微软雅黑"), 24, WritableFont.NO_BOLD); |
WritableFont contentFont = new WritableFont( |
WritableFont.createFont("楷体 _GB2312"), 12, |
WritableFont.NO_BOLD); |
WritableCellFormat titleFormat = new WritableCellFormat(titleFont); |
WritableCellFormat contentFormat = new WritableCellFormat( |
contentFont); |
WritableCellFormat contentFormat2 = new 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, 0, 6, 0);// 合并单元格A-G共7列 |
ws.addCell(new Label(0, 0, "广州XXX大学2009级研究生课程考试成绩册", titleFormat)); |
ws.addCell(new Label(0, 1, "课程名称", contentFormat2)); |
ws.mergeCells(1, 1, 6, 1);// 合并单元格B-G共6列 |
ws.addCell(new Label(1, 1, "大学数学", contentFormat2)); |
ws.addCell(new Label(0, 2, "院所教研室", contentFormat2)); |
ws.mergeCells(1, 2, 6, 2);// 合并单元格B-G共6列 |
ws.addCell(new Label(0, 3, "填表人", contentFormat2)); |
ws.addCell(new Label(2, 3, "教研室负责人", contentFormat2)); |
String th[] = { "学号", "姓名", "学院", "平时成绩", "期末成绩", "总成绩", "补考成绩" }; |
for (int i = 0; i < 7; i++) { |
ws.addCell(new Label(i, 4, th[i], contentFormat2)); |
} |
// 这里我们可以从数据库里面查询数据，然后在这里获取数据 |
int xh = 200901; |
String xm = "王佳佳"; |
String xy = "XXX信息技术学院"; |
String space = " "; |
int cj = 50; |
String bk = "补 80"; |
// 向Excel中插入数据 |
for (int j = 5; j < 10; j++) { |
ws.addCell(new Label(0, j, "" + xh + j + "", contentFormat)); |
ws.addCell(new Label(1, j, xm + j, contentFormat)); |
ws.addCell(new Label(2, j, xy, contentFormat)); |
ws.addCell(new Label(3, j, space, contentFormat)); |
ws.addCell(new Label(4, j, space, contentFormat)); |
ws.addCell(new Label(5, j, "" + cj + j + "", contentFormat)); |
ws.addCell(new Label(6, j, "" + bk + "", contentFormat)); |
} |
// 写入工作表完毕，关闭流 |
wwb.write(); |
wwb.close(); |
} catch (Exception e) { |
e.printStackTrace(); |
} |
} |
} |
