mali.util.excel

Class SheetReport

java.lang.Object

mali.util.excel.SheetReport

public class SheetReport
extends java.lang.Object

excel one sheet 的內容 均設定在此 若未使用template ,則templateName 則設為空白

Author:

amman

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	KEY_BODY excel 報表 body
java.lang.String	KEY_FONTNAME_標楷體
static java.lang.String	KEY_FootCenter excel 報表表尾 center key
static java.lang.String	KEY_FootLeft excel 報表表尾 left key
static java.lang.String	KEY_FootRight excel 報表表尾 right key
static java.lang.String	KEY_HeadCenter excel 報表表頭 center key
static java.lang.String	KEY_HeadLeft excel 報表 表頭 left key
static java.lang.String	KEY_HeadRight excel 報表表頭 right key

Constructor Summary

Constructors

Constructor and Description
SheetReport()

Method Summary

Methods

Modifier and Type	Method and Description
BaseTable	getReportContent()
java.lang.String	getSheetName() get excelSheetName
int	getStartCol()
int	getStartRow()
java.lang.String	getTemplateName() get 範本檔
boolean	isDrawLine() 是否畫格線
boolean	isuseTemplatefile() 是否使用template file
void	setBodyContent(java.util.Vector<clsSqlData> dt) set 內容 body
void	setDrawLine(boolean in) set 是否要畫表格
void	setFootContent(java.util.Vector<clsSqlData> ft) set 表尾foot
void	setHeadContent(java.util.Vector<clsSqlData> ht) set 表頭head
void	setSheetName(java.lang.String insheetName) set excelSheetName
void	setStartCol(int incol) 開始列印Col位置 , no template 時取此值開始塞資料
void	setStartRow(int inrow) 開始列印Row位置, no template 時取此值開始塞資料
void	setTemplateName(java.lang.String intemplateName) set 範本檔

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

KEY_FONTNAME_標楷體

public final java.lang.String KEY_FONTNAME_標楷體

See Also:

Constant Field Values

KEY_HeadLeft

public static final java.lang.String KEY_HeadLeft

excel 報表 表頭 left key

See Also:

Constant Field Values

KEY_HeadCenter

public static final java.lang.String KEY_HeadCenter

excel 報表表頭 center key

See Also:

Constant Field Values

KEY_HeadRight

public static final java.lang.String KEY_HeadRight

excel 報表表頭 right key

See Also:

Constant Field Values

KEY_FootLeft

public static final java.lang.String KEY_FootLeft

excel 報表表尾 left key

See Also:

Constant Field Values

KEY_FootRight

public static final java.lang.String KEY_FootRight

excel 報表表尾 right key

See Also:

Constant Field Values

KEY_FootCenter

public static final java.lang.String KEY_FootCenter

excel 報表表尾 center key

See Also:

Constant Field Values

KEY_BODY

public static final java.lang.String KEY_BODY

excel 報表 body

See Also:

Constant Field Values

Constructor Detail

SheetReport

public SheetReport()

Method Detail

setTemplateName

public void setTemplateName(java.lang.String intemplateName)

set 範本檔

Parameters:

intemplateName -

getTemplateName

public java.lang.String getTemplateName()

get 範本檔

Returns:

setSheetName

public void setSheetName(java.lang.String insheetName)

set excelSheetName

Parameters:

insheetName -

getSheetName

public java.lang.String getSheetName()

get excelSheetName

Returns:

setHeadContent

public void setHeadContent(java.util.Vector<clsSqlData> ht)

set 表頭head

Parameters:

ht -

setFootContent

public void setFootContent(java.util.Vector<clsSqlData> ft)

set 表尾foot

Parameters:

ft -

setBodyContent

public void setBodyContent(java.util.Vector<clsSqlData> dt)

set 內容 body

Parameters:

dt -

getReportContent

public BaseTable getReportContent()

Returns:

setStartRow

public void setStartRow(int inrow)

開始列印Row位置, no template 時取此值開始塞資料

Parameters:

inrow -

setStartCol

public void setStartCol(int incol)

開始列印Col位置 , no template 時取此值開始塞資料

Parameters:

incol -

isuseTemplatefile

public boolean isuseTemplatefile()

是否使用template file

Returns:

setDrawLine

public void setDrawLine(boolean in)

set 是否要畫表格

Parameters:

in -

isDrawLine

public boolean isDrawLine()

是否畫格線

Returns:

getStartCol

public int getStartCol()

getStartRow

public int getStartRow()