mali.util

Class JxlUtility

java.lang.Object

mali.util.JxlUtility

public class JxlUtility
extends java.lang.Object

excel 報表列印套用元件工具

Author:

amman

Constructor Summary

Constructors

Constructor and Description
JxlUtility()

Method Summary

Methods

Modifier and Type	Method and Description
void	add(int row, java.lang.String as_string) 加入XLS 以Row 為基準
void	add(int row, java.lang.String as_string, jxl.write.WritableCellFormat inCellFormat) 加入XLS 以ROW 為基準, 若一整個Row 都是同一個CellFormat 可自定
void	add(java.lang.Object[] inObjectCell)
void	closeTempletefile() close templet file 開啟的動作
void	copytemplmenetCellRowToOutputCellRow(int fromCell, int rowend, int toCell)
void	copyToSheet(int i, java.lang.String insheetName, java.lang.String tempSheetName)
boolean	create() 開始建立 xls 檔案, 建立前先設定work xls , 如果有template xls 也要先設定
boolean	create(javax.servlet.http.HttpServletResponse response, java.lang.String outputfilename) 產生 output To Web
boolean	create(java.io.InputStream inis, javax.servlet.http.HttpServletResponse response, java.lang.String outputfilename) create xls 直接將InputStream 送入
void	createSheet(java.lang.String sheetname, int sheetnum)
boolean	getIsdrawLine()
java.lang.String	getOutput_filename()
jxl.write.WritableSheet	getSheet() 取sheet name
jxl.write.WritableSheet	getSheet(java.lang.String sheetname)
int	getStartColnum()
java.lang.String	getTemplate_filename()
jxl.Workbook	getTemplateXls() get Template XLS
jxl.write.WritableWorkbook	getWorkBook() 取目前工作的workbook
static java.lang.String	nullToSpace(java.lang.String str)
void	putall(java.util.Hashtable inalldata)
void	removeSheet(java.lang.String insheetName) 刪除 sheet Name remove sheet
void	saveToxls() 執行完畢後,儲存至實際檔案中
void	setCurrentSheet(int i)
void	setCurrentSheet(java.lang.String sheetName) 設定目前使用Sheet
void	setCurrentTemplateSheet(java.lang.String sheetName)
void	setIsdrawLine(boolean value) 設定是否畫線 true , false
void	setOutput_filename(java.lang.String value) 設定Work xls filename
void	setOutputPath(java.lang.String value)
void	setStartColnum(int value) 設定開始的Line default 為 0 , 第二行則為 1
void	setTemplate_fielname(java.lang.String value) 設定 Template xls filename, template 路徑在 maliconfig.properties 定義
void	setTemplatePath(java.lang.String intemppath) 設定templete path 目錄
void	settemplementCellRowToOutputCellRow(java.lang.String inSheetName, int startCellColumn, int rowend, java.util.Hashtable incellrows) set 單一CellRow
void	transMutiRowsToSheet(BaseTable indatas) 轉換mutirow, 可先定義
void	transRealDataToSheet(BaseTable indatas) 轉換 worktablesheet 資料 單一狀態, 欄位對欄位轉換
void	transRealDataToSheet(clsSqlData vfld)

Methods inherited from class java.lang.Object

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

Constructor Detail

JxlUtility

public JxlUtility()

Method Detail

getTemplate_filename

public java.lang.String getTemplate_filename()

setTemplate_fielname

public void setTemplate_fielname(java.lang.String value)

設定 Template xls filename, template 路徑在 maliconfig.properties 定義

Parameters:

value - String

setTemplatePath

public void setTemplatePath(java.lang.String intemppath)

設定templete path 目錄

Parameters:

intemppath -

getOutput_filename

public java.lang.String getOutput_filename()

getTemplateXls

public jxl.Workbook getTemplateXls()

get Template XLS

Returns:

setOutput_filename

public void setOutput_filename(java.lang.String value)

設定Work xls filename

Parameters:

value - String

getStartColnum

public int getStartColnum()

setOutputPath

public void setOutputPath(java.lang.String value)

setStartColnum

public void setStartColnum(int value)

