为图表工作表创建PdfBookmarkEntry
Contents
[
Hide
]
可能的使用场景
以前,Aspose.Cells会为普通工作表创建 PdfBookmarkEntry。但现在Aspose.Cells还可以为图表工作表创建 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-.NET | |
//Load sample Excel file | |
Workbook wb = new Workbook("sampleCreatePdfBookmarkEntryForChartSheet.xlsx"); | |
//Access all four worksheets | |
Worksheet sheet1 = wb.Worksheets[0]; | |
Worksheet sheet2 = wb.Worksheets[1]; | |
Worksheet sheet3 = wb.Worksheets[2]; | |
Worksheet sheet4 = wb.Worksheets[3]; | |
//Create Pdf Bookmark Entry for Sheet1 | |
PdfBookmarkEntry ent1 = new PdfBookmarkEntry(); | |
ent1.Destination = sheet1.Cells["A1"]; | |
ent1.Text = "Bookmark-I"; | |
//Create Pdf Bookmark Entry for Sheet2 - Chart | |
PdfBookmarkEntry ent2 = new PdfBookmarkEntry(); | |
ent2.Destination = sheet2.Cells["A1"]; | |
ent2.Text = "Bookmark-II-Chart1"; | |
//Create Pdf Bookmark Entry for Sheet3 | |
PdfBookmarkEntry ent3 = new PdfBookmarkEntry(); | |
ent3.Destination = sheet3.Cells["A1"]; | |
ent3.Text = "Bookmark-III"; | |
//Create Pdf Bookmark Entry for Sheet4 - Chart | |
PdfBookmarkEntry ent4 = new PdfBookmarkEntry(); | |
ent4.Destination = sheet4.Cells["A1"]; | |
ent4.Text = "Bookmark-IV-Chart2"; | |
//Arrange all Bookmark Entries | |
ArrayList lst = new ArrayList(); | |
ent1.SubEntry = lst; | |
lst.Add(ent2); | |
lst.Add(ent3); | |
lst.Add(ent4); | |
//Create Pdf Save Options with Bookmark Entries | |
PdfSaveOptions opts = new PdfSaveOptions(); | |
opts.Bookmark = ent1; | |
//Save the output Pdf | |
wb.Save("outputCreatePdfBookmarkEntryForChartSheet.pdf", opts); |