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.v24.2.Core.dll
NuGet Package: DevExpress.Printing.Core
#Declaration
XlTableReference GetReference(
XlTablePart part,
string firstColumnName,
string lastColumnName
)
#Parameters
Name | Type | Description |
---|---|---|
part | Xl |
An Xl |
first |
String | A string that is the name of the column specifying the left bound of the referenced table range. |
last |
String | A string that is the name of the column specifying the right bound of the referenced table range. |
#Returns
Type | Description |
---|---|
Xl |
An Xl |
#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).