获取图表的工作表
Contents
[
Hide
]
有时,您可能希望从图表的引用中访问工作表。Aspose.Cells提供了Chart.getWorksheet()属性,该属性返回包含图表的工作表的引用。
示例
以下示例显示了如何使用Chart.getWorksheet()属性。代码首先打印工作表的名称,然后访问工作表上的第一个图表。然后使用Chart.getWorksheet()属性再次打印工作表名称。
用于访问图表的工作表的Java代码
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 | |
// 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