urpa.ExcelWorksheet Class Reference

This class represents one sheet in an MS Excel workbook. More...

Public Member Functions
def	name (self)
	This method returns the name of a sheet of an MS Excel workbook. More...
def	cells (self)
	This method returns all the cells of a sheet in an MS Excel workbook. More...
def	used_range (self)
	This method returns a block or area of used cells of a sheet in an MS Excel workbook. More...
def	cell (self, col, row)
	This method returns the cell of a sheet of an MS Excel workbook in a position specified by its col and row parameters. More...
def	activate (self)
	This method activates a sheet of an MS Excel workbook, and brings the workbook to the foreground. More...

Detailed Description

This class represents one sheet in an MS Excel workbook.

Member Function Documentation

activate()

def urpa.ExcelWorksheet.activate

(

self

)

This method activates a sheet of an MS Excel workbook, and brings the workbook to the foreground.

cell()

def urpa.ExcelWorksheet.cell	(		self,
			col,
			row
	)

This method returns the cell of a sheet of an MS Excel workbook in a position specified by its col and row parameters.

The col and row indices are numbered from 1 in the MS Excel workbook sheet.

Parameters

col	integer The index of the column in which the required cell of the MS Excel workbook sheet is located.
row	integer The index of the row in which the required cell of the MS Excel workbook sheet is located.

Returns

Returns an ExcelCells-type object, representing one cell.

cells()

def urpa.ExcelWorksheet.cells

(

self

)

This method returns all the cells of a sheet in an MS Excel workbook.

Returns

Returns an ExcelCells-type object, representing all the cells of a sheet in an MS Excel workbook.

name()

def urpa.ExcelWorksheet.name

(

self

)

This method returns the name of a sheet of an MS Excel workbook.

Returns

Returns a string containing the name of a sheet in an MS Excel workbook.

used_range()

def urpa.ExcelWorksheet.used_range

(

self

)

This method returns a block or area of used cells of a sheet in an MS Excel workbook.

Returns

Returns an ExcelCells-type object, representing a block or area of used cells, i.e. used and empty cells.

---

The documentation for this class was generated from the following file:

• urpa.py