Page History

An Area object  object represents a rectangular set of cells. To create an Area object, call one of the following methods:

• Code Block[Worksheet.CreateArea(Int32, Int32, Int32, Int32)] - This method takes the 0-based indexes of the area's first row and column, and the number of rows and columns to include in the area. Code Block[
• Worksheet.CreateArea(String)] - This method takes a formula representing the area, for example, "=A1:G10". The formula is relative to the current worksheet.
• Code Block[Worksheet.CreateAreaOfColumns(Int32, Int32)] This method creates a range containing one rectangular area. ObsoleteThis method has been deprecated in favor of using Worksheet.GetColumnProperties(Int32) to get  - Get and edit column properties. Code Block[
• Worksheet.CreateAreaOfRows(Int32, Int32)] This method creates a range containing one rectangular area. ObsoleteThis method has been deprecated in favor of using Worksheet.GetRowProperties(Int32) to get - Get and edit row properties.

A Range is  is a collection of areas. The areas in a range may be non-adjacent, and a range can include areas in different worksheets. To create a Range (without a name), call one of the following methods:

• Code Block[Workbook.CreateRange(String)] - This method takes a formula representing the range, for example "=Sheet1\!A1:G10" defines a range containing one area and "=Sheet1\!B$12:$H$21 Sheet1\!$F$18:$K$29 Sheet1\!D$16:$M$21" defines a range containing three areas. The formula must be three-dimensional (i.e., it must specify the sheet or sheets).
• Code Block[Workbook.CreateRange(Area())] - This method takes an array of Area objects representing the range. Code Block[
• Worksheet.CreateRange(String)] - This method takes a formula representing the range, for example "=Sheet1\!A1:G10" defines a range containing one area and "=Sheet1\!B$12:$H$21 Sheet1\!$F$18:$K$29 Sheet1\!D$16:$M$21" defines a range containing three areas. The formula must be three-dimensional (i.e., it must specify the sheet or sheets).

A NamedRange is  is stored in ExcelWriter's NamedRanges collections (Workbook.NamedRanges and Worksheet.NamedRanges) and is accessible after the workbook is saved. In Excel, named ranges are listed in the name box above the top-left corner of the worksheet. !namedrange.jpg!
\

Image Added

To create a named range, call one of the following methods:

• Code Block[

  Workbook.CreateNamedRange(String,

  String)

  ] This

  - This method takes a formula representing the range, for example "=Sheet1\!A1:G10", and a name for the range. The formula must be three-dimensional (i.e., it must specify the sheet or sheets).

• Code Block[

  Workbook.CreateNamedRange(Area(),

  String)

  ] This

  - This method takes an array of [Area] objects representing the range and a name for the range.

• Code Block[

  Worksheet.CreateNamedRange(Int32,

  Int32,

  Int32,

  Int32,

  String)

  ] This

  - This method returns a named range that contains one rectangular area.

  Code Block[

• Worksheet.CreateNamedRange(String,

  String)

  ] This

  - This method takes a formula representing the range, for example "=Sheet1\!A1:G10", and a name for the range. The formula must be three-dimensional (i.e., it must specify the sheet or sheets).

Importing Data to an Area

You can use an area as a set of target cells for imported data. The Area object's ImportData method allows you to import a block of data from a rectangular array or from an ADO.NET DataTable, DataView, or DataReader. To import data to an area:

1. Create an area in a worksheet.

   Code Block
   c#	c#	ExcelApplication xla = new ExcelApplication(); Workbook wb = xla.Create(); Worksheet ws = wb.Worksheets[0]; Area targetArea = ws.CreateArea(4, 4, 15, 6);

2. Get a rectangular array, DataView, DataReader, or - as in the following example - DataTable to use as the data source.

   Code Block
   // ADO.NET code to get a DataTable from a query
   Code Block
   c#	c#	DataTable employeeDt = new DataTable(); using(SqlConnection conn = new SqlConnection(connString)) { string employeeSQL = "SELECT FirstName + ' ' + LastName As Name " +      "FROM Employee"; SqlCommand cmdEmployee = new SqlCommand(employeeSQL, conn); SqlDataAdapter adptEmployee = new SqlDataAdapter(cmdEmployee); adptEmployee.Fill(employeeDt); }

3. Call ImportData to import the data. The method returns a new area containing the imported values.

   Code Block
   c#	c#	importedValues = targetArea.ImportData(employeeDt);

For more information, see Importing Data.

Applying Formatting to Areas and Ranges

Defined styles can be assigned to cells, rows, columns, areas, and ranges. To assign a style to a range or area:

1. Create a style.

   Code Block
   c#	c#	ExcelApplication xla = new ExcelApplication(); Workbook wb = xla.Create(); Worksheet ws = wb.Worksheets[0]; Style styleTotalRow = wb.CreateStyle(); styleTotalRow.NumberFormat = "$#.##0"; styleTotalRow.Font.Italic = true; styleTotalRow.Font.Bold = true;

2. # Define an area or range, for example:

   Code Block
   c#	c#	Area areaTotalRow = ws.CreateArea(24, 0, 1, 3);

3. Set or apply the style.

   Code Block
   c#	c#	areaTotalRow.Style = styleTotalRow;

For more information on setting and applying styles, see Styles.

...