java jxl colour_Java WritableFont.setColour方法代码示例

import jxl.write.WritableFont; //导入方法依赖的package包/类

/**

* Outputs the data headings row.

*

* @param workSheet to add the row to

* @param table to fetch metadata from

* @param startRow to add the headings at

* @param helpTextRowNumbers - the map of column names to row index for each

* bit of help text

* @throws WriteException if any of the writes to workSheet failed

* @return the row to carry on inserting at

*/

private int outputDataHeadings(WritableSheet workSheet, Table table, final int startRow, final Map helpTextRowNumbers) throws WriteException {

int currentRow = startRow;

int columnNumber = 0;

final WritableCellFormat columnHeadingFormat = getBoldFormat();

columnHeadingFormat.setBackground(Colour.VERY_LIGHT_YELLOW);

WritableFont font = new WritableFont(WritableFont.ARIAL, 8, WritableFont.BOLD);

font.setColour(Colour.BLUE);

font.setUnderlineStyle(UnderlineStyle.SINGLE);

columnHeadingFormat.setFont(font);

for (Column column : table.columns()) {

if(columnNumber < MAX_EXCEL_COLUMNS && !column.getName().equals("id") && !column.getName().equals("version")) {

// Data heading is a link back to the help text

WritableHyperlink linkToHelp = new WritableHyperlink(

columnNumber, currentRow,

spreadsheetifyName(column.getName()),

workSheet, 0, helpTextRowNumbers.get(column.getName()));

workSheet.addHyperlink(linkToHelp);

WritableCell label = workSheet.getWritableCell(columnNumber, currentRow);

label.setCellFormat(columnHeadingFormat);

// Update the help text such that it is a link to the heading

Cell helpCell = workSheet.getCell(0, helpTextRowNumbers.get(column.getName()));

WritableHyperlink linkFromHelp = new WritableHyperlink(

0, helpTextRowNumbers.get(column.getName()),

helpCell.getContents(),

workSheet, columnNumber, currentRow);

workSheet.addHyperlink(linkFromHelp);

columnNumber++;

}

}

currentRow++;

return currentRow;

}