This is UltimateRPA Documentation
This method represents one cell, one row, a column or a block of cells in an MS Excel workbook sheet. More...
Public Member Functions | |
| def | column (self) |
| This method returns the minimum index of a column in a sheet of an MS Excel workbook tied to a set of cells in an instance of this class. More... | |
| def | row (self) |
| This method returns the minimum index of a row in a sheet of an MS Excel workbook tied to a set of cells in an instance of this class. More... | |
| def | item (self, col, row) |
| This method returns the cell of a sheet of an MS Excel workbook in a col and row position. More... | |
| def | value (self, formatted=True) |
| This method returns the value of a cell in a sheet of an MS Excel workbook. More... | |
| def | set_value (self, value) |
| This method sets a value for cells in a sheet of an MS Excel workbook. More... | |
| def | activate (self) |
| This method activates cells in an MS Excel workbook sheet. More... | |
| def | select (self) |
| This method selects cells in an MS Excel workbook sheet. More... | |
| def | rows_count (self) |
| This method returns the number of rows in an MS Excel workbook sheet. More... | |
| def | columns_count (self) |
| This method returns the number of columns in an MS Excel workbook sheet. More... | |
| def | copy (self) |
| This method copies the content of MS Excel workbook sheet cells to Windows clipboard. More... | |
This method represents one cell, one row, a column or a block of cells in an MS Excel workbook sheet.
| def urpa.ExcelCells.activate | ( | self | ) |
This method activates cells in an MS Excel workbook sheet.
Only one cell in an MS Excel workbook sheet may be active - see the MSDN documentation.
| def urpa.ExcelCells.column | ( | self | ) |
This method returns the minimum index of a column in a sheet of an MS Excel workbook tied to a set of cells in an instance of this class.
The indices are numbered from 1.
| def urpa.ExcelCells.columns_count | ( | self | ) |
This method returns the number of columns in an MS Excel workbook sheet.
| def urpa.ExcelCells.copy | ( | self | ) |
This method copies the content of MS Excel workbook sheet cells to Windows clipboard.
| def urpa.ExcelCells.item | ( | self, | |
| col, | |||
| row | |||
| ) |
This method returns the cell of a sheet of an MS Excel workbook in a col and row position.
The indices are numbered from 1.
| 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. |
| def urpa.ExcelCells.row | ( | self | ) |
This method returns the minimum index of a row in a sheet of an MS Excel workbook tied to a set of cells in an instance of this class.
The indices are numbered from 1.
| def urpa.ExcelCells.rows_count | ( | self | ) |
This method returns the number of rows in an MS Excel workbook sheet.
| def urpa.ExcelCells.select | ( | self | ) |
This method selects cells in an MS Excel workbook sheet.
| def urpa.ExcelCells.set_value | ( | self, | |
| value | |||
| ) |
This method sets a value for cells in a sheet of an MS Excel workbook.
If an instance of this class represents an entire sheet in an MS Excel workbook, the invocation of this method is not supported.
| value | String The value to be set for cells. |
| def urpa.ExcelCells.value | ( | self, | |
formatted = True |
|||
| ) |
This method returns the value of a cell in a sheet of an MS Excel workbook.
If an instance of this class represents more than one cell, the invocation of this method is not supported.
| formatted | bool |