Package ch.ethz.sis.openbis.generic.asapi.v3.dto.common.property

Class Spreadsheet

java.lang.Object

ch.ethz.sis.openbis.generic.asapi.v3.dto.common.property.Spreadsheet

All Implemented Interfaces:

Serializable

@JsonObject("as.dto.common.property.Spreadsheet")
public final class Spreadsheet
extends Object
implements Serializable

See Also:

• Serialized Form

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
final class	Spreadsheet.CellBuilder
class	Spreadsheet.ColumnBuilder

Constructor Summary

Constructors

Constructor	Description
Spreadsheet()
Spreadsheet(int columnCount, int rowCount)

Method Summary

Modifier and Type	Method	Description
void	addColumn()
void	addColumn(String label)
void	addRow()
Spreadsheet.CellBuilder	cell(int columnNumber, int rowNumber)
Spreadsheet.CellBuilder	cell(String columnHeader, int rowNumber)
Spreadsheet.ColumnBuilder	column(int columnNumber)
Spreadsheet.ColumnBuilder	column(String columnHeader)
void	deleteColumn(int columnNumber)
void	deleteColumn(String label)
void	deleteRow(int rowNumber)
int	getColumnCount()
String[][]	getFormulas()
String[]	getHeaders()
Map<String,String>	getMetaData()
int	getRowCount()
Map<String,String>	getStyle()
String[][]	getValues()
String	getVersion()
Integer[]	getWidth()
void	setMetaData(Map<String,String> meta)
String	toString()

Methods inherited from class java.lang.Object

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

Constructor Details

Spreadsheet

public Spreadsheet()

Spreadsheet

public Spreadsheet(int columnCount,
 int rowCount)

Method Details

getColumnCount

public int getColumnCount()

getRowCount

public int getRowCount()

getVersion

public String getVersion()

getMetaData

public Map<String,String> getMetaData()

setMetaData

public void setMetaData(Map<String,String> meta)

getFormulas

public String[][] getFormulas()

getHeaders

public String[] getHeaders()

getValues

public String[][] getValues()

getWidth

public Integer[] getWidth()

getStyle

public Map<String,String> getStyle()

cell

public Spreadsheet.CellBuilder cell(String columnHeader,
 int rowNumber)

cell

public Spreadsheet.CellBuilder cell(int columnNumber,
 int rowNumber)

column

public Spreadsheet.ColumnBuilder column(String columnHeader)

column

public Spreadsheet.ColumnBuilder column(int columnNumber)

addRow

public void addRow()

deleteRow

public void deleteRow(int rowNumber)

addColumn

public void addColumn()

addColumn

public void addColumn(String label)

deleteColumn

public void deleteColumn(String label)

deleteColumn

public void deleteColumn(int columnNumber)

toString

public String toString()

Overrides:

toString in class Object