通过使用HTML设置单元格值显示项目符号
Contents
[
Hide
]
Aspose.Cells现在支持使用HTML代码显示项目符号。本文将解释如何通过设置单元格值使用HTML来显示项目符号。我们将使用Cell.setHtmlString()属性来使用我们的HTML设置单元格值。
使用HTML设置单元格值显示项目符号
以下代码使用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-Java | |
// The path to the documents directory. | |
String dataDir = Utils.getDataDir(DisplayBullets.class); | |
//Create workbook object | |
Workbook workbook = new Workbook(); | |
//Access first worksheet | |
Worksheet worksheet = workbook.getWorksheets().get(0); | |
//Access cell A1 | |
Cell cell = worksheet.getCells().get("A1"); | |
//Set the HTML string | |
cell.setHtmlString("<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>"); | |
//Save the workbook | |
workbook.save(dataDir + "output.xlsx"); |
输出
以下截图显示了上述示例代码的输出。