当前位置: 首页>>代码示例>>Java>>正文

Java WritableCellFormat类代码示例

本文整理汇总了Java中jxl.write.WritableCellFormat类的典型用法代码示例。如果您正苦于以下问题：Java WritableCellFormat类的具体用法？Java WritableCellFormat怎么用？Java WritableCellFormat使用的例子？那么, 这里精选的类代码示例或许可以为您提供帮助。


WritableCellFormat类属于jxl.write包，在下文中一共展示了WritableCellFormat类的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Java代码示例。

示例1: setExcelListTitle

import jxl.write.WritableCellFormat; //导入依赖的package包/类
/**
 * 设置报表内容头
 * 
 * @param listTitle
 *            报表头
 * @throws IOException
 * @throws WriteException
 */
@Deprecated
public void setExcelListTitle(String[] listTitle) throws WriteException, IOException {
    try {
        irow++;
        long start = System.currentTimeMillis();
        wfont = new WritableFont(WritableFont.createFont("宋体"), 10, WritableFont.BOLD, false,
            UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.BLACK);
        wcfFC = new WritableCellFormat(wfont);
        wcfFC.setBorder(Border.ALL, BorderLineStyle.MEDIUM);
        wcfFC.setAlignment(Alignment.CENTRE);// 对齐方式
        wcfFC.setVerticalAlignment(VerticalAlignment.CENTRE);// 对齐方式
        for (int i = icol; i < listTitle.length; i++) {
            wsheet.addCell(new Label(i, irow, listTitle[i], wcfFC));
        }
        trow = irow;
        logger.info("title use time:" + (System.currentTimeMillis() - start));
    } catch (Exception e) {
        this.close();
    }
}
开发者ID:iBase4J，项目名称:iBase4J-Common，代码行数:29，代码来源:DownloadExcelUtil.java

示例2: ExportTLDToXLS

import jxl.write.WritableCellFormat; //导入依赖的package包/类
public static void ExportTLDToXLS(String filename, ArrayList<Object> data) throws IOException {
    try {
        WritableFont titleFont = new WritableFont(WritableFont.ARIAL, 10, WritableFont.BOLD, true);
        WritableCellFormat titleformat = new WritableCellFormat(titleFont);
        WritableWorkbook workbook = Workbook.createWorkbook(new File(filename));
        WritableSheet sheet = workbook.createSheet("TLD Expand", 0);
        sheet.addCell(new Label(0, 0, "Domain name", titleformat));
        sheet.addCell(new Label(1, 0, "Name server", titleformat));
        sheet.addCell(new Label(2, 0, "Admin name", titleformat));
        sheet.addCell(new Label(3, 0, "Registrant", titleformat));
        int nextRow = 1;
        Iterator i = data.iterator();
        while (i.hasNext()) {
            DomainResult res = (DomainResult) i.next();
            sheet.addCell(new Label(0, nextRow, res.getDomainName()));
            sheet.addCell(new Label(1, nextRow, res.getNameServer()));
            sheet.addCell(new Label(2, nextRow, res.getAdminName()));
            sheet.addCell(new Label(3, nextRow, res.getRegistrant()));
            nextRow++;
        }
        workbook.write();
        workbook.close();
    } catch (WriteException ex) {
        Logger.getLogger("resultExport.ExportForwardLookupsToXLS").log(Level.SEVERE, null, ex);
    }
}
开发者ID:sensepost，项目名称:yeti，代码行数:27，代码来源:ResultExport.java

示例3: ExportCertToXLS

import jxl.write.WritableCellFormat; //导入依赖的package包/类
public static void ExportCertToXLS(String filename, ArrayList<Object> data) throws IOException {
    try {
        WritableFont titleFont = new WritableFont(WritableFont.ARIAL, 10, WritableFont.BOLD, true);
        WritableCellFormat titleformat = new WritableCellFormat(titleFont);
        WritableWorkbook workbook = Workbook.createWorkbook(new File(filename));
        WritableSheet sheet = workbook.createSheet("SSLCert CN", 0);
        sheet.addCell(new Label(0, 0, "IP address", titleformat));
        sheet.addCell(new Label(1, 0, "Host name", titleformat));
        sheet.addCell(new Label(2, 0, "Domain name", titleformat));
        int nextRow = 1;
        Iterator i = data.iterator();
        while (i.hasNext()) {
            CertResult res = (CertResult) i.next();
            sheet.addCell(new Label(0, nextRow, res.getIpAddress()));
            sheet.addCell(new Label(1, nextRow, res.getHostName()));
            sheet.addCell(new Label(2, nextRow, res.getDomainName()));
            nextRow++;
        }
        workbook.write();
        workbook.close();
    } catch (WriteException ex) {
        Logger.getLogger("resultExport.ExportForwardLookupsToXLS").log(Level.SEVERE, null, ex);
    }
}
开发者ID:sensepost，项目名称:yeti，代码行数:25，代码来源:ResultExport.java

