pyexcel.Sheet

class pyexcel.Sheet(sheet=None, name='pyexcel', name_columns_by_row=-1, name_rows_by_column=-1, colnames=None, rownames=None, transpose_before=False, transpose_after=False)

Two dimensional data container for filtering, formatting and iteration

Sheet is a container for a two dimensional array, where individual cell can be any Python types. Other than numbers, value of thsee types: string, date, time and boolean can be mixed in the array. This differs from Numpy’s matrix where each cell are of the same number type.

In order to prepare two dimensional data for your computation, formatting functions help convert array cells to required types. Formatting can be applied not only to the whole sheet but also to selected rows or columns. Custom conversion function can be passed to these formatting functions. For example, to remove extra spaces surrounding the content of a cell, a custom function is required.

Filtering functions are used to reduce the information contained in the array.

__init__(sheet=None, name='pyexcel', name_columns_by_row=-1, name_rows_by_column=-1, colnames=None, rownames=None, transpose_before=False, transpose_after=False)

Constructor

Parameters:

• sheet – two dimensional array
• name – this becomes the sheet name.
• name_columns_by_row – use a row to name all columns
• name_rows_by_column – use a column to name all rows
• colnames – use an external list of strings to name the columns
• rownames – use an external list of strings to name the rows

Methods

Attributes

colnames	Return column names
column	Column representation.
row	Row representation.
rownames	Return row names