JAVA開発メモ
POI のバックアップソース(No.4)
 

[トップ|一覧|単語検索|最終更新|バックアップ|ヘルプ]

*[[Jakarta POI:http://jakarta.apache.org/poi/]]
[[Jakarta POI:http://jakarta.apache.org/poi/]]は、JAVAのみでMicrosoft Officeファイル(word, excel)の読み書きを実現するAPI群から成り立つプロジェクトです。~
HSSFは、Microsoft Excel 97(-XP)のエクセルファイルを読み書きするためのAPIセットです。

**1.5から2.0の変更
HSSF (for reading and writing spreadsheets):
-Numerous bug fixes
-Improved support for non-english spreadsheets.
-Formula support
-Named cells and ranges
-Sheet reordering
-Zoom support
-Freeze and split panes supported
-Row and column headers
-Custom data formats
-Support for cloning objects
-Headers and footers
-Preservation of VBA macros when rewriting workbooks
-Support for hyperlinks by using cell formulas:
 cell.setCellFormula("HYPERLINK(\"http://google.com\",\"Google\")");
-Custom palettes

HPSF (for reading document properties):
-Bug fixes
-Custom properties

**Jakarta POI News
#showrss(http://nagoya.apache.org/poi/news/?flavor=rss2, menubar, 24, 1)

**Excellのセル配置指定
-水平方向
|HSSFCellStyle.ALIGN_CENTER|中央揃え|
|HSSFCellStyle.ALIGN_CENTER_SELECTION|選択範囲内で中央揃え|
|HSSFCellStyle.ALIGN_FILL|両端揃え|
|HSSFCellStyle.ALIGN_GENERAL|標準|
|HSSFCellStyle.ALIGN_JUSTIFY|均等割付|
|HSSFCellStyle.ALIGN_LEFT|左揃え|
|HSSFCellStyle.ALIGN_RIGHT|右揃え|
-垂直方向
|HSSFCellStyle.VERTICAL_BOTTOM|下詰め|
|HSSFCellStyle.VERTICAL_CENTER|中央揃え|
|HSSFCellStyle.VERTICAL_JUSTIFY|均等揃え|
|HSSFCellStyle.VERTICAL_TOP|上詰め|

**Excellの罫線
|HSSFCellStyle.BORDER_DASH_DOT|一点鎖線|
|HSSFCellStyle.BORDER_DASH_DOT_DOT|二点鎖線|
|HSSFCellStyle.BORDER_DASHED|点線(長)|
|HSSFCellStyle.BORDER_DOTTED|点線(短)|
|HSSFCellStyle.BORDER_DOUBLE|二重線|
|HSSFCellStyle.BORDER_HAIR|ヘアライン|
|HSSFCellStyle.BORDER_MEDIUM|普通|
|HSSFCellStyle.BORDER_MEDIUM_DASH_DOT|普通の一点鎖線|
|HSSFCellStyle.BORDER_MEDIUM_DASH_DOT_DOT|普通の二点鎖線|
|HSSFCellStyle.BORDER_MEDIUM_DASHED|普通の点線|
|HSSFCellStyle.BORDER_NONE|なし|
|HSSFCellStyle.BORDER_SLANTED_DASH_DOT|斜めにカットされた一点鎖線|
|HSSFCellStyle.BORDER_THICK|太線|
|HSSFCellStyle.BORDER_THIN|細線|

トップ 一覧 検索 最終更新 バックアップ   ヘルプ   最終更新のRSS

Modified by MT22(Moriwaki Takashi)

"PukiWiki" 1.3.7 Copyright © 2001,2002,2003 PukiWiki Developers Team. License is GNU/GPL.
Based on "PukiWiki" 1.3 by sng
Powered by PHP 5.3.29

HTML convert time to 0.003 sec.