設定開始的Line default 為 0 , 第二行則為 1

Parameters:

value - int

getIsdrawLine

public boolean getIsdrawLine()

setCurrentSheet

public void setCurrentSheet(java.lang.String sheetName)

設定目前使用Sheet

Parameters:

sheetName -

setCurrentTemplateSheet

public void setCurrentTemplateSheet(java.lang.String sheetName)

setCurrentSheet

public void setCurrentSheet(int i)

setIsdrawLine

public void setIsdrawLine(boolean value)

設定是否畫線 true , false

Parameters:

value - boolean

create

public boolean create()
               throws java.lang.Exception

開始建立 xls 檔案, 建立前先設定work xls , 如果有template xls 也要先設定

Returns:

boolean

Throws:

java.lang.Exception

create

public boolean create(javax.servlet.http.HttpServletResponse response,
             java.lang.String outputfilename)
               throws java.lang.Exception

產生 output To Web

Parameters:

response -

outputfilename -

Returns:

Throws:

java.lang.Exception

create

public boolean create(java.io.InputStream inis,
             javax.servlet.http.HttpServletResponse response,
             java.lang.String outputfilename)
               throws java.lang.Exception

create xls 直接將InputStream 送入

Parameters:

inis -

response -

outputfilename -

Returns:

Throws:

java.lang.Exception

getWorkBook

public jxl.write.WritableWorkbook getWorkBook()

取目前工作的workbook

Returns:

createSheet

public void createSheet(java.lang.String sheetname,
               int sheetnum)

getSheet

public jxl.write.WritableSheet getSheet(java.lang.String sheetname)

getSheet

public jxl.write.WritableSheet getSheet()

取sheet name

Returns:

add

public void add(java.lang.Object[] inObjectCell)

add

public void add(int row,
       java.lang.String as_string)
         throws java.lang.Exception

加入XLS 以Row 為基準

Parameters:

row - int

as_string - String

Throws:

java.lang.Exception

add

public void add(int row,
       java.lang.String as_string,
       jxl.write.WritableCellFormat inCellFormat)

加入XLS 以ROW 為基準, 若一整個Row 都是同一個CellFormat 可自定

Parameters:

row -

as_string -

inCellFormat -

copytemplmenetCellRowToOutputCellRow

public void copytemplmenetCellRowToOutputCellRow(int fromCell,
                                        int rowend,
                                        int toCell)

settemplementCellRowToOutputCellRow

public void settemplementCellRowToOutputCellRow(java.lang.String inSheetName,
                                       int startCellColumn,
                                       int rowend,
                                       java.util.Hashtable incellrows)
                                         throws jxl.write.biff.RowsExceededException,
                                                jxl.write.WriteException

set 單一CellRow

Parameters:

startCellColumn - 取templement CellColumn

rowend - copy templement 的row 位置至rowend 為止

incellrows - 準備set到各row

Throws:

jxl.write.WriteException

jxl.write.biff.RowsExceededException

transRealDataToSheet

public void transRealDataToSheet(BaseTable indatas)

轉換 worktablesheet 資料 單一狀態, 欄位對欄位轉換

Parameters:

indatas -

transRealDataToSheet

public void transRealDataToSheet(clsSqlData vfld)

transMutiRowsToSheet

public void transMutiRowsToSheet(BaseTable indatas)

轉換mutirow, 可先定義

Parameters:

insheet -

indatas -

putall

public void putall(java.util.Hashtable inalldata)

saveToxls

public void saveToxls()
               throws java.lang.Exception

執行完畢後,儲存至實際檔案中

Throws:

java.lang.Exception

closeTempletefile

public void closeTempletefile()

close templet file 開啟的動作

nullToSpace

public static java.lang.String nullToSpace(java.lang.String str)

copyToSheet

public void copyToSheet(int i,
               java.lang.String insheetName,
               java.lang.String tempSheetName)

Parameters:

i - 要建置新的 sheet array

insheetName - new sheet name

tempSheetName - template sheet name

removeSheet

public void removeSheet(java.lang.String insheetName)

刪除 sheet Name remove sheet

Parameters:

insheetName -