Creating a Named Range

Creating a Named Range

To create a named range:

  1. Set up the worksheet:
    1. Instantiate an Application object. (VSTO only.)
    2. Add a Workbook.
    3. Get the first sheet.
  2. Create a named range:
    1. Define a range.
    2. Name the range.
  3. Save the file.

The code examples below show how to perform these steps using VSTO with either C# or Visual Basic. The code examples that follow show how to do the same thing using Aspose.Cells for .NET, again with either C# or Visual Basic.

Creating a Named Range with VSTO



using Microsoft.VisualStudio.Tools.Applications.Runtime;

using Excel = Microsoft.Office.Interop.Excel;

using Office = Microsoft.Office.Core;

using System.Reflection;


//Create Excel Object

Excel.ApplicationClass xl = new Excel.ApplicationClass();

//Create a new Workbook

Excel.Workbook wb = xl.Workbooks.Add(Missing.Value);

//Get Worksheets Collection

Excel.Sheets xlsheets = wb.Sheets;

//Select the first sheet

Excel.Worksheet excelWorksheet = (Excel.Worksheet)xlsheets[1];

//Select a range of cells

Excel.Range range = (Excel.Range)excelWorksheet.get_Range("A1:B4", Type.Missing);

//Add Name to Range

range.Name = "Test_Range";

//Put data in range cells

foreach (Excel.Range cell in range.Cells)


    cell.set_Value(Missing.Value, "Test");


//Save New Workbook


//Quit Excel Object


Creating a Named Range with Aspose.Cells for .NET



using Aspose.Cells;


//Instantiating a Workbook object

Workbook workbook = new Workbook();

//Accessing the first worksheet in the Excel file

Worksheet worksheet = workbook.Worksheets[0];

//Creating a named range

Range range = worksheet.Cells.CreateRange("A1", "B4");

//Setting the name of the named range

range.Name = "Test_Range";

for (int row = 0; row < range.RowCount; row++)


    for (int column = 0; column < range.ColumnCount; column++)


        range[row, column].PutValue("Test");



//Saving the modified Excel file in default (that is Excel 2003) format