Note: To work with Excel files in your tests, you do not need to have Microsoft Office Excel installed on your computer.
Description
The ExcelSheet.Cell property returns the ExcelCell object that holds the content of the Excel cell.
Declaration
ExcelSheetObj.Cell(Column, Row)
| Read-Only Property | An ExcelCell object |
| ExcelSheetObj | An expression, variable or parameter that specifies a reference to an ExcelSheet object | |||
| Column | [in] | Required | Object | |
| Row | [in] | Required | Integer | |
Applies To
The property is applied to the following object:
Parameters
The property has the following parameters:
Column
An index (starting from 1) or name ("A", "B", ...) of the column that belongs to the desired cell.
Row
An index (starting from 1) of the row that belongs to the desired cell.
Property Value
An ExcelCell object that corresponds to the cell with the specified row and column identifiers. To get the value of Excel cells, use the ExcelCell.Value property.
Example
The code below demonstrates how you can use the ExcelSheet.Cell property in your script:
JavaScript, JScript
function ExcelExample()
{
// Get the sheet of the Excel file
var excelFile = Excel.Open("C:\\temp\\DataStorageExcel.xlsx");
var excelSheet = excelFile.SheetByTitle("Sheet1");
// Read data from the Excel file
var valueA = excelSheet.Cell("A", 3).Value;
var valueB = excelSheet.Cell(2, 3).Value;
var valueC = excelSheet.CellByName("C3").Value;
// Write the obtained data into a new row of the file
var rowIndex = excelSheet.RowCount + 1;
excelSheet.Cell("A", rowIndex).Value = valueA;
excelSheet.Cell(2, rowIndex).Value = valueB;
excelSheet.Cell("C", rowIndex).Value = valueC;
// Save the file to apply the changes
excelFile.Save();
// Save the file with another name
// excelFile.SaveAs("C:\\temp\\DataStorageExcel_new.xlsx");
}
Python
def ExcelExample():
# Get the sheet of the Excel file
excelFile = Excel.Open("C:\\temp\\DataStorageExcel.xlsx")
excelSheet = excelFile.SheetByTitle["Sheet1"]
# Read data from the Excel file
valueA = excelSheet.Cell["A", 3].Value
valueB = excelSheet.Cell[2, 3].Value
valueC = excelSheet.CellByName["C3"].Value
# Write the obtained data into a new row of the file
rowIndex = excelSheet.RowCount + 1
excelSheet.Cell["A", rowIndex].Value = valueA
excelSheet.Cell[2, rowIndex].Value = valueB
excelSheet.Cell("C", rowIndex).Value = valueC
# Save the file to apply the changes
excelFile.Save()
# Save the file with another name
# excelFile.SaveAs("C:\\temp\\DataStorageExcel_new.xlsx")VBScript
Sub ExcelExample
Dim excelFile, excelSheet, valueA, valueB, valueC, rowIndex
' Get the sheet of the Excel file
Set excelFile = Excel.Open("C:\temp\DataStorageExcel.xlsx")
Set excelSheet = excelFile.SheetByTitle("Sheet1")
' Read data from the Excel file
valueA = excelSheet.Cell("A", 3).Value
valueB = excelSheet.Cell(2, 3).Value
valueС = excelSheet.CellByName("C3").Value
' Write the obtained data into a new row of the file
rowIndex = excelSheet.RowCount + 1
excelSheet.Cell("A", rowIndex).Value = valueA
excelSheet.Cell(2, rowIndex).Value = valueB
excelSheet.Cell("C", rowIndex).Value = valueC
' Save the file to apply the changes
excelFile.Save()
' Save the file with another name
' excelFile.SaveAs("C:\temp\DataStorageExcel_new.xlsx")
End Sub
DelphiScript
procedure ExcelExample;
var
excelFile, excelSheet, valueA, valueB, valueC, rowIndex;
begin
// Get the sheet of the Excel file
excelFile := Excel.Open('C:\\temp\\DataStorageExcel.xlsx');
excelSheet := excelFile.SheetByTitle('Sheet1');
// Read data from the Excel file
valueA := excelSheet.Cell('A', 3).Value;
valueB := excelSheet.Cell(2, 3).Value;
valueC := excelSheet.CellByName('C3').Value;
// Write the obtained data into a new row of the file
rowIndex := excelSheet.RowCount + 1;
excelSheet.Cell('A', rowIndex).Value := valueA;
excelSheet.Cell(2, rowIndex).Value := valueB;
excelSheet.Cell('C', rowIndex).Value := valueC;
// Save the file to apply the changes
excelFile.Save();
// Save the file with another name
// excelFile.SaveAs('C:\\temp\\DataStorageExcel_new.xlsx');
end;
C++Script, C#Script
function ExcelExample()
{
// Get the sheet of the Excel file
var excelFile = Excel["Open"]("C:\\temp\\DataStorageExcel.xlsx");
var excelSheet = excelFile["SheetByTitle"]("Sheet1");
// Read data from the Excel file
var valueA = excelSheet["Cell"]("A", 3)["Value"];
var valueB = excelSheet["Cell"](2, 3)["Value"];
var valueC = excelSheet["CellByName"]("C3")["Value"];
// Write the obtained data into a new row of the file
var rowIndex = excelSheet["RowCount + 1"];
excelSheet["Cell"]("A", rowIndex)["Value"] = valueA;
excelSheet["Cell"](2, rowIndex)["Value"] = valueB;
excelSheet["Cell"]("C", rowIndex)["Value"] = valueC;
// Save the file to apply the changes
excelFile["Save"]();
// Save the file with another name
// excelFile["SaveAs"]("C:\\temp\\DataStorageExcel.xlsx");
}