示例4: setReportTitle

import jxl.write.WritableCellFormat; //导入依赖的package包/类
/**
 * 设置报表标题
 * 
 * @param reportTitle
 *            报表标题
 * @throws IOException
 * @throws WriteException
 * @throws WriteException
 */
public void setReportTitle(String reportTitle) throws WriteException, IOException {
    try {
        irow++;
        wfont = new WritableFont(WritableFont.createFont("宋体"), 12, WritableFont.BOLD, false,
            UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.BLACK);
        wcfFC = new WritableCellFormat(wfont);
        wcfFC.setAlignment(Alignment.CENTRE);// 对齐方式
        // wcfFC.setBackground(jxl.format.Colour.VERY_LIGHT_YELLOW);// 背景色
        wcfFC.setVerticalAlignment(VerticalAlignment.CENTRE);// 对齐方式
        // wcfFC.setBorder(Border.ALL, BorderLineStyle.MEDIUM,
        // Colour.BLACK);//
        // 边框
        wsheet.addCell(new Label(icol, irow, reportTitle, wcfFC));
        trow = irow;
    } catch (Exception e) {
        this.close();
    }
}
开发者ID:iBase4J，项目名称:iBase4J-Common，代码行数:28，代码来源:DownloadExcelUtil.java

示例5: setExcelListTitle

import jxl.write.WritableCellFormat; //导入依赖的package包/类
/**
 * 设置报表内容头
 * 
 * @param listTitle
 *            报表头
 * @throws IOException
 * @throws WriteException
 */
@Deprecated
public void setExcelListTitle(String[] listTitle) throws WriteException, IOException {
    try {
        irow++;
        long start = System.currentTimeMillis();
        wfont = new WritableFont(WritableFont.createFont("宋体"), 10, WritableFont.BOLD, false,
            UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.BLACK);
        wcfFC = new WritableCellFormat(wfont);
        wcfFC.setBorder(Border.ALL, BorderLineStyle.MEDIUM);
        wcfFC.setAlignment(Alignment.CENTRE);// 对齐方式
        wcfFC.setVerticalAlignment(VerticalAlignment.CENTRE);// 对齐方式
        for (int i = icol; i < listTitle.length; i++) {
            wsheet.addCell(new Label(i, irow, listTitle[i], wcfFC));
        }
        trow = irow;
        log.info("title use time:" + (System.currentTimeMillis() - start));
    } catch (Exception e) {
        this.close();
    }
}
开发者ID:guokezheng，项目名称:automat，代码行数:29，代码来源:DownloadExcelUtil.java

示例6: format

import jxl.write.WritableCellFormat; //导入依赖的package包/类
/**
 * 单元格的格式设置 字体大小 颜色 对齐方式、背景颜色等...
 */
public static void format() {
    try {
        arial14font = new WritableFont(WritableFont.ARIAL, 14, WritableFont.BOLD);
        arial14font.setColour(jxl.format.Colour.LIGHT_BLUE);
        arial14format = new WritableCellFormat(arial14font);
        arial14format.setAlignment(jxl.format.Alignment.CENTRE);
        arial14format.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.THIN);
        arial14format.setBackground(jxl.format.Colour.VERY_LIGHT_YELLOW);

        arial10font = new WritableFont(WritableFont.ARIAL, 10, WritableFont.BOLD);
        arial10format = new WritableCellFormat(arial10font);
        arial10format.setAlignment(jxl.format.Alignment.CENTRE);
        arial10format.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.THIN);
        arial10format.setBackground(Colour.GRAY_25);

        arial12font = new WritableFont(WritableFont.ARIAL, 10);
        arial12format = new WritableCellFormat(arial12font);
        arial10format.setAlignment(jxl.format.Alignment.CENTRE);//对齐格式
        arial12format.setBorder(jxl.format.Border.ALL,jxl.format.BorderLineStyle.THIN); //设置边框

    } catch (WriteException e) {
        e.printStackTrace();
    }
}
开发者ID:HowieTianDev，项目名称:ChenYan，代码行数:28，代码来源:ExcelUtils.java

示例7: format

