pexa.ext.tool.jude

クラス ReadExcelForTool

java.lang.Object

pexa.ext.tool.jude.ReadExcelForTool

public class ReadExcelForTool
extends java.lang.Object

コンストラクタのサマリー

コンストラクタ

コンストラクタと説明
ReadExcelForTool()

メソッドのサマリー

修飾子とタイプ	メソッドと説明
static java.io.InputStream	getByteArry(java.io.File path)
static java.lang.String	getCell(java.lang.String[] cols, java.lang.String colName)
static int	getColNumber(java.lang.String colName)
static java.util.Map	getStereotype(java.lang.String cfile) Read Stereo Type information.
void	makeHTML(java.util.Map mmap, java.io.File md)
static java.util.Map	readExcel(java.io.File excelPath) Read Business Catalog to Excel file
static java.util.Map	readMappingExcel(java.lang.String path)
static java.util.Map	readMappingSetExcel(java.lang.String path)
static java.util.Map	readModelText(java.lang.String fname)
static java.lang.String	writeExcel(java.io.File base, java.lang.String fname, java.util.List sheets) Create Write Excel file base Excel file write base directory fname Excel file name (SVOStatementTask.xls) sheets Sheet info sheet name columnInfo[] List datas String[]

クラスから継承されたメソッド java.lang.Object

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

コンストラクタの詳細

ReadExcelForTool

public ReadExcelForTool()

メソッドの詳細

readMappingExcel

public static java.util.Map readMappingExcel(java.lang.String path)
                                      throws jxl.read.biff.BiffException,
                                             java.io.IOException

例外:

jxl.read.biff.BiffException

java.io.IOException

readMappingSetExcel

public static java.util.Map readMappingSetExcel(java.lang.String path)
                                         throws jxl.read.biff.BiffException,
                                                java.io.IOException

例外:

jxl.read.biff.BiffException

java.io.IOException

readModelText

public static java.util.Map readModelText(java.lang.String fname)
                                   throws java.io.IOException

例外:

java.io.IOException

makeHTML

public void makeHTML(java.util.Map mmap,
                     java.io.File md)
              throws java.io.IOException

例外:

java.io.IOException

getStereotype

public static java.util.Map getStereotype(java.lang.String cfile)
                                   throws java.io.IOException

Read Stereo Type information.

例外:

java.io.IOException

readExcel

public static java.util.Map readExcel(java.io.File excelPath)

Read Business Catalog to Excel file

例外:

java.io.IOException

getByteArry

public static java.io.InputStream getByteArry(java.io.File path)

getCell

public static java.lang.String getCell(java.lang.String[] cols,
                                       java.lang.String colName)

getColNumber

public static int getColNumber(java.lang.String colName)

writeExcel

public static java.lang.String writeExcel(java.io.File base,
                                          java.lang.String fname,
                                          java.util.List sheets)

Create Write Excel file base Excel file write base directory fname Excel file name (SVOStatementTask.xls) sheets Sheet info sheet name columnInfo[] List datas String[]

例外:

java.io.IOException

jxl.write.WriteException

jxl.write.biff.RowsExceededException