首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 开发语言 > 编程 >

java采取jxl写入一个Excel文件

2013-01-23 
java采用jxl写入一个Excel文件package com.javaer.file?import java.io.Fileimport java.io.IOException

java采用jxl写入一个Excel文件

package com.javaer.file;?import java.io.File;import java.io.IOException;?import jxl.Workbook;import jxl.write.Label;import jxl.write.WritableCellFormat;import jxl.write.WritableFont;import jxl.write.WritableSheet;import jxl.write.WritableWorkbook;import jxl.write.WriteException;import jxl.write.biff.RowsExceededException;?public class ExcelWrite {?/** * @param args * @throws IOException  * @throws WriteException  * @throws RowsExceededException  */public static void main(String[] args) throws IOException, RowsExceededException, WriteException {String fname = "/1.xls";?File f = new File(fname);?WritableWorkbook wb=Workbook.createWorkbook(f);WritableSheet wsheet=wb.createSheet("第一页",0);?WritableFont font1= new WritableFont(WritableFont.ARIAL,10,WritableFont.BOLD); WritableCellFormat format1=new WritableCellFormat(font1);?wsheet.addCell(new Label(0,0, "名字",format1));wsheet.addCell(new Label(1,0, "外号",format1));wsheet.addCell(new Label(2,0, "排行",format1));//前面那个2是表示列,后面的0表示当前行?wsheet.addCell(new Label(0,1, "张三疯",format1));wsheet.addCell(new Label(1,1, "老鬼",format1));//wsheet.addCell(new Label(2,1, "1",format1));//前面那个2是表示列,后面的1表示当前行jxl.write.Number number = new jxl.write.Number(2,1,1 );//写入一个数字格式的。wsheet.addCell(number);?wb.write();wb.close();??}?}

首发地址:月小升博客?–?http://java-er.com/blog/java-jxl-write-excel/?
无特殊说明,文章均为月小升原创,欢迎转载,转载请注明本文地址,谢谢

热点排行