Java导出excel表格1

《Java导出excel表格1》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、【Java】导出excel表格修改浏览权限

2、删除packagejxlTest;importjava.io.FileOutputStream;  importjava.io.OutputStream;  importjava.text.SimpleDateFormat;  importjava.util.ArrayList;  importjava.util.Date;  importjava.util.List;    importjxl.*;  importjxl.format.Alignment;  importjxl.format.Border;  import

3、jxl.format.BorderLineStyle;  importjxl.format.CellFormat;  importjxl.write.Boolean;  importjxl.write.Label;  importjxl.write.Number;  importjxl.write.WritableCellFormat;  importjxl.write.WritableFont;  importjxl.write.WritableSheet;  importjxl.write.WritableWorkbook;    publicclassJXLEx

4、ample{       /**     *数据库导出至Excel表格   */    publicstaticvoidmain(String[]args){         //准备设置excel工作表的标题         String[]title={"编号","产品名称","产品价格","产品数量","生产日期","产地","是否出口"};         try{              //获得开始时间              longstart=System.currentTimeMillis();             //输出的excel的路径

5、              StringfilePath="e:\testJXL.xls";              //创建Excel工作薄              WritableWorkbookwwb;             //新建立一个jxl文件,即在e盘下生成testJXL.xls              OutputStreamos=newFileOutputStream(filePath);              wwb=Workbook.createWorkbook(os);             //添加第一个工作表并设置第一个Sh

6、eet的名字            WritableSheetsheet=wwb.createSheet("产品清单",0);              Labellabel;              for(inti=0;i

7、    //将定义好的单元格添加到工作表中                sheet.addCell(label);             }             //下面是填充数据              /*               *保存数字到单元格，需要使用jxl.write.Number             *必须使用其完整路径，否则会出现错误             **/           //填充产品编号             jxl.write.Numbernumber=newjxl.write.Number(0,1,200710

8、01);             sheet.addCell(number);             //填充产品名称              label=newLabel(1,1,"金鸽瓜子");             sheet.addCell(label);             /*          *定义对于显示金额的公共格式            *jxl会自动实现四舍五入            *例如2.456会被格式化为2.46,2.454会被格式化为2.45            **/          jxl.writ