إنشاء نطاقات مسماة لمصنف العمل وورقة العمل

إضافة نطاق مسمى بنطاق سجل العمل

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

إضافة نطاق مسمى بنطاق ورق العمل

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

مواضيع متقدمة