Syncfusion.XlsIO.Base
Example 


One-based row index.
One-based column index.

Contains Method (IWorksheet)

Checks whether the specified cell is initialized or accessed.
Syntax
'Declaration
 
Function Contains( _
   ByVal iRow As Integer, _
   ByVal iColumn As Integer _
) As Boolean
'Usage
 
Dim instance As IWorksheet
Dim iRow As Integer
Dim iColumn As Integer
Dim value As Boolean
 
value = instance.Contains(iRow, iColumn)
bool Contains( 
   int iRow,
   int iColumn
)

Parameters

iRow
One-based row index.
iColumn
One-based column index.

Return Value

True if the cell is initialized or accessed by the user; otherwise, False.
Example
The following code illustrates if the specified cells contains a value.
ExcelEngine excelEngine = new ExcelEngine();
IApplication application = excelEngine.Excel;
IWorkbook workbook = application.Workbooks.Create(1);
IWorksheet worksheet = workbook.Worksheets[0];
worksheet.Range["A1"].Text = "Hello";
worksheet.Contains(1, 1);
workbook.Version = ExcelVersion.Excel2013;
workbook.SaveAs("Output.xlsx");
workbook.Close();
excelEngine.Dispose();
AssemblyVersion

Syncfusion.XlsIO.Base: 16.3460.0.29

See Also