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

Aspose.Cells 现在提供样式.QuotePrefix属性来查找单元格值是否以单引号开头。在此属性之前，无法区分 sample 和 ‘sample 等字符串。

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

下面的示例代码解释了像 sample 和 ‘sample 这样的字符串不能被区分Cell.StringValue财产。因此我们必须使用样式.QuotePrefix属性来区分它们。

//Create an instance of workbook
Workbook workbook = new Workbook();

//Access first worksheet from the collection
Worksheet worksheet = workbook.getWorksheets().get(0);

//Access cells A1 and A2
Cell a1 = worksheet.getCells().get("A1");
Cell a2 = worksheet.getCells().get("A2");

//Add simple text to cell A1 and text with quote prefix to cell A2
a1.putValue("sample");
a2.putValue("'sample");

//Print their string values, A1 and A2 both are same
System.out.println("String value of A1: " + a1.getStringValue());
System.out.println("String value of A2: " + a2.getStringValue());

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

System.out.println();

//Check if A1 and A2 has a quote prefix
System.out.println("A1 has a quote prefix: " + s1.getQuotePrefix());
System.out.println("A2 has a quote prefix: " + s2.getQuotePrefix());