ブックおよびワークシートにスコープが制限された名前付き範囲を作成する

ワークブックスコープの名前付き範囲を追加する方法

from aspose.cells import Workbook
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
# The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
# Create a new Workbook object
workbook = Workbook()
# Get first worksheet of the workbook
sheet = workbook.worksheets[0]
# Get worksheet's cells collection
cells = sheet.cells
# Create a range of Cells from Cell A1 to C10
workbookScope = cells.create_range("A1", "C10")
# Assign the nsame to workbook scope named range
workbookScope.name = "workbookScope"
# Save the workbook
workbook.save(dataDir + "WorkbookScope.out.xlsx")

ワークシートスコープの名前付き範囲を追加する方法

from aspose.cells import Workbook
# For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
# The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
# Create a new Workbook object
workbook = Workbook()
# Get first worksheet of the workbook
sheet = workbook.worksheets[0]
# Get worksheet's cells collection
cells = sheet.cells
# Create a range of Cells
localRange = cells.create_range("A1", "C10")
# Assign name to range with sheet raference
localRange.name = "Sheet1!local"
# Save the workbook
workbook.save(dataDir + "ouput.out.xls")

高度なトピック