获取图表的工作表

示例

以下示例显示了如何使用Chart.getWorksheet()属性。代码首先打印工作表的名称,然后访问工作表上的第一个图表。然后使用Chart.getWorksheet()属性再次打印工作表名称。

用于访问图表的工作表的Java代码

// 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(GetWorksheetOfChart.class);
// Create workbook from sample Excel file
Workbook workbook = new Workbook(dataDir + "sample.xlsx");
// Access first worksheet of the workbook
Worksheet worksheet = workbook.getWorksheets().get(0);
// Print worksheet name
System.out.println("Sheet Name: " + worksheet.getName());
// Access the first chart inside this worksheet
Chart chart = worksheet.getCharts().get(0);
// Access the chart's sheet and display its name again
System.out.println("Chart's Sheet Name: " + chart.getWorksheet().getName());

样本代码生成的控制台输出

以下是示例代码生成的控制台输出结果。如您所见,它两次打印相同的工作表名称。

Sheet Name: Portfolio

Chart's Sheet Name: Portfolio