public class WorkSheet
extends java.lang.Object
Constructor | Description |
---|---|
WorkSheet() |
|
WorkSheet(java.lang.String[][] values) |
|
WorkSheet(java.util.Collection<java.lang.String> rows,
java.util.Collection<java.lang.String> columns) |
|
WorkSheet(CompactCharSequence[][] values) |
Modifier and Type | Method | Description |
---|---|---|
void |
addCell(java.lang.String row,
java.lang.String col,
java.lang.String value) |
Add data to a cell
|
void |
addColumn(java.lang.String column,
java.lang.String defaultValue) |
|
void |
addColumns(java.util.ArrayList<java.lang.String> columns,
java.lang.String defaultValue) |
Add columns to worksheet and set default value
|
void |
addRow(java.lang.String row,
java.lang.String defaultValue) |
|
void |
addRows(java.util.ArrayList<java.lang.String> rows,
java.lang.String defaultValue) |
Add rows to the worksheet and fill in default value
|
void |
appendWorkSheetColumns(WorkSheet worksheet) |
Add columns from a second worksheet to be joined by common row.
|
void |
appendWorkSheetRows(WorkSheet worksheet) |
Add rows from a second worksheet to be joined by common column.
|
void |
applyColumnFilter(java.lang.String column,
ChangeValue changeValue) |
Apply filter to a column to change values from say numberic to nominal
based on some range
|
void |
changeColumnHeader(java.lang.String col,
java.lang.String newCol) |
|
void |
changeColumnHeader(ChangeValue changeValue) |
|
void |
changeColumnsHeaders(java.util.LinkedHashMap<java.lang.String,java.lang.String> newColumnValues) |
Change the columns in the HashMap Key to the name of the value
|
void |
changeRowHeader(java.lang.String row,
java.lang.String newRow) |
|
void |
changeRowHeader(ChangeValue changeValue) |
|
void |
clear() |
See if we can free up memory
|
java.util.ArrayList<java.lang.String> |
getAllColumns() |
Get the list of column names including those that may be hidden
|
java.util.ArrayList<java.lang.String> |
getAllRows() |
Get all rows including those that may be hidden
|
java.lang.String |
getCell(java.lang.String row,
java.lang.String col) |
Get cell value
|
java.lang.Double |
getCellDouble(java.lang.String row,
java.lang.String col) |
|
java.lang.Integer |
getColumnIndex(java.lang.String column) |
|
java.util.LinkedHashMap<java.lang.String,HeaderInfo> |
getColumnLookup() |
|
java.util.ArrayList<java.lang.String> |
getColumns() |
Get the list of column names.
|
static WorkSheet |
getCopyWorkSheet(WorkSheet copyWorkSheet) |
Create a copy of a worksheet.
|
static WorkSheet |
getCopyWorkSheetSelectedRows(WorkSheet copyWorkSheet,
java.util.ArrayList<java.lang.String> rows) |
Create a copy of a worksheet.
|
java.util.ArrayList<java.lang.String> |
getDataColumns() |
|
java.util.ArrayList<java.lang.String> |
getDataRows() |
Get the list of row names
|
java.util.ArrayList<java.lang.String> |
getDiscreteColumnValues(java.lang.String column) |
Get back a list of unique values in the column
|
java.util.ArrayList<java.lang.String> |
getDiscreteRowValues(java.lang.String row) |
Get back a list of unique values in the row
|
java.lang.String |
getIndexColumnName() |
|
WorkSheet |
getLogScale(double base) |
Get the log scale of this worksheet where a zero value will be set to .1
as Log(0) is undefined
|
WorkSheet |
getLogScale(double base,
double zeroValue) |
Get the log scale of this worksheet
|
java.util.ArrayList<java.lang.String> |
getMetaDataColumns() |
|
java.util.LinkedHashMap<java.lang.String,java.lang.String> |
getMetaDataColumnsHashMap() |
|
java.util.ArrayList<java.lang.String> |
getMetaDataRows() |
|
java.util.LinkedHashMap<java.lang.String,java.lang.String> |
getMetaDataRowsHashMap() |
|
java.util.ArrayList<java.lang.String> |
getRandomDataColumns(int number) |
|
java.util.ArrayList<java.lang.String> |
getRandomDataColumns(int number,
java.util.ArrayList<java.lang.String> columns) |
|
java.lang.String |
getRowHeader() |
|
java.lang.Integer |
getRowIndex(java.lang.String row) |
|
java.util.LinkedHashMap<java.lang.String,HeaderInfo> |
getRowLookup() |
|
java.util.ArrayList<java.lang.String> |
getRows() |
Get the list of row names.
|
void |
hideColumn(java.lang.String column,
boolean hide) |
|
void |
hideEmptyColumns() |
|
void |
hideEmptyRows() |
|
void |
hideMetaDataColumns(boolean value) |
|
void |
hideMetaDataRows(boolean value) |
|
void |
hideRow(java.lang.String row,
boolean hide) |
|
boolean |
isMetaDataColumn(java.lang.String column) |
|
boolean |
isMetaDataRow(java.lang.String row) |
|
boolean |
isValidColumn(java.lang.String col) |
|
boolean |
isValidRow(java.lang.String row) |
|
void |
markMetaDataColumn(java.lang.String column) |
|
void |
markMetaDataColumns(java.util.ArrayList<java.lang.String> metaDataColumns) |
marks columns as containing meta data
|
void |
markMetaDataRow(java.lang.String row) |
|
void |
randomlyDivideSave(double percentage,
java.lang.String fileName1,
java.lang.String fileName2) |
Split a worksheet randomly.
|
static WorkSheet |
readCSV(java.io.File f,
char delimiter) |
|
static WorkSheet |
readCSV(java.io.InputStream is,
char delimiter) |
Read a CSV/Tab delimited file where you pass in the delimiter
|
static WorkSheet |
readCSV(java.lang.String fileName,
char delimiter) |
Read a CSV/Tab delimitted file where you pass in the delimiter
|
void |
replaceColumnValues(java.lang.String column,
java.util.HashMap<java.lang.String,java.lang.String> values) |
Change values in a column where 0 = something and 1 = something different
|
void |
save(java.io.OutputStream outputStream,
char delimitter,
boolean quoteit) |
|
void |
saveCSV(java.lang.String fileName) |
Save the worksheet as a csv file
|
void |
saveTXT(java.lang.String fileName) |
|
void |
setCacheDoubleValues(boolean value) |
|
void |
setIndexColumnName(java.lang.String indexColumnName) |
|
void |
setMetaDataColumns(java.util.ArrayList<java.lang.String> metaDataColumns) |
Clears existing meta data columns and sets new ones
|
void |
setMetaDataColumnsAfterColumn() |
|
void |
setMetaDataColumnsAfterColumn(java.lang.String column) |
|
void |
setMetaDataRows(java.util.ArrayList<java.lang.String> metaDataRows) |
|
void |
setMetaDataRowsAfterRow() |
|
void |
setMetaDataRowsAfterRow(java.lang.String row) |
|
void |
setRowHeader(java.lang.String value) |
|
void |
shuffleColumnsAndThenRows(java.util.ArrayList<java.lang.String> columns,
java.util.ArrayList<java.lang.String> rows) |
Randomly shuffle the columns and rows.
|
void |
shuffleColumnValues(java.util.ArrayList<java.lang.String> columns) |
Need to shuffle column values to allow for randomized testing.
|
void |
shuffleRowValues(java.util.ArrayList<java.lang.String> rows) |
Need to shuffle rows values to allow for randomized testing.
|
WorkSheet |
swapRowAndColumns() |
Swap the row and columns returning a new worksheet
|
java.lang.String |
toString() |
|
static WorkSheet |
unionWorkSheetsRowJoin(java.lang.String w1FileName,
java.lang.String w2FileName,
char delimitter,
boolean secondSheetMetaData) |
Combine two work sheets where you join based on rows.
|
static WorkSheet |
unionWorkSheetsRowJoin(WorkSheet w1,
WorkSheet w2,
boolean secondSheetMetaData) |
* Combine two work sheets where you join based on rows.
|
public WorkSheet()
public WorkSheet(java.util.Collection<java.lang.String> rows, java.util.Collection<java.lang.String> columns) throws java.lang.Exception
rows
- columns
- java.lang.Exception
public WorkSheet(java.lang.String[][] values)
values
- public WorkSheet(CompactCharSequence[][] values)
values
- public void clear()
public java.lang.String toString()
toString
in class java.lang.Object
public void randomlyDivideSave(double percentage, java.lang.String fileName1, java.lang.String fileName2) throws java.lang.Exception
percentage
- fileName1
- fileName2
- java.lang.Exception
public static WorkSheet getCopyWorkSheetSelectedRows(WorkSheet copyWorkSheet, java.util.ArrayList<java.lang.String> rows) throws java.lang.Exception
copyWorkSheet
- rows
- java.lang.Exception
public static WorkSheet getCopyWorkSheet(WorkSheet copyWorkSheet) throws java.lang.Exception
copyWorkSheet
- java.lang.Exception
public java.util.ArrayList<java.lang.String> getMetaDataColumns()
public java.util.ArrayList<java.lang.String> getMetaDataRows()
public java.util.ArrayList<java.lang.String> getDataColumns()
public void shuffleColumnsAndThenRows(java.util.ArrayList<java.lang.String> columns, java.util.ArrayList<java.lang.String> rows) throws java.lang.Exception
columns
- rows
- java.lang.Exception
public void shuffleColumnValues(java.util.ArrayList<java.lang.String> columns) throws java.lang.Exception
columns
- java.lang.Exception
public void shuffleRowValues(java.util.ArrayList<java.lang.String> rows) throws java.lang.Exception
rows
- java.lang.Exception
public void hideMetaDataColumns(boolean value)
value
- public void hideMetaDataRows(boolean value)
value
- public void setMetaDataRowsAfterRow()
public void setMetaDataColumnsAfterColumn()
public void setMetaDataRowsAfterRow(java.lang.String row)
row
- public void setMetaDataColumnsAfterColumn(java.lang.String column)
column
- public void setMetaDataColumns(java.util.ArrayList<java.lang.String> metaDataColumns)
metaDataColumns
- public void markMetaDataColumns(java.util.ArrayList<java.lang.String> metaDataColumns)
metaDataColumns
- public void markMetaDataColumn(java.lang.String column)
column
- public boolean isMetaDataColumn(java.lang.String column)
column
- public boolean isMetaDataRow(java.lang.String row)
row
- public void markMetaDataRow(java.lang.String row)
row
- public void setMetaDataRows(java.util.ArrayList<java.lang.String> metaDataRows)
metaDataRows
- public void hideEmptyRows() throws java.lang.Exception
java.lang.Exception
public void hideEmptyColumns() throws java.lang.Exception
java.lang.Exception
public void hideRow(java.lang.String row, boolean hide)
row
- hide
- public void hideColumn(java.lang.String column, boolean hide)
column
- hide
- public void replaceColumnValues(java.lang.String column, java.util.HashMap<java.lang.String,java.lang.String> values) throws java.lang.Exception
column
- values
- java.lang.Exception
public void applyColumnFilter(java.lang.String column, ChangeValue changeValue) throws java.lang.Exception
column
- changeValue
- java.lang.Exception
public void addColumn(java.lang.String column, java.lang.String defaultValue)
column
- defaultValue
- public void addColumns(java.util.ArrayList<java.lang.String> columns, java.lang.String defaultValue)
columns
- defaultValue
- public void addRow(java.lang.String row, java.lang.String defaultValue)
row
- defaultValue
- public void addRows(java.util.ArrayList<java.lang.String> rows, java.lang.String defaultValue)
rows
- defaultValue
- public void addCell(java.lang.String row, java.lang.String col, java.lang.String value) throws java.lang.Exception
row
- col
- value
- java.lang.Exception
public boolean isValidRow(java.lang.String row)
row
- public boolean isValidColumn(java.lang.String col)
col
- public void setCacheDoubleValues(boolean value)
value
- public java.lang.Double getCellDouble(java.lang.String row, java.lang.String col) throws java.lang.Exception
row
- col
- java.lang.Exception
public java.lang.String getCell(java.lang.String row, java.lang.String col) throws java.lang.Exception
row
- col
- java.lang.Exception
public void changeRowHeader(ChangeValue changeValue)
changeValue
- public void changeColumnHeader(ChangeValue changeValue)
changeValue
- public void changeRowHeader(java.lang.String row, java.lang.String newRow) throws java.lang.Exception
row
- newRow
- java.lang.Exception
public void changeColumnsHeaders(java.util.LinkedHashMap<java.lang.String,java.lang.String> newColumnValues) throws java.lang.Exception
newColumnValues
- java.lang.Exception
public void changeColumnHeader(java.lang.String col, java.lang.String newCol) throws java.lang.Exception
col
- newCol
- java.lang.Exception
public java.lang.Integer getColumnIndex(java.lang.String column) throws java.lang.Exception
column
- java.lang.Exception
public java.lang.Integer getRowIndex(java.lang.String row) throws java.lang.Exception
row
- java.lang.Exception
public java.util.ArrayList<java.lang.String> getRandomDataColumns(int number)
number
- public java.util.ArrayList<java.lang.String> getRandomDataColumns(int number, java.util.ArrayList<java.lang.String> columns)
number
- columns
- public java.util.ArrayList<java.lang.String> getAllColumns()
public java.util.ArrayList<java.lang.String> getColumns()
public java.util.ArrayList<java.lang.String> getDiscreteColumnValues(java.lang.String column) throws java.lang.Exception
column
- java.lang.Exception
public java.util.ArrayList<java.lang.String> getDiscreteRowValues(java.lang.String row) throws java.lang.Exception
row
- java.lang.Exception
public java.util.ArrayList<java.lang.String> getAllRows()
public java.util.ArrayList<java.lang.String> getRows()
public java.util.ArrayList<java.lang.String> getDataRows()
public WorkSheet getLogScale(double base) throws java.lang.Exception
base
- java.lang.Exception
public WorkSheet getLogScale(double base, double zeroValue) throws java.lang.Exception
base
- java.lang.Exception
public WorkSheet swapRowAndColumns() throws java.lang.Exception
java.lang.Exception
public static WorkSheet unionWorkSheetsRowJoin(java.lang.String w1FileName, java.lang.String w2FileName, char delimitter, boolean secondSheetMetaData) throws java.lang.Exception
w1FileName
- w2FileName
- delimitter
- secondSheetMetaData
- java.lang.Exception
public static WorkSheet unionWorkSheetsRowJoin(WorkSheet w1, WorkSheet w2, boolean secondSheetMetaData) throws java.lang.Exception
w1
- w2
- secondSheetMetaData
- java.lang.Exception
public static WorkSheet readCSV(java.lang.String fileName, char delimiter) throws java.lang.Exception
fileName
- delimiter
- java.lang.Exception
public static WorkSheet readCSV(java.io.File f, char delimiter) throws java.lang.Exception
java.lang.Exception
public static WorkSheet readCSV(java.io.InputStream is, char delimiter) throws java.lang.Exception
f
- delimiter
- java.lang.Exception
public void saveCSV(java.lang.String fileName) throws java.lang.Exception
fileName
- java.lang.Exception
public void saveTXT(java.lang.String fileName) throws java.lang.Exception
fileName
- java.lang.Exception
public void setRowHeader(java.lang.String value)
value
- public void appendWorkSheetColumns(WorkSheet worksheet) throws java.lang.Exception
worksheet
- java.lang.Exception
public void appendWorkSheetRows(WorkSheet worksheet) throws java.lang.Exception
worksheet
- java.lang.Exception
public void save(java.io.OutputStream outputStream, char delimitter, boolean quoteit) throws java.lang.Exception
outputStream
- delimitter
- quoteit
- java.lang.Exception
public java.lang.String getIndexColumnName()
public void setIndexColumnName(java.lang.String indexColumnName)
indexColumnName
- the indexColumnName to setpublic java.util.LinkedHashMap<java.lang.String,HeaderInfo> getColumnLookup()
public java.util.LinkedHashMap<java.lang.String,HeaderInfo> getRowLookup()
public java.util.LinkedHashMap<java.lang.String,java.lang.String> getMetaDataColumnsHashMap()
public java.util.LinkedHashMap<java.lang.String,java.lang.String> getMetaDataRowsHashMap()
public java.lang.String getRowHeader()