Java生成和操作Excel文件 末蓝、 2022-06-08 03:22 141阅读 0赞 **JAVA EXCEL API**:是一开放源码项目,通过它Java开发人员可以读取Excel文件的内容、创建新的Excel文件、更新已经存在的Excel文件。 官网下载地址:[http://www.andykhan.com/jexcelapi/][http_www.andykhan.com_jexcelapi] 下载好了以后,解压压缩包,把里面的jxl.jar加入工程的lib文件夹中。 代码: package com.li.test; import java.io.FileOutputStream; import java.io.IOException; import java.io.OutputStream; import jxl.Workbook; import jxl.write.Label; import jxl.write.WritableSheet; import jxl.write.WritableWorkbook; import jxl.write.WriteException; public class JavaExlTest { public void createExcel(OutputStream os) throws WriteException,IOException{ //创建工作薄 WritableWorkbook workbook = Workbook.createWorkbook(os); //创建新的一页 WritableSheet sheet = workbook.createSheet("First Sheet",0); //创建要显示的内容,创建一个单元格,第一个参数为列坐标,第二个参数为行坐标,第三个参数为内容 Label xuexiao = new Label(0,0,"学校"); sheet.addCell(xuexiao); Label zhuanye = new Label(1,0,"专业"); sheet.addCell(zhuanye); Label jingzhengli = new Label(2,0,"专业竞争力"); sheet.addCell(jingzhengli); Label qinghua = new Label(0,1,"清华大学"); sheet.addCell(qinghua); Label jisuanji = new Label(1,1,"计算机专业"); sheet.addCell(jisuanji); Label gao = new Label(2,1,"高"); sheet.addCell(gao); Label beida = new Label(0,2,"北京大学"); sheet.addCell(beida); Label falv = new Label(1,2,"法律专业"); sheet.addCell(falv); Label zhong = new Label(2,2,"中"); sheet.addCell(zhong); Label ligong = new Label(0,3,"北京理工大学"); sheet.addCell(ligong); Label hangkong = new Label(1,3,"航空专业"); sheet.addCell(hangkong); Label di = new Label(2,3,"低"); sheet.addCell(di); //把创建的内容写入到输出流中,并关闭输出流 workbook.write(); workbook.close(); os.close(); } public static void main(String[] args) throws WriteException, IOException { OutputStream fileOut = new FileOutputStream("D:/2.xls"); JavaExlTest sw = new JavaExlTest(); sw.createExcel(fileOut); } } 测试结果: ![这里写图片描述][SouthEast] 学习于: [http://www.cnblogs.com/mingforyou/archive/2013/08/26/3282922.html][http_www.cnblogs.com_mingforyou_archive_2013_08_26_3282922.html] [http_www.andykhan.com_jexcelapi]: http://www.andykhan.com/jexcelapi/ [SouthEast]: /images/20220608/00eb697c7d5048b0935b73109ce2fcf3.png [http_www.cnblogs.com_mingforyou_archive_2013_08_26_3282922.html]: http://www.cnblogs.com/mingforyou/archive/2013/08/26/3282922.html
还没有评论,来说两句吧...