import jxl.write.WritableCellFormat; //导入依赖的package包/类
public static void format() {
    try {
        arial14font = new WritableFont(WritableFont.ARIAL, 14, WritableFont.BOLD);
        arial14font.setColour(jxl.format.Colour.LIGHT_BLUE);
        arial14format = new WritableCellFormat(arial14font);
        arial14format.setAlignment(jxl.format.Alignment.CENTRE);
        arial14format.setBorder(jxl.format.Border.ALL, jxl.format.BorderLineStyle.THIN);
        arial14format.setBackground(jxl.format.Colour.VERY_LIGHT_YELLOW);
        arial10font = new WritableFont(WritableFont.ARIAL, 10, WritableFont.BOLD);
        arial10format = new WritableCellFormat(arial10font);
        arial10format.setAlignment(jxl.format.Alignment.CENTRE);
        arial10format.setBorder(jxl.format.Border.ALL, jxl.format.BorderLineStyle.THIN);
        arial10format.setBackground(jxl.format.Colour.LIGHT_BLUE);
        arial12font = new WritableFont(WritableFont.ARIAL, 12);
        arial12format = new WritableCellFormat(arial12font);
        arial12format.setBorder(jxl.format.Border.ALL, jxl.format.BorderLineStyle.THIN);
    } catch (WriteException e) {

        e.printStackTrace();
    }
}
开发者ID:qiu-yongheng，项目名称:Bluetooth_BLE，代码行数:22，代码来源:ExcelUtils.java

示例8: writeFieldRow

import jxl.write.WritableCellFormat; //导入依赖的package包/类
private void writeFieldRow(WritableSheet spreadSheet, HashMap<String, Object> fieldRow, int maxIndexedColumnIndex, int r, ExcelCellFormat f,
		HashMap<String, WritableCellFormat> cellFormats) throws Exception {
	if (fieldRow != null && distinctColumnNames != null && distinctColumnNames.size() > 0) {
		int c = maxIndexedColumnIndex;
		for (int d = 0; d < distinctColumnNames.size(); d++) {
			String columnName = distinctColumnNames.get(d);
			Object fieldValue = fieldRow.get(columnName);
			Integer columnIndex = getColumnIndex(columnName);
			if (columnIndex == null) {
				c++;
				columnIndex = c;
			}
			if (fieldValue != null) {
				ExcelUtil.writeCell(spreadSheet, columnIndex.intValue(), r, fieldValue.getClass(), fieldValue, f, cellFormats);
			} else {
				ExcelUtil.writeCell(spreadSheet, columnIndex.intValue(), r, String.class, null, f, cellFormats);
			}
		}
	}
}
开发者ID:phoenixctms，项目名称:ctsms，代码行数:21，代码来源:SpreadSheetWriter.java

示例9: getHeader

import jxl.write.WritableCellFormat; //导入依赖的package包/类
public static WritableCellFormat getHeader() {
	WritableFont font = new WritableFont(WritableFont.TIMES, 10,
			WritableFont.BOLD);// 定义字体
	try {
		font.setColour(Colour.BLUE);// 蓝色字体
	} catch (WriteException e1) {
		e1.printStackTrace();
	}
	WritableCellFormat format = new WritableCellFormat(font);
	try {
		format.setAlignment(jxl.format.Alignment.CENTRE);// 左右居中
		format.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);// 上下居中
		// format.setBorder(Border.ALL, BorderLineStyle.THIN,
		// Colour.BLACK);// 黑色边框
		// format.setBackground(Colour.YELLOW);// 黄色背景
	} catch (WriteException e) {
		e.printStackTrace();
	}
	return format;
}
开发者ID:reallin，项目名称:Android_Excel，代码行数:21，代码来源:ExcelUtil.java

示例10: addColumnName

import jxl.write.WritableCellFormat; //导入依赖的package包/类
public void addColumnName(String... columnNames) throws WriteException {
	int columnCount = this.sheet.getColumns();
	// System.err.println("columnCount:" + columnCount);
	for (int i = 0; i < columnNames.length; i++) {
		// 通过函数WritableFont（）设置字体样式
		// 第一个参数表示所选字体
		// 第二个参数表示字体大小
		// 第三个参数表示粗体样式，有BOLD和NORMAL两种样式
		// 第四个参数表示是否斜体,此处true表示为斜体
		// 第五个参数表示下划线样式
		// 第六个参数表示颜色样式，此处为Red
		WritableFont wf = new WritableFont(WritableFont.TIMES, 11, WritableFont.BOLD);
		CellFormat cf = new WritableCellFormat(wf);
		Label label = new Label(i + columnCount, 0, columnNames[i], cf);
		sheet.addCell(label);
	}
}
开发者ID:tanhaichao，项目名称:leopard，代码行数:18，代码来源:ExcelView.java

示例11: addMultipleLabelsWrap

