为图表工作表创建PdfBookmarkEntry

可能的使用场景

以前,Aspose.Cells会为普通工作表创建 PdfBookmarkEntry。但现在Aspose.Cells还可以为图表工作表创建 PdfBookmarkEntry。由于图表工作表除了单元格A1之外没有其他单元格,所以它将仅为单元格A1创建 PdfBookmarkEntry

为图表工作表创建PdfBookmarkEntry

以下示例代码加载了具有四个工作表的示例Excel文件,其中两个是普通工作表,另外两个是图表工作表。它创建了四个书签条目,如下所示

  • 书签I
  • 书签II-Chart1
  • 书签III
  • 书签IV-Chart2

以下屏幕截图显示了示例代码生成的输出PDF以供参考。

todo:image_alt_text

示例代码

// 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);