为图表工作表创建PdfBookmarkEntry
Contents
[
Hide
]
可能的使用场景
以往,Aspose.Cells 会为普通工作表创建 PdfBookmarkEntry,但现在还可以为图表工作表创建 PdfBookmarkEntry。因为图表工作表除了 A1 单元格外没有其他单元格,所以它将为 A1 单元格创建 PdfBookmarkEntry。
为图表工作表创建PdfBookmarkEntry
以下示例代码加载了一个具有四个工作表的 示例 Excel 文件。其中两个是普通工作表,另外两个是图表工作表。它创建四个书签条目如下
- 书签I
- 书签II-Chart1
- 书签III
- 书签IV-Chart2
以下截图显示了由示例代码生成的 输出 PDF 供参考。
示例代码
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 | |
//Load sample Excel file | |
Workbook wb = new Workbook("sampleCreatePdfBookmarkEntryForChartSheet.xlsx"); | |
//Access all four worksheets | |
Worksheet sheet1 = wb.getWorksheets().get(0); | |
Worksheet sheet2 = wb.getWorksheets().get(1); | |
Worksheet sheet3 = wb.getWorksheets().get(2); | |
Worksheet sheet4 = wb.getWorksheets().get(3); | |
//Create Pdf Bookmark Entry for Sheet1 | |
PdfBookmarkEntry ent1 = new PdfBookmarkEntry(); | |
ent1.setDestination(sheet1.getCells().get("A1")); | |
ent1.setText("Bookmark-I"); | |
//Create Pdf Bookmark Entry for Sheet2 - Chart | |
PdfBookmarkEntry ent2 = new PdfBookmarkEntry(); | |
ent2.setDestination(sheet2.getCells().get("A1")); | |
ent2.setText("Bookmark-II-Chart1"); | |
//Create Pdf Bookmark Entry for Sheet3 | |
PdfBookmarkEntry ent3 = new PdfBookmarkEntry(); | |
ent3.setDestination(sheet3.getCells().get("A1")); | |
ent3.setText("Bookmark-III"); | |
//Create Pdf Bookmark Entry for Sheet4 - Chart | |
PdfBookmarkEntry ent4 = new PdfBookmarkEntry(); | |
ent4.setDestination(sheet4.getCells().get("A1")); | |
ent4.setText("Bookmark-IV-Chart2"); | |
//Arrange all Bookmark Entries | |
ArrayList lst = new ArrayList(); | |
ent1.setSubEntry(lst); | |
lst.add(ent2); | |
lst.add(ent3); | |
lst.add(ent4); | |
//Create Pdf Save Options with Bookmark Entries | |
PdfSaveOptions opts = new PdfSaveOptions(); | |
opts.setBookmark(ent1); | |
//Save the output Pdf | |
wb.save("outputCreatePdfBookmarkEntryForChartSheet.pdf", opts); |