import jxl.write.WritableCellFormat; //导入依赖的package包/类
private void addMultipleLabelsWrap(WritableSheet sheet, int col, int row, String s[], WritableCellFormat format) throws RowsExceededException, WriteException {
	if (sheet==null || s==null)
		return;
	
	if (s.length==0)
		return;
	
	if (s.length==1)
		sheet.addCell(new Label(col,row,s[0],format));
	else {		
		String result = s[0];
		
		for (int i=1; i<s.length; i++)
			//result = result + ", " + s[i];	
			result = result + "\n" + s[i];
		sheet.addCell(new Label(col,row,result,format));
	}
}
开发者ID:vagfed，项目名称:hmcScanner，代码行数:19，代码来源:Loader.java

示例12: addNumber

import jxl.write.WritableCellFormat; //导入依赖的package包/类
private void addNumber(WritableSheet sheet, int col, int row, String s[], int index, WritableCellFormat format) throws RowsExceededException, WriteException {		
	if (sheet==null || s==null)
		return;
	
	if (index>=s.length)
		return;
	
	double d; 
	
	try {
		d = Double.parseDouble(s[index]);
		
		// Only keep 2 digits: avoid rounding errors
		d = 1d*(int)(d*100)/100;
		
		sheet.addCell(new Number(col,row,d,format));
	} catch (NumberFormatException nfe) {}	
}
开发者ID:vagfed，项目名称:hmcScanner，代码行数:19，代码来源:Loader.java

示例13: addNumberDiv1024

import jxl.write.WritableCellFormat; //导入依赖的package包/类
private void addNumberDiv1024(WritableSheet sheet, int col, int row, String s[], int index, WritableCellFormat format) throws RowsExceededException, WriteException {		
	if (sheet==null || s==null)
		return;
	
	if (index>=s.length)
		return;
	
	double d; 
	
	try {
		d = Double.parseDouble(s[index]);
		d = d / 1024;
		
		// Only keep 2 digits: avoid rounding errors
		d = 1d*(int)(d*100)/100;
		
		sheet.addCell(new Number(col,row,d,format));
	} catch (NumberFormatException nfe) {}	
}
开发者ID:vagfed，项目名称:hmcScanner，代码行数:20，代码来源:Loader.java

示例14: getContentLabel

import jxl.write.WritableCellFormat; //导入依赖的package包/类
/**
 * 每个单元格的内容及格式
 * 
 * @param col
 * @param row
 * @param field
 * @param content
 * @return
 */
protected Label getContentLabel(int col, int row, Field field, Object content) {
	WritableCellFormat cellFormat = contentCenterFormat;
	String contentStr = "";
	contentStr = null != content ? content.toString() : "";
	// 将数字转变成千分位格式
	String numberStr = getNumbericValue(contentStr);
	// numberStr不为空，说明是数字类型。
	if (null != numberStr && !numberStr.trim().equals("")) {
		contentStr = numberStr;
		// 数字要右对齐
		cellFormat = contentRightFormat;
	} else {
		// 如果是时间类型。要格式化成标准时间格式
		String timeStr = getTimeFormatValue(field, content);
		// timeStr不为空，说明是时间类型
		if (null != timeStr && !timeStr.trim().equals("")) {
			contentStr = timeStr;
		}
	}

	Label label = new Label(col, row, contentStr, cellFormat);
	return label;
}
开发者ID:giantray，项目名称:ExcelTool，代码行数:33，代码来源:ExportExcelUtil.java

示例15: addCell

import jxl.write.WritableCellFormat; //导入依赖的package包/类
/**
	 * (导出)Excel内容填充(从第三行开始)
	 * 
	 * @param Info
	 * @param ws
	 * @param format
	 * @param rowscount
	 * @throws Exception
	 */
	private void addCell(ExcelModel eModel, Object obj, WritableSheet ws,
			WritableCellFormat format, int rowscount) throws Exception {
	
		if (obj != null) {
			int cols = 0;
			ExcelColumn ec = null;
			// List ecList =
			// HibDb.queryHQL("from ExGroupCode ec where ec.status='A' and ec.exGroup.excel.code='"+code+"'");

			int count = 0;
			for (int i = 0; i < eModel.getEcList().size(); i++) {
				ec = (ExcelColumn) eModel.getEcList().get(i);
//				if(ec.getCols()>=0){
					ws.addCell(new Label(i - count, rowscount, this.getValue(eModel, obj, ec.getCols(), ec.getCode()), format));
					cols++;
//				}
			}

		}
	}
开发者ID:jview，项目名称:jtools，代码行数:30，代码来源:ExcelBizImpl.java


注：本文中的jxl.write.WritableCellFormat类示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。