在VSTO和Aspose.Cells中创建命名范围
Contents
[
Hide
]
要创建一个命名范围:
- 设置工作表:
- 实例化一个应用程序对象。(仅限于VSTO)
- 添加一个工作簿。
- 获取第一个工作表。
- 创建一个命名范围:
- 定义一个范围。
- 给范围命名。
- 保存文件。
下面的代码示例显示了如何使用VSTO和C#执行这些步骤。接下来的代码示例展示了如何使用Aspose.Cells for .NET再次使用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");