创建联合范围

创建联合范围

Aspose.Cells 提供使用 WorksheetCollection.CreateUnionRange 方法创建联合区域的功能。WorksheetCollection.CreateUnionRange 方法接受两个参数，即要创建联合范围的地址和工作表的索引。WorksheetCollection.CreateUnionRange 方法返回一个 UnionRange 对象。

下面的代码片段演示了如何使用 WorksheetCollection.CreateUnionRange 方法创建联合区域。代码生成的输出文件附在此供参考。

• 输出文件

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