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

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

VSTO

  //Create Excel Object
            Excel.Application xl = Application;

            //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
            wb.SaveCopyAs("Test_Range.xls");

            //Quit Excel Object
            xl.Quit();


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
            workbook.Save("Test_Range.xls");



Download

Last edited Jan 1, 2014 at 7:19 AM by asposemarketplace, version 3