Lägger till HTML Rich Text i Cell
Contents
[
Hide
]
Aspose.Cells stöder konvertering av Microsoft Excel-orienterad HTML till XLS/XLSX-format. Det betyder att HTML som genereras av Microsoft Excel kan konverteras tillbaka till XLS/XLSX-formatet med Aspose.Cells.
På samma sätt, om det finns en enkel HTML, kan Aspose.Cells konvertera den till HTML Rich Text. Aspose.Cells tillhandahållerCell.setHtmlString() egenskap som kan ta en så enkel HTML och konvertera den till formaterad celltext.
Exempel
Följande skärmdump visar Excel-utdatafilen genererad med Aspose.Cells. Som du kan se visar den HTML formaterad rik text som lagts till i cellen A1 med hjälp avCell.setHtmlString()fast egendom.
Detta är exempelkoden som genererade utdata Excel-filen som visas i skärmdumpen ovan.
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 | |
| String dataDir = Utils.getDataDir(AddImageHyperlinks.class); | |
| // Instantiate a new workbook | |
| Workbook workbook = new Workbook(); | |
| // Get the first worksheet | |
| Worksheet worksheet = workbook.getWorksheets().get(0); | |
| // Insert a string value to a cell | |
| worksheet.getCells().get("C2").setValue("Image Hyperlink"); | |
| // Set the 4th row height | |
| worksheet.getCells().setRowHeight(3, 100); | |
| // Set the C column width | |
| worksheet.getCells().setColumnWidth(2, 21); | |
| // Add a picture to the C4 cell | |
| int index = worksheet.getPictures().add(3, 2, 4, 3, dataDir + "aspose-logo.jpg"); | |
| // Get the picture object | |
| com.aspose.cells.Picture pic = worksheet.getPictures().get(index); | |
| // Set the placement type | |
| pic.setPlacement(PlacementType.FREE_FLOATING); | |
| // Add an image hyperlink | |
| pic.addHyperlink("http://www.aspose.com/"); | |
| com.aspose.cells.Hyperlink hlink = pic.getHyperlink(); | |
| // Specify the screen tip | |
| hlink.setScreenTip("Click to go to Aspose site"); | |
| // Save the Excel file | |
| workbook.save(dataDir + "ImageHyperlink.xls"); |