在 Cells 中寻找价值
Contents
[
Hide
]
Aspose.Cells - 在 Cells 中寻找价值
在 Microsoft Excel 中，用户可以搜索包含特定数据的单元格。例如，点击编辑接着寻找打开搜索对话框。用户输入一个值并点击好的搜索它。 Excel 突出显示匹配字段。
C#
//Instantiating a Workbook object
Workbook workbook = new Workbook("../../data/test.xlsx");
//Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];
//Finding the cell containing the specified formula
Cells cells = worksheet.Cells;
//Instantiate FindOptions
FindOptions findOptions = new FindOptions();
//Finding the cell containing a string value that starts with "Or"
findOptions.LookAtType = LookAtType.StartWith;
Cell cell = cells.Find("SH", null, findOptions);
//Printing the name of the cell found after searching worksheet
Console.WriteLine("Name of the cell containing String: " + cell.Name);
下载运行代码
下载在 Cells 中寻找价值形成以下任何一个社交编码网站：
欲了解更多详情，请访问查找或搜索数据.