使用原始值搜索数据

有时，数据的值由于某种方式的格式而被隐藏。例如，假设单元格D4具有公式=Sum(A1:A2)，其值为20，但其格式为—，则值20被隐藏，无法使用Microsoft Excel的查找选项找到。但是，您可以使用Aspose.Cells for Python via .NET使用LookInType.ORIGINAL_VALUES找到它。

以下示例代码说明了上述观点。它会找到无法使用Microsoft Excel的查找选项找到的单元格D4，但Aspose.Cells可以使用LookInType.ORIGINAL_VALUES找到它。请阅读代码内的注释以获取更多信息。

用于搜索原始值的Python代码

from aspose.cells import FindOptions, LookAtType, LookInType, Workbook

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
#  Create workbook object
workbook = Workbook()
#  Access first worksheet
worksheet = workbook.worksheets[0]
#  Add 10 in cell A1 and A2
worksheet.cells.get("A1").put_value(10)
worksheet.cells.get("A2").put_value(10)
#  Add Sum formula in cell D4 but customize it as ---
cell = worksheet.cells.get("D4")
style = cell.get_style()
style.custom = "---"
cell.set_style(style)
#  The result of formula will be 20 but 20 will not be visible because the cell is formated as ---
cell.formula = "=Sum(A1:A2)"
#  Calculate the workbook
workbook.calculate_formula()
#  Create find options, we will search 20 using original values otherwise 20 will never be found because it is formatted as ---
options = FindOptions()
options.look_in_type = LookInType.ORIGINAL_VALUES
options.look_at_type = LookAtType.ENTIRE_CONTENT
foundCell = None
obj = 20
#  Find 20 which is Sum(A1:A2) and formatted as ---
foundCell = worksheet.cells.find(obj, foundCell, options)
#  Print the found cell
print(foundCell)
#  Save the workbook
workbook.save(dataDir + "output_out.xlsx")

示例代码生成的控制台输出

这是上面示例代码的控制台输出。

Aspose.Cells.Cell [ D4; ValueType : IsNumeric; Value : ---; Formula:=SUM(A1:A2)]