查找单元格值是否以单引号开始

Contents
[ ]

下面的示例代码解释了像“sample”和“‘sample”这样的字符串不能通过Cell.string_value属性进行区分。因此,我们必须使用Style.quote_prefix属性对它们进行区分。

from aspose.cells import Workbook
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
# Create workbook
wb = Workbook()
# Create worksheet
sheet = wb.worksheets[0]
# Access cell A1 and A2
a1 = sheet.cells.get("A1")
a2 = sheet.cells.get("A2")
# Add sample in A1 and sample with quote prefix in A2
a1.put_value("sample")
a2.put_value("'sample")
# Print their string values, A1 and A2 both are same
print("String value of A1: " + a1.string_value)
print("String value of A2: " + a2.string_value)
# Access styles of A1 and A2
s1 = a1.get_style()
s2 = a2.get_style()
print()
# Check if A1 and A2 has a quote prefix
print("A1 has a quote prefix: " + str(s1.quote_prefix))
print("A2 has a quote prefix: " + str(s2.quote_prefix))