IXlTable.GetReference(XlTablePart, String, String) Method
Returns a reference to the specified part of the table bounded by the specified columns.
Namespace: DevExpress.Export.Xl
Assembly: DevExpress.Printing.v23.2.Core.dll
NuGet Package: DevExpress.Printing.Core
Declaration
XlTableReference GetReference(
XlTablePart part,
string firstColumnName,
string lastColumnName
)Parameters
| Name | Type | Description |
|---|---|---|
| part | XlTablePart | An XlTablePart enumeration member that specifies the part of the table to use in the reference. |
| firstColumnName | String | A string that is the name of the column specifying the left bound of the referenced table range. |
| lastColumnName | String | A string that is the name of the column specifying the right bound of the referenced table range. |
Returns
| Type | Description |
|---|---|
| XlTableReference | An XlTableReference object that specifies the created reference. |
Remarks
Use this method to create a reference to a specific portion of the table between two columns, including these columns.
For example, the following code creates a reference to the totals of the “Q1” through “Q4” columns, which is the cell range B6:E6 (see the image below the code snippet).
