创建工作簿（全局）和工作表范围的命名区域

Microsoft Excel 允许用户定义具有两种不同范围（工作簿（也称为全局范围）和工作表）的命名范围。

• 具有工作簿范围的命名范围可以通过简单地使用其名称从工作簿内的任何工作表中访问。
• 具有工作表范围的命名范围是通过在其创建的特定工作表的引用中访问的。

Aspose.Cells 提供了与 Microsoft Excel 相同的功能，用于添加工作簿和工作表范围的命名范围。创建工作表范围的命名范围时，应使用工作表引用来将其指定为工作表范围的命名范围。

以下代码示例展示了如何通过使用 Range 类来创建工作簿和工作表范围的名称区域。

添加具有工作簿范围的命名区域

// 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(AddNamedRangeWithWorkbookScope.class);
// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Get Worksheets collection
WorksheetCollection worksheets = workbook.getWorksheets();

// Accessing the first worksheet in the Excel file
Worksheet sheet = worksheets.get(0);

// Get worksheet Cells collection
Cells cells = sheet.getCells();

// Creating a workbook scope named range
Range namedRange = cells.createRange("A1", "C10");
namedRange.setName("workbookScope");

// Saving the modified Excel file in default format
workbook.save(dataDir + "output.xls");

使用工作表范围添加命名范围

// 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(AddNamedRangeWithWorkbookScope.class);
// Instantiating a Workbook object
Workbook workbook = new Workbook();

// Get Worksheets collection
WorksheetCollection worksheets = workbook.getWorksheets();

// Accessing the first worksheet in the Excel file
Worksheet sheet = worksheets.get(0);

// Get worksheet Cells collection
Cells cells = sheet.getCells();

// Creating a workbook scope named range
Range namedRange = cells.createRange("A1", "C10");
namedRange.setName("Sheet1!local");

// Saving the modified Excel file in default format
workbook.save(dataDir + "output.xls");