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

Aspose.Cells 现在提供了属性 Style.QuotePrefix 来查找单元格值是否以单引号标记开始。在此属性之前，无法区分类似 sample 和 ‘sample 等字符串。

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

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// Create workbook
Workbook wb = new Workbook();

// Create worksheet
Worksheet sheet = wb.Worksheets[0];

// Access cell A1 and A2
Cell a1 = sheet.Cells["A1"];
Cell a2 = sheet.Cells["A2"];

// Add sample in A1 and sample with quote prefix in A2
a1.PutValue("sample");
a2.PutValue("'sample");

// Print their string values, A1 and A2 both are same
Console.WriteLine("String value of A1: " + a1.StringValue);
Console.WriteLine("String value of A2: " + a2.StringValue);

// Access styles of A1 and A2
Style s1 = a1.GetStyle();
Style s2 = a2.GetStyle();

Console.WriteLine();

// Check if A1 and A2 has a quote prefix
Console.WriteLine("A1 has a quote prefix: " + s1.QuotePrefix);
Console.WriteLine("A2 has a quote prefix: " + s2.QuotePrefix);