通过使用HTML设置单元格值显示项目符号
Contents
[
Hide
]
Aspose.Cells支持使用HTML代码显示项目符号。本文将解释如何通过使用HTML设置单元格值来显示项目符号。我们将使用Cell.HtmlString属性使用我们的HTML设置单元格值。
通过在单元格中设置 HTML 来显示项目符号的 C# 代码
以下代码使用HTML代码设置单元格值。一旦运行此代码，您将获得下面图像中显示的输出。
This file contains 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
| // For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
| // The path to the documents directory. | |
| string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
| // Create workbook object | |
| Workbook workbook = new Workbook(); | |
| // Access first worksheet | |
| Worksheet worksheet = workbook.Worksheets[0]; | |
| // Access cell A1 | |
| Cell cell = worksheet.Cells["A1"]; | |
| // Set the HTML string | |
| cell.HtmlString = "<font style='font-family:Arial;font-size:10pt;color:#666666;vertical-align:top;text-align:left;'>Text 1 </font><font style='font-family:Wingdings;font-size:8.0pt;color:#009DD9;mso-font-charset:2;'>l</font><font style='font-family:Arial;font-size:10pt;color:#666666;vertical-align:top;text-align:left;'> Text 2 </font><font style='font-family:Wingdings;font-size:8.0pt;color:#009DD9;mso-font-charset:2;'>l</font><font style='font-family:Arial;font-size:10pt;color:#666666;vertical-align:top;text-align:left;'> Text 3 </font><font style='font-family:Wingdings;font-size:8.0pt;color:#009DD9;mso-font-charset:2;'>l</font><font style='font-family:Arial;font-size:10pt;color:#666666;vertical-align:top;text-align:left;'> Text 4 </font>"; | |
| // Auto fit the Columns | |
| worksheet.AutoFitColumns(); | |
| // Save the workbook | |
| workbook.Save(dataDir + "BulletsInCells_out.xlsx"); |
示例代码生成的输出
以下截图显示了上述示例代码的输出。
