Jxl 修改Excel

最新推荐文章于 2021-05-27 05:45:55 发布

liaolzy

最新推荐文章于 2021-05-27 05:45:55 发布

阅读量128

点赞数

文章标签： Excel J# F#

本文链接：https://blog.csdn.net/liaolzy/article/details/83803296

版权


import jxl.Sheet;
import jxl.Workbook;
import jxl.format.Alignment;
import jxl.format.Border;
import jxl.format.BorderLineStyle;
import jxl.format.VerticalAlignment;
import jxl.write.Colour;
import jxl.write.Label;
import jxl.write.Number;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;


	java.text.DateFormat forM = new java.text.SimpleDateFormat("yyyy-MM-dd");
	String tem = "检查数据汇总表" + forM.format(new Date()) + ".xls";
	response.setContentType("application/vnd.ms-excel;charset=GBK");
	response.setHeader("Content-Disposition", "filename=" + StringHelper.toStandardStr(tem));
	OutputStream outputStream = response.getOutputStream();

	String fiName ="F:\\aa\\检查清单.xls";// 系统中设好的Excel模板
	File file1 = new File(fiName);   
	try {
		Workbook rwb = Workbook.getWorkbook(file1);
		WritableWorkbook wwb = Workbook.createWorkbook(outputStream, rwb);// file1 内容copy 到 outputStream （file2）
		WritableSheet ws = wwb.getSheet(0);

		Sheet sheet = rwb.getSheet(0);
		int rowCount = sheet.getRows(); // 行
		int columns = sheet.getColumns();// 列
		System.out.println(rowCount + "   " + columns); // 判断单元格的类型,做出相应的转换

		jxl.write.NumberFormat nf = new jxl.write.NumberFormat("#.##");
		jxl.write.WritableCellFormat double_ = new jxl.write.WritableCellFormat(
				nf);

		WritableCellFormat fontNoContent = null;
		WritableFont timesNoThin = new WritableFont(WritableFont
				.createFont("宋体"), 11);
		timesNoThin.setColour(Colour.RED); // 红色字体
		fontNoContent = new WritableCellFormat(timesNoThin);

		int nu = 0;
		int j = 0, i = 6;
		for (; i < rowCount - 1; i++) {
			j = 3;
			Number labelNN = new Number(j++, i, 3.14, double_); // 第一个是表示列的，第二才表示行
			ws.addCell(labelNN);
			Number labelNF = new Number(j++, i, 3.14 ); // 第一个是表示列的，第二才表示行
			ws.addCell(labelNF);
			Label labe3 = new Label(j++, i, "excel");
			ws.addCell(labe3);
		}
		wwb.write();
		wwb.close();
		rwb.close();
		outputStream.close();
	} catch (Exception e) {
		e.printStackTrace();
	}


   WritableCellFormat fontNoContent = null;   
   WritableFont timesNoThin  = new WritableFont(WritableFont.createFont("宋体"),11);     
   timesNoThin.setColour(Colour.RED);  //红色字体   
   fontNoContent = new WritableCellFormat(timesNoThin);    
   fontNoContent.setAlignment(jxl.format.Alignment.CENTRE); 
   fontNoContent.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);