查找图表系列中点的X和Y值类型
Contents
[
Hide
]
可能的使用场景
有时,您想了解系列中的图表点的 X 和 Y 值的类型。Aspose.Cells 提供了 ChartPoint.XValueType 和 ChartPoint.YValueType 属性,可用于此目的。请注意,在使用这些属性之前,您必须调用 Chart.calculate() 方法。
查找图表系列中点的X和Y值类型
以下示例代码加载了 示例 Excel 文件,并访问了第一个工作表中的第一个图表。然后调用 Chart.calculate() 方法,并查找第一个图表点的 X 和 Y 值的类型,并将其打印到控制台。请参阅下面显示的控制台输出以供参考。
示例代码
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 | |
//Converting integer enums to string enums | |
java.util.HashMap<Integer, String> cvTypes = new java.util.HashMap<Integer, String>(); | |
cvTypes.put(CellValueType.IS_NUMERIC, "IsNumeric"); | |
cvTypes.put(CellValueType.IS_STRING, "IsString"); | |
//Load sample Excel file containing chart. | |
Workbook wb = new Workbook(srcDir + "sampleFindTypeOfXandYValuesOfPointsInChartSeries.xlsx"); | |
//Access first worksheet. | |
Worksheet ws = wb.getWorksheets().get(0); | |
//Access first chart. | |
Chart ch = ws.getCharts().get(0); | |
//Calculate chart data. | |
ch.calculate(); | |
//Access first chart point in the first series. | |
ChartPoint pnt = ch.getNSeries().get(0).getPoints().get(0); | |
//Print the types of X and Y values of chart point. | |
System.out.println("X Value Type: " + cvTypes.get(pnt.getXValueType())); | |
System.out.println("Y Value Type: " + cvTypes.get(pnt.getYValueType())); |
控制台输出
X Value Type: IsString
Y Value Type: IsNumeric