public void writeToExl_GW(ByteArrayOutputStream byteOs)throws Exception{ try{ int timeLength = 0; ITrendService trendService = new TrendServiceImpl(); if(null != stepTime && !"".equals(stepTime)){ timeLength = Integer.valueOf(stepTime); } gwjcList=trendService.querygwjcList(beginTime,endTime,timeLength); String filename="轨温监测历史查询"+ new SimpleDateFormat("yyyy-MM-dd").format(new Date(System.currentTimeMillis())) + ".xls"; exportFileName = new String(filename.getBytes("GBK"), "ISO-8859-1"); WritableWorkbook wbook = Workbook.createWorkbook(byteOs); //建立excel文件 WritableSheet wsheet = wbook.createSheet("轨温监测历史查询", 0); //工作表名称 WritableFont wfont1 = new WritableFont(WritableFont.ARIAL, 9, //初始化一些样式 WritableFont.NO_BOLD, false, jxl.format.UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.RED); WritableFont wfont2 = new WritableFont(WritableFont.ARIAL, 10); WritableFont wfont3 = new WritableFont(WritableFont.ARIAL, 9, WritableFont.NO_BOLD, false, jxl.format.UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.AUTOMATIC); WritableFont wfont4 = new WritableFont(WritableFont.ARIAL, 10); WritableCellFormat titleFormat1 = new WritableCellFormat(wfont1); WritableCellFormat titleFormat2 =
jxl导出excel --- 居中 自动换行 边框 样式
最新推荐文章于 2023-03-03 15:17:10 发布
这篇教程详细介绍了如何利用jxl库在Java中生成Excel文件,并设置单元格的居中对齐、自动换行以及添加边框等样式。教程适合初学者,讲解清晰易懂。
摘要由CSDN通过智能技术生成