创建工作簿和工作表范围命名范围
Contents
[
Hide
]
Microsoft Excel 允许用户定义具有两种不同范围(工作簿(也称为全局范围)和工作表)的命名范围。
- 具有工作簿范围的命名范围可以通过简单地使用其名称从工作簿内的任何工作表中访问。
- 具有工作表范围的命名范围是通过在其创建的特定工作表的引用中访问的。
Aspose.Cells 提供了与 Microsoft Excel 相同的功能,用于添加工作簿和工作表范围的命名范围。创建工作表范围的命名范围时,应使用工作表引用来将其指定为工作表范围的命名范围。
使用工作簿范围添加命名范围
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-.NET | |
// The path to the documents directory. | |
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
// Create a new Workbook object | |
Workbook workbook = new Workbook(); | |
// Get first worksheet of the workbook | |
Worksheet sheet = workbook.Worksheets[0]; | |
// Get worksheet's cells collection | |
Cells cells = sheet.Cells; | |
// Create a range of Cells from Cell A1 to C10 | |
Range workbookScope = cells.CreateRange("A1", "C10"); | |
// Assign the nsame to workbook scope named range | |
workbookScope.Name = "workbookScope"; | |
// Save the workbook | |
workbook.Save(dataDir+ "WorkbookScope.out.xlsx"); |
使用工作表范围添加命名范围
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-.NET | |
// The path to the documents directory. | |
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType); | |
// Create a new Workbook object | |
Workbook workbook = new Workbook(); | |
// Get first worksheet of the workbook | |
Worksheet sheet = workbook.Worksheets[0]; | |
// Get worksheet's cells collection | |
Cells cells = sheet.Cells; | |
// Create a range of Cells | |
Range localRange = cells.CreateRange("A1", "C10"); | |
// Assign name to range with sheet raference | |
localRange.Name = "Sheet1!local"; | |
// Save the workbook | |
workbook.Save(dataDir+ "ouput.out.xls"); |