创建联合范围

创建联合范围

Aspose.Cells 提供通过使用创建联合范围的能力[工作表集合.CreateUnionRange](https://reference.aspose.com/cells/java/com.aspose.cells/worksheetcollection#createUnionRange(java.lang.String,%20int)) 方法。这[工作表集合.CreateUnionRange](https://reference.aspose.com/cells/java/com.aspose.cells/worksheetcollection#createUnionRange(java.lang.String,%20int)方法接受两个参数,创建联合范围的地址和工作表的索引。这[工作表集合.CreateUnionRange](https://reference.aspose.com/cells/java/com.aspose.cells/worksheetcollection#createUnionRange(java.lang.String,%20int)方法返回一个联盟范围目的。

以下代码片段演示了使用[工作表集合.CreateUnionRange](https://reference.aspose.com/cells/java/com.aspose.cells/worksheetcollection#createUnionRange(java.lang.String,%20int)) 方法。附上代码生成的输出文件,供参考。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
//Source directory
String sourceDir = Utils.Get_SourceDirectory();
//Output directory
String outputDir = Utils.Get_OutputDirectory();
// Instantiating a Workbook object
Workbook workbook = new Workbook(sourceDir + "SampleChangeTickLabelDirection.xlsx");
Worksheet worksheet = workbook.getWorksheets().get(0);
// Load the chart from source worksheet
Chart chart = worksheet.getCharts().get(0);
chart.getCategoryAxis().getTickLabels().setDirectionType(ChartTextDirectionType.HORIZONTAL);
// Output the file
workbook.save(outputDir + "outputChangeTickLabelDirection.xlsx");