查找单元格值是否以单引号开始
Contents
[
Hide
]
Aspose.Cells for Python via .NET现在提供了Style.quote_prefix属性,以查找单元格值是否以单引号标记开始。在使用此属性之前,无法区分“sample”和“‘sample”等字符串。
下面的示例代码解释了像“sample”和“‘sample”这样的字符串不能通过Cell.string_value属性进行区分。因此,我们必须使用Style.quote_prefix属性对它们进行区分。
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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)) |