試験管のなかのコード

JExcelAPI にチャレンジ(3)

JEXCELAPI にチャレンジ(2)の続き。

文字を BOLD にする

ByteArrayOutputStream baos = new ByteArrayOutputStream();
WritableWorkbook book = Workbook.createWorkbook(baos);

WritableSheet sheet = book.createSheet("my sheet", 0);

WritableCellFormat format = new WritableCellFormat();

WritableFont font = new WritableFont(format.getFont());
font.setBoldStyle(WritableFont.BOLD);

format.setFont(font);

Label label = new Label(0, 0, "hoge");
label.setCellFormat(format);
sheet.addCell(label);

文字をセンタリングする

ByteArrayOutputStream baos = new ByteArrayOutputStream();
WritableWorkbook book = Workbook.createWorkbook(baos);

WritableSheet sheet = book.createSheet("my sheet", 0);

WritableCellFormat format = new WritableCellFormat();

format.setAlignment(Alignment.CENTRE);


Label label = new Label(0, 0, "hoge");
label.setCellFormat(format);
sheet.addCell(label);

罫線を引く

セル単位で罫線を引くことができる。 使用できる線種は以下の通り。

• DASH_DOT
• DASH_DOT_DOT
• DASHED
• DOTTED
• DOUBLE
• HAIR
• MEDIUM
• MEDIUM_DASH_DOT
• MEDIUM_DASH_DOT_DOT
• MEDIUM_DASHED
• NONE
• SLANTED_DASH_DOT
• THICK
• THIN

ByteArrayOutputStream baos = new ByteArrayOutputStream();
WritableWorkbook book = Workbook.createWorkbook(baos);

WritableSheet sheet = book.createSheet("my sheet", 0);

WritableCellFormat format = new WritableCellFormat();

format.setBorder(Border.ALL, BorderLineStyle.THIN);


Label label = new Label(0, 0, "hoge");
label.setCellFormat(format);
sheet.addCell(label);

セルの背景色をセットする

ByteArrayOutputStream baos = new ByteArrayOutputStream();
WritableWorkbook book = Workbook.createWorkbook(baos);

WritableSheet sheet = book.createSheet("my sheet", 0);

WritableCellFormat format = new WritableCellFormat();

format.setBackground(Colour.LIGHT_ORANGE);


Label label = new Label(0, 0, "hoge");
label.setCellFormat(format);
sheet.addCell(label);

シートにヘッダをセットする

ByteArrayOutputStream baos = new ByteArrayOutputStream();
WritableWorkbook book = Workbook.createWorkbook(baos);

WritableSheet sheet = book.createSheet("my sheet", 0);

SheetSettings settings = sheet.getSettings();


HeaderFooter header = new HeaderFooter();
header.getCentre().append("My Bookmarks");
settings.setHeader(header);

シートにフッタをセットする

フッタもヘッダと同じ方法でセットできる。

ByteArrayOutputStream baos = new ByteArrayOutputStream();
WritableWorkbook book = Workbook.createWorkbook(baos);

WritableSheet sheet = book.createSheet("my sheet", 0);

SheetSettings settings = sheet.getSettings();


HeaderFooter footer = new HeaderFooter();
footer.getCentre().appendPageNumber();
footer.getCentre().append(" / ");
footer.getCentre().appendTotalPages();
settings.setFooter(footer);

Posted in Library | WriteBacks (0) | | | Bookmark this on Delicious