|
OpenAPI 1.0 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface AQExcelSpreadsheet
This interface represents an in-memory Excel spreadhseet.
Method Summary | |
---|---|
void |
addWorksheet(String name)
Adds a sheet with the given name. |
void |
clear()
Clears the spreadsheet. |
int |
getColumn()
Returns the current column (0-based). |
String |
getCurrentWorksheet()
Returns the current worksheet name. |
int |
getRow()
Returns the current row (0-based). |
String[] |
getWorksheetNames()
Returns worksheet names in an array. |
void |
insert(AQDataReader reader,
boolean firstLineContainsColumnNames)
Inserts the data read from the specified reader into the current worksheet, starting with the current row and column. |
void |
insert(AQDataRow dataRow)
Inserts the row of values into the current worksheet, starting with the current row and column. |
void |
insert(AQDataSet dataSet,
boolean firstLineContainsColumnNames)
Inserts the data set into the current worksheet, starting with the current row and column. |
void |
insertPivotTable(AQPivotDataSet pivotDataSet)
Creates a new worksheet with the pivot data set inserted. |
void |
nextRow()
Advances current row by one. |
void |
removeWorksheet(int index)
Removes a worksheet at the specified index. |
void |
save()
Saves the spreadsheet. |
void |
save(String filename)
Saves the spreadsheet to a new file. |
void |
setAutoResize(boolean enable)
When enabled, the cell widths will be resized to fit the contents on the next save() operation. |
void |
setCell(int row,
int column,
Object value)
Sets the cell value at the specified row and column in the current worksheet. |
void |
setCell(Object value)
Sets the cell value at the current row and column in the current worksheet. |
void |
setColumn(int column)
Sets the current column (0-based). |
void |
setCurrentWorksheet(String name)
Sets the current worksheet. |
void |
setRow(int row)
Sets the current row (0-based). |
void |
setWorksheetName(int index,
String name)
Sets worksheet name. |
Method Detail |
---|
void setCell(int row, int column, Object value)
row
- column
- value
- void setCell(Object value)
value
- void setCurrentWorksheet(String name)
name
- String getCurrentWorksheet()
void setRow(int row)
row
- int getRow()
void nextRow()
void setColumn(int column)
column
- int getColumn()
void insertPivotTable(AQPivotDataSet pivotDataSet) throws Exception
pivotDataSet
-
Exception
void insert(AQDataSet dataSet, boolean firstLineContainsColumnNames) throws Exception
dataSet
- firstLineContainsColumnNames
- When true, the first inserted line will contain column names, if defined.
Exception
void insert(AQDataReader reader, boolean firstLineContainsColumnNames) throws Exception
reader
- firstLineContainsColumnNames
- When true, the first inserted line will contain column names, if defined.
Exception
void insert(AQDataRow dataRow)
dataRow
- void clear()
void setAutoResize(boolean enable)
void save() throws Exception
Exception
void save(String filename) throws Exception
filename
-
Exception
String[] getWorksheetNames()
void setWorksheetName(int index, String name)
index
- Worksheet index, 0-based.name
- Worksheet name.void addWorksheet(String name)
name
- Worksheet name.setCurrentWorksheet(String)
void removeWorksheet(int index)
index
- Worksheet index.
|
OpenAPI 1.0 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |