com.landawn.abacus.util

Class Sheet<R,C,E>

java.lang.Object

com.landawn.abacus.util.Sheet<R,C,E>

public final class Sheet<R,C,E>
extends java.lang.Object

Since:

0.8

Author:

Haiyang Li

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static interface	Sheet.Cell<R,C,E>

Constructor Summary

Constructors

Constructor and Description
Sheet(java.util.Collection<R> rowKeySet, java.util.Collection<C> columnKeySet)
Sheet(java.util.Collection<R> rowKeySet, java.util.Collection<C> columnKeySet, java.lang.Object[][] rows)

Method Summary

Modifier and Type	Method and Description
void	addColumn(C columnKey, java.util.Collection<? extends E> column)
void	addColumn(int columnIndex, C columnKey, java.util.Collection<? extends E> column)
void	addRow(int rowIndex, R rowKey, java.util.Collection<? extends E> row)
void	addRow(R rowKey, java.util.Collection<? extends E> row)
Stream<Stream<Sheet.Cell<R,C,E>>>	cellsC()
Stream<Stream<Sheet.Cell<R,C,E>>>	cellsC(int fromColumnIndex, int toColumnIndex)
Stream<Sheet.Cell<R,C,E>>	cellsH()
Stream<Sheet.Cell<R,C,E>>	cellsH(int rowIndex)
Stream<Sheet.Cell<R,C,E>>	cellsH(int fromRowIndex, int toRowIndex)
Stream<Stream<Sheet.Cell<R,C,E>>>	cellsR()
Stream<Stream<Sheet.Cell<R,C,E>>>	cellsR(int fromRowIndex, int toRowIndex)
Stream<Sheet.Cell<R,C,E>>	cellsV()
Stream<Sheet.Cell<R,C,E>>	cellsV(int columnIndex)
Stream<Sheet.Cell<R,C,E>>	cellsV(int fromColumnIndex, int toColumnIndex)
void	clear()
Sheet<R,C,E>	clone() Deeply copy each element in this Sheet by Serialization/Deserialization.
Sheet<R,C,E>	clone(boolean freeze) Deeply copy each element in this Sheet by Serialization/Deserialization.
java.util.Map<R,E>	column(java.lang.Object columnKey)
java.util.Set<C>	columnKeySet()
int	columnLength() Returns the size of column key set.
java.util.Map<C,java.util.Map<R,E>>	columnMap()
static <R,C,E> Sheet<R,C,E>	columns(java.util.Collection<R> rowKeySet, java.util.Collection<C> columnKeySet, java.util.Collection<? extends java.util.Collection<? extends E>> columns)
static <R,C,E> Sheet<R,C,E>	columns(java.util.Collection<R> rowKeySet, java.util.Collection<C> columnKeySet, java.lang.Object[][] columns)
boolean	contains(java.lang.Object rowKey, java.lang.Object columnKey)
boolean	containsColumn(java.lang.Object columnKey)
boolean	containsRow(java.lang.Object rowKey)
boolean	containsValue(java.lang.Object value)
Sheet<R,C,E>	copy()
Sheet<R,C,E>	copy(java.util.Collection<R> rowKeySet, java.util.Collection<C> columnKeySet)
boolean	equals(java.lang.Object obj)
void	freeze()
boolean	frozen()
E	get(int rowIndex, int columnIndex)
E	get(java.lang.Object rowKey, java.lang.Object columnKey)
E	get(Pair.IntPair point)
java.util.List<E>	getColumn(java.lang.Object columnKey)
java.util.List<E>	getRow(java.lang.Object rowKey)
int	hashCode()
Sheet<R,C,E>	merge(Sheet<? extends R,? extends C,? extends E> source, BiFunction<? super E,? super E,E> mergeFunction)
void	moveColumn(java.lang.Object columnKey, int newColumnIndex) Move the specified column to the new position.
void	moveRow(java.lang.Object rowKey, int newRowIndex) Move the specified row to the new position.
Stream<Stream<Pair.IntPair>>	pointsC()
Stream<Stream<Pair.IntPair>>	pointsC(int fromColumnIndex, int toColumnIndex)
Stream<Pair.IntPair>	pointsH()
Stream<Pair.IntPair>	pointsH(int rowIndex)
Stream<Pair.IntPair>	pointsH(int fromRowIndex, int toRowIndex)
Stream<Stream<Pair.IntPair>>	pointsR()
Stream<Stream<Pair.IntPair>>	pointsR(int fromRowIndex, int toRowIndex)
Stream<Pair.IntPair>	pointsV()
Stream<Pair.IntPair>	pointsV(int columnIndex)
Stream<Pair.IntPair>	pointsV(int fromColumnIndex, int toColumnIndex)
void	println()
E	put(int rowIndex, int columnIndex, E value)
E	put(Pair.IntPair point, E value)
E	put(R rowKey, C columnKey, E value)
void	putAll(Sheet<? extends R,? extends C,? extends E> source)
E	remove(int rowIndex, int columnIndex)
E	remove(java.lang.Object rowKey, java.lang.Object columnKey)
E	remove(Pair.IntPair point)
void	removeColumn(java.lang.Object columnKey)
void	removeRow(java.lang.Object rowKey)
void	renameColumn(C columnKey, C newColumnKey)
void	renameRow(R rowKey, R newRowKey)
void	replaceIf(IntBiPredicate predicate, E newValue) Replace elements by Predicate.test(i, j) based on points
void	replaceIf(Predicate<? super E> predicate, E newValue)
java.util.Map<C,E>	row(java.lang.Object rowKey)
java.util.Set<R>	rowKeySet()
int	rowLength() Returns the size of row key set.
java.util.Map<R,java.util.Map<C,E>>	rowMap()
static <R,C,E> Sheet<R,C,E>	rows(java.util.Collection<R> rowKeySet, java.util.Collection<C> columnKeySet, java.util.Collection<? extends java.util.Collection<? extends E>> rows)
static <R,C,E> Sheet<R,C,E>	rows(java.util.Collection<R> rowKeySet, java.util.Collection<C> columnKeySet, java.lang.Object[][] rows)
void	setColumn(C columnKey, java.util.Collection<? extends E> column)
void	setRow(R rowKey, java.util.Collection<? extends E> row)
Stream<Stream<E>>	streamC()
Stream<Stream<E>>	streamC(int fromColumnIndex, int toColumnIndex)
Stream<E>	streamH()
Stream<E>	streamH(int rowIndex)
Stream<E>	streamH(int fromRowIndex, int toRowIndex)
Stream<Stream<E>>	streamR()
Stream<Stream<E>>	streamR(int fromRowIndex, int toRowIndex)
Stream<E>	streamV()
Stream<E>	streamV(int columnIndex)
Stream<E>	streamV(int fromColumnIndex, int toColumnIndex)
void	swapColumn(java.lang.Object columnKeyA, java.lang.Object columnKeyB) Swap the positions of the two specified columns.
void	swapRow(java.lang.Object rowKeyA, java.lang.Object rowKeyB) Swap the positions of the two specified rows.
java.lang.Object[][]	toArrayH()
<T> T[][]	toArrayH(java.lang.Class<T> cls)
java.lang.Object[][]	toArrayV()
<T> T[][]	toArrayV(java.lang.Class<T> cls)
DataSet	toDataSetH()
DataSet	toDataSetV()
Matrix<E>	toMatrixH(java.lang.Class<E> cls)
Matrix<E>	toMatrixV(java.lang.Class<E> cls)
java.lang.String	toString()
Sheet<C,R,E>	transpose()
void	trimToSize()
void	updateAll(Function<? super E,E> func)
void	updateAll(IntBiFunction<E> func) Update all elements based on points
void	updateColumn(C columnKey, Function<? super E,E> func)
void	updateRow(R rowKey, Function<? super E,E> func)

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, wait, wait, wait

Constructor Detail

Sheet

public Sheet(java.util.Collection<R> rowKeySet,
             java.util.Collection<C> columnKeySet)

Sheet

public Sheet(java.util.Collection<R> rowKeySet,
             java.util.Collection<C> columnKeySet,
             java.lang.Object[][] rows)

Method Detail

rows

public static <R,C,E> Sheet<R,C,E> rows(java.util.Collection<R> rowKeySet,
                                        java.util.Collection<C> columnKeySet,
                                        java.lang.Object[][] rows)

rows

public static <R,C,E> Sheet<R,C,E> rows(java.util.Collection<R> rowKeySet,
                                        java.util.Collection<C> columnKeySet,
                                        java.util.Collection<? extends java.util.Collection<? extends E>> rows)

columns

public static <R,C,E> Sheet<R,C,E> columns(java.util.Collection<R> rowKeySet,
                                           java.util.Collection<C> columnKeySet,
                                           java.lang.Object[][] columns)

columns

public static <R,C,E> Sheet<R,C,E> columns(java.util.Collection<R> rowKeySet,
                                           java.util.Collection<C> columnKeySet,
                                           java.util.Collection<? extends java.util.Collection<? extends E>> columns)

rowKeySet

public java.util.Set<R> rowKeySet()

columnKeySet

public java.util.Set<C> columnKeySet()

get

public E get(java.lang.Object rowKey,
             java.lang.Object columnKey)

get

public E get(int rowIndex,
             int columnIndex)

Parameters:

rowIndex -

columnIndex -

Returns:

get

public E get(Pair.IntPair point)

put

public E put(R rowKey,
             C columnKey,
             E value)

put

public E put(int rowIndex,
             int columnIndex,
             E value)

put

public E put(Pair.IntPair point,
             E value)

putAll

public void putAll(Sheet<? extends R,? extends C,? extends E> source)

remove

public E remove(java.lang.Object rowKey,
                java.lang.Object columnKey)

remove

public E remove(int rowIndex,
                int columnIndex)

remove

public E remove(Pair.IntPair point)

contains

public boolean contains(java.lang.Object rowKey,
                        java.lang.Object columnKey)

containsValue

public boolean containsValue(java.lang.Object value)

getRow

public java.util.List<E> getRow(java.lang.Object rowKey)

setRow

public void setRow(R rowKey,
                   java.util.Collection<? extends E> row)

addRow

public void addRow(R rowKey,
                   java.util.Collection<? extends E> row)

addRow

public void addRow(int rowIndex,
                   R rowKey,
                   java.util.Collection<? extends E> row)

updateRow

public void updateRow(R rowKey,
                      Function<? super E,E> func)

removeRow

public void removeRow(java.lang.Object rowKey)

moveRow

public void moveRow(java.lang.Object rowKey,
                    int newRowIndex)

Move the specified row to the new position.

Parameters:

rowKey -

newRowIndex -

swapRow

public void swapRow(java.lang.Object rowKeyA,
                    java.lang.Object rowKeyB)

Swap the positions of the two specified rows.

Parameters:

rowKeyA -

rowKeyB -

renameRow

public void renameRow(R rowKey,
                      R newRowKey)

containsRow

public boolean containsRow(java.lang.Object rowKey)

row

public java.util.Map<C,E> row(java.lang.Object rowKey)

rowMap

public java.util.Map<R,java.util.Map<C,E>> rowMap()

getColumn

public java.util.List<E> getColumn(java.lang.Object columnKey)

setColumn

public void setColumn(C columnKey,
                      java.util.Collection<? extends E> column)

addColumn

public void addColumn(C columnKey,
                      java.util.Collection<? extends E> column)

addColumn

public void addColumn(int columnIndex,
                      C columnKey,
                      java.util.Collection<? extends E> column)

updateColumn

public void updateColumn(C columnKey,
                         Function<? super E,E> func)

removeColumn

public void removeColumn(java.lang.Object columnKey)

moveColumn

public void moveColumn(java.lang.Object columnKey,
                       int newColumnIndex)

Move the specified column to the new position.

Parameters:

columnKey -

newColumnIndex -

swapColumn

public void swapColumn(java.lang.Object columnKeyA,
                       java.lang.Object columnKeyB)

Swap the positions of the two specified columns.

Parameters:

columnKeyA -

columnKeyB -

renameColumn

public void renameColumn(C columnKey,
                         C newColumnKey)

containsColumn

public boolean containsColumn(java.lang.Object columnKey)

column

public java.util.Map<R,E> column(java.lang.Object columnKey)

columnMap

public java.util.Map<C,java.util.Map<R,E>> columnMap()

rowLength

public int rowLength()

Returns the size of row key set.

Returns:

columnLength

public int columnLength()

Returns the size of column key set.

Returns:

updateAll

public void updateAll(Function<? super E,E> func)

updateAll

public void updateAll(IntBiFunction<E> func)

Update all elements based on points

Parameters:

func -

replaceIf

public void replaceIf(Predicate<? super E> predicate,
                      E newValue)

Parameters:

predicate -

newValue -

replaceIf

public void replaceIf(IntBiPredicate predicate,
                      E newValue)

Replace elements by Predicate.test(i, j) based on points

Parameters:

predicate -

newValue -

copy

public Sheet<R,C,E> copy()

copy

public Sheet<R,C,E> copy(java.util.Collection<R> rowKeySet,
                         java.util.Collection<C> columnKeySet)

clone

public Sheet<R,C,E> clone()

Deeply copy each element in this Sheet by Serialization/Deserialization.

Overrides:

clone in class java.lang.Object

Returns:

clone

public Sheet<R,C,E> clone(boolean freeze)

Deeply copy each element in this Sheet by Serialization/Deserialization.

Returns:

merge

public Sheet<R,C,E> merge(Sheet<? extends R,? extends C,? extends E> source,
                          BiFunction<? super E,? super E,E> mergeFunction)

transpose

public Sheet<C,R,E> transpose()

freeze

public void freeze()

frozen

public boolean frozen()

clear

public void clear()

trimToSize

public void trimToSize()

cellsH

public Stream<Sheet.Cell<R,C,E>> cellsH()

Returns:

a stream of Cells based on the order of row.

cellsH

public Stream<Sheet.Cell<R,C,E>> cellsH(int rowIndex)

cellsH

public Stream<Sheet.Cell<R,C,E>> cellsH(int fromRowIndex,
                                        int toRowIndex)

Parameters:

fromRowIndex -

toRowIndex -

Returns:

a stream of Cells based on the order of row.

cellsV

public Stream<Sheet.Cell<R,C,E>> cellsV()

Returns:

a stream of Cells based on the order of column.

cellsV

public Stream<Sheet.Cell<R,C,E>> cellsV(int columnIndex)

Parameters:

columnIndex -

Returns:

cellsV

public Stream<Sheet.Cell<R,C,E>> cellsV(int fromColumnIndex,
                                        int toColumnIndex)

Parameters:

fromColumnIndex -

toColumnIndex -

Returns:

a stream of Cells based on the order of column.

cellsR

public Stream<Stream<Sheet.Cell<R,C,E>>> cellsR()

Returns:

a stream based on the order of row.

cellsR

public Stream<Stream<Sheet.Cell<R,C,E>>> cellsR(int fromRowIndex,
                                                int toRowIndex)

Parameters:

fromRowIndex -

toRowIndex -

Returns:

a stream based on the order of row.

cellsC

public Stream<Stream<Sheet.Cell<R,C,E>>> cellsC()

Returns:

a stream based on the order of column.

cellsC

public Stream<Stream<Sheet.Cell<R,C,E>>> cellsC(int fromColumnIndex,
                                                int toColumnIndex)

Parameters:

fromColumnIndex -

toColumnIndex -

Returns:

a stream based on the order of column.

pointsH

public Stream<Pair.IntPair> pointsH()

pointsH

public Stream<Pair.IntPair> pointsH(int rowIndex)

pointsH

public Stream<Pair.IntPair> pointsH(int fromRowIndex,
                                    int toRowIndex)

pointsV

public Stream<Pair.IntPair> pointsV()

pointsV

public Stream<Pair.IntPair> pointsV(int columnIndex)

pointsV

public Stream<Pair.IntPair> pointsV(int fromColumnIndex,
                                    int toColumnIndex)

pointsR

public Stream<Stream<Pair.IntPair>> pointsR()

pointsR

public Stream<Stream<Pair.IntPair>> pointsR(int fromRowIndex,
                                            int toRowIndex)

pointsC

public Stream<Stream<Pair.IntPair>> pointsC()

pointsC

public Stream<Stream<Pair.IntPair>> pointsC(int fromColumnIndex,
                                            int toColumnIndex)

streamH

public Stream<E> streamH()

Returns:

a stream based on the order of row.

streamH

public Stream<E> streamH(int rowIndex)

Parameters:

rowIndex -

Returns:

streamH

public Stream<E> streamH(int fromRowIndex,
                         int toRowIndex)

Parameters:

fromRowIndex -

toRowIndex -

Returns:

a stream based on the order of row.

streamV

public Stream<E> streamV()

Returns:

a stream based on the order of column.

streamV

public Stream<E> streamV(int columnIndex)

Parameters:

columnIndex -

Returns:

streamV

public Stream<E> streamV(int fromColumnIndex,
                         int toColumnIndex)

Parameters:

fromColumnIndex -

toColumnIndex -

Returns:

a stream based on the order of column.

streamR

public Stream<Stream<E>> streamR()

Returns:

a stream based on the order of row.

streamR

public Stream<Stream<E>> streamR(int fromRowIndex,
                                 int toRowIndex)

Parameters:

fromRowIndex -

toRowIndex -

Returns:

a stream based on the order of row.

streamC

public Stream<Stream<E>> streamC()

Returns:

a stream based on the order of column.

streamC

public Stream<Stream<E>> streamC(int fromColumnIndex,
                                 int toColumnIndex)

Parameters:

fromColumnIndex -

toColumnIndex -

Returns:

a stream based on the order of column.

toDataSetH

public DataSet toDataSetH()

Returns:

a DataSet based on row.

toDataSetV

public DataSet toDataSetV()

Returns:

a DataSet based on column.

toMatrixH

public Matrix<E> toMatrixH(java.lang.Class<E> cls)

Parameters:

cls -

Returns:

a Matrix based on row.

toMatrixV

public Matrix<E> toMatrixV(java.lang.Class<E> cls)

Parameters:

cls -

Returns:

a Matrix based on column.

toArrayH

public java.lang.Object[][] toArrayH()

Returns:

a 2D array based on row.

toArrayH

public <T> T[][] toArrayH(java.lang.Class<T> cls)

Returns:

a 2D array based on row.

toArrayV

public java.lang.Object[][] toArrayV()

Returns:

a 2D array based on column.

toArrayV

public <T> T[][] toArrayV(java.lang.Class<T> cls)

Returns:

a 2D array based on column.

println

public void println()

hashCode

public int hashCode()

Overrides:

hashCode in class java.lang.Object

equals

public boolean equals(java.lang.Object obj)

Overrides:

equals in class java.lang.Object

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object