Click or drag to resize

IListObject Location Property

Gets or sets list object's location.
Examples
The following code illustrates how table range can be set and accessed:
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>workbook.LoadFromFile("Sample.xlsx");</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Create table</para><para>IListObject table1 = worksheet.ListObjects.Create("Table1", worksheet["A1:C6"]);</para><para>//Set Table Range</para><para>table1.Location = worksheet.Range["A1:C7"];</para><para>//Get Table Range</para><para>Console.WriteLine(table1.Location.RangeAddressLocal.ToString());</para><para>//Save to file</para><para>workbook.SaveToFile("Table.xlsx");</para>

Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
IXLSRange Location { get; set; }

Property Value

Type: IXLSRange
See Also