Note: To work with Excel files in your tests, you do not need to have Microsoft Office Excel installed on your computer.
Description
The SheetCount property returns the number of the sheets in the Excel file.
Declaration
ExcelFileObj.SheetCount(SheetTitle)
| Read-Only Property | Integer |
| ExcelFileObj | An expression, variable or parameter that specifies a reference to an ExcelFile object | |||
| SheetTitle | [in] | Required | String | |
Applies To
The property is applied to the following object:
Parameters
The property has the following parameter:
SheetTitle
A title of the desired sheet.
Property Value
Total number of the sheets in the Excel file.
Example
The code below demonstrates how you can use the ExcelFile.SheetCount property in your script:
JavaScript, JScript
function ExcelExample()
{
var fileName = "c:\\temp\\MyFile.xlsx";
var searchValue = "MyValue";
// Open the Excel file
var excelFile = Excel.Open(fileName);
// Search the specified value in the Excel file
var found = false;
for (var i = 0; i < excelFile.SheetCount; i++)
{
var excelSheet = excelFile.SheetByIndex(i);
for (var j = 1; j <= excelSheet.ColumnCount; j++)
{
for (var k =1; k <= excelSheet.RowCount; k++)
if (excelSheet.Cell(j, k).Value == searchValue)
{
Log.Message("The specified value is found on the " + excelSheet.Title + " sheet in the (" + j + "," + k + ") cell");
found = true;
}
}
}
if (found == false)
Log.Message("The specified value isn't found");
}
Python
def ExcelExample():
fileName = "c:\\temp\\MyFile.xlsx"
searchValue = "MyValue"
# Open the Excel file
excelFile = Excel.Open(fileName)
# Search the specified value in the Excel file
found = 0
for i in range (0, excelFile.SheetCount):
excelSheet = excelFile.SheetByIndex[i]
for j in range (1, excelSheet.ColumnCount):
for k in range (1, excelSheet.RowCount):
if (excelSheet.Cell[j, k].Value == searchValue):
Log.Message("The specified value is found on the " + excelSheet.Title + " sheet in the (" + str(j) + "," + str(k) + ") cell")
found = 1
if (found == 0):
Log.Message("The specified value isn't found")VBScript
Sub ExcelExample
Dim fileName, searchValue, excelFile, found, i, excelSheet, j, k
fileName = "c:\temp\MyFile.xlsx"
searchValue = "MyValue"
' Open the Excel file
Set excelFile = Excel.Open(fileName)
' Search the specified value in the Excel file
found = false
For i = 0 To excelFile.SheetCount - 1
Set excelSheet = excelFile.SheetByIndex(i)
For j = 1 to excelSheet.ColumnCount
For k =1 to excelSheet.RowCount
If excelSheet.Cell(j, k).Value = searchValue Then
Log.Message("The specified value is found on the " & excelSheet.Title & " sheet in the (" & j & "," & k & ") cell")
found = true
End If
Next
Next
Next
If found = false Then
Log.Message("The specified value isn't found")
End If
End Sub
DelphiScript
procedure ExcelExample;
var
fileName, excelFile, searchValue, found, excelSheet, i, j, k;
begin
fileName := 'c:\\temp\\MyFile.xlsx';
searchValue := 'MyValue';
// Open the Excel file
excelFile := Excel.Open(fileName);
// Search the specified value in the Excel file
found := false;
for i := 0 to excelFile.SheetCount -1 do
begin
excelSheet := excelFile.SheetByIndex(i);
for j := 1 to excelSheet.ColumnCount do
begin
for k := 1 to excelSheet.RowCount do
begin
if (VarToStr(excelSheet.Cell(j, k).Value) = VarToStr(searchValue)) then
begin
Log.Message('The specified value is found on the ' + VarToStr(excelSheet.Title) + ' sheet in the (' + VarToStr(j) + ',' + VarToStr(k) + ') cell');
found := true;
end;
end;
end;
end;
if found = false then
begin
Log.Message('The specified value is not found')
end;
end;
C++Script, C#Script
function ExcelExample()
{
var fileName = "c:\\temp\\MyFile.xlsx";
var searchValue = "MyValue";
// Open the Excel file
var excelFile = Excel["Open"](fileName);
// Search the specified value in the Excel file
var found = false;
for (var i = 0; i < excelFile["SheetCount"]; i++)
{
var excelSheet = excelFile["SheetByIndex"](i);
for (var j = 1; j <= excelSheet["ColumnCount"]; j++)
{
for (var k =1; k <= excelSheet["RowCount"]; k++)
if (excelSheet["Cell"](j, k)["Value"] == searchValue)
{
Log["Message"]("The specified value is found on the " + excelSheet.Title + " sheet in the (" + j + "," + k + ") cell");
found = true;
}
}
}
if (found == false)
Log["Message"]("The specified value isn't found");
}