![]() |
||
Home Products Purchase Downloads Demos Forums Blogs Ticket Wiki API Corporate |
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.aspose.cells.LightCells
public abstract class LightCells
Cells processor for processing spreadsheet files in Event-Driven mode.
Method Summary | |
---|---|
static LightCells |
getInstance(java.io.InputStream stream)
Get one LightCells to process given Excel data stream, using default settings. |
static LightCells |
getInstance(java.io.InputStream stream,
int fileFormatType)
Get one LightCells to process given Excel data stream, using default settings. |
static LightCells |
getInstance(java.io.InputStream stream,
int fileFormatType,
int settingFlags)
Deprecated. replaced by getInstance(InputStream, int, LightCellsSettings) |
static LightCells |
getInstance(java.io.InputStream stream,
int fileFormatType,
LightCellsSettings settings)
Get one LightCells to process given Excel data stream, using given settings. |
static LightCells |
getInstance(java.io.InputStream stream,
LightCellsSettings settings)
Get one LightCells to process given Excel data stream, using default settings. |
static LightCells |
getInstance(java.lang.String file)
Get one LightCells to process given template file, using default settings. |
static LightCells |
getInstance(java.lang.String file,
int fileFormatType)
Get one LightCells to process given template file, using default settings. |
static LightCells |
getInstance(java.lang.String file,
int fileFormatType,
int settingFlags)
Deprecated. replaced by getInstance(String, int, LightCellsSettings) |
static LightCells |
getInstance(java.lang.String file,
int fileFormatType,
LightCellsSettings settings)
Get one LightCells to process given template file, using given settings. |
static LightCells |
getInstance(java.lang.String file,
LightCellsSettings settings)
Get one LightCells to process given template file, using default settings. |
abstract LightCellsSettings |
getSettings()
get settings to check or modify advanced cell-process features. |
int |
getSheetCount()
get total count of sheet in a workbook |
java.lang.String |
getSheetName(int sheetIndex)
get name of sheet at given index |
void |
processWorkbook(CellHandler cellHandler)
process whole workbook, in order sheet by sheet, row by row and then cell by cell |
abstract void |
processWorksheet(int sheetIndex,
CellHandler cellHandler)
process one worksheet. |
void |
processWorksheet(java.lang.String sheetName,
CellHandler cellHandler)
process one worksheet. |
void |
release()
release resource(such as file handler, opened InputStream, and so on) hold by this handler. |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Method Detail |
---|
public static LightCells getInstance(java.lang.String file) throws java.io.IOException
file
- template file to process
java.io.IOException
public static LightCells getInstance(java.lang.String file, LightCellsSettings settings) throws java.io.IOException
file
- template file to process
java.io.IOException
public static LightCells getInstance(java.io.InputStream stream) throws java.io.IOException
stream
- data stream to get Excel data from
java.io.IOException
public static LightCells getInstance(java.io.InputStream stream, LightCellsSettings settings) throws java.io.IOException
stream
- data stream to get Excel data from
java.io.IOException
public static LightCells getInstance(java.lang.String file, int fileFormatType) throws java.io.IOException
file
- template file to processfileFormatType
- file format type of given template. see FileFormatType
java.io.IOException
public static LightCells getInstance(java.lang.String file, int fileFormatType, int settingFlags) throws java.io.IOException
getInstance(String, int, LightCellsSettings)
file
- template file to processfileFormatType
- file format type of given template. see FileFormatType
settingFlags
- settings flags for initializing LightCells, such as whether load data for fetching cell's formula text.
For available flags please refer to constants with header INIT_ defined in LightCellsSettings
.
The flag may be combined with any of other flags using the OR operator.
java.io.IOException
public static LightCells getInstance(java.lang.String file, int fileFormatType, LightCellsSettings settings) throws java.io.IOException
file
- template file to processfileFormatType
- file format type of given template. see FileFormatType
settings
- settings for initializing LightCells, such as whether load data for fetching cell's formula text.
java.io.IOException
public static LightCells getInstance(java.io.InputStream stream, int fileFormatType) throws java.io.IOException
stream
- data stream to get Excel data fromfileFormatType
- file format type of given template. see FileFormatType
java.io.IOException
public static LightCells getInstance(java.io.InputStream stream, int fileFormatType, int settingFlags) throws java.io.IOException
getInstance(InputStream, int, LightCellsSettings)
stream
- data stream to get Excel data fromfileFormatType
- file format type of given template. see FileFormatType
settingFlags
- settings flags for initializing LightCells, such as whether load data for fetching cell's formula text.
For available flags please refer to constants with header INIT_ defined in LightCellsSettings
.
The flag may be combined with any of other flags using the OR operator.
java.io.IOException
public static LightCells getInstance(java.io.InputStream stream, int fileFormatType, LightCellsSettings settings) throws java.io.IOException
stream
- data stream to get Excel data fromfileFormatType
- file format type of given template. see FileFormatType
settings
- settings for initializing LightCells, such as whether load data for fetching cell's formula text.
java.io.IOException
public int getSheetCount()
public java.lang.String getSheetName(int sheetIndex)
sheetIndex
- index of sheet
java.lang.IllegalArgumentException
- when no sheet at given indexpublic void processWorkbook(CellHandler cellHandler) throws java.lang.Exception
cellHandler
- handler to process cell
java.lang.Exception
public void processWorksheet(java.lang.String sheetName, CellHandler cellHandler) throws java.lang.Exception
sheetName
- the name of the worksheet to be processed.cellHandler
- handler to process cell
java.lang.Exception
public void release() throws java.lang.Exception
java.lang.Exception
public abstract void processWorksheet(int sheetIndex, CellHandler cellHandler) throws java.lang.Exception
sheetIndex
- the index of worksheet to be processed. base 0.cellHandler
- handler to process cell
java.lang.Exception
public abstract LightCellsSettings getSettings()
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |