Click or drag to resize

IListObjectColumn Interface

Represents a column in the table.

Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
public interface IListObjectColumn

The IListObjectColumn type exposes the following members.

Properties
Name Description
Public property Code example CalculatedFormula
Gets or sets calculated formula value.
Examples
The following code illustrates how to set a formula to third column to hold the sum of first and second column's data:
Copy 
<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>//Total row</para><para>table1.ShowTotals = true;</para><para>table1.Columns[0].TotalsRowLabel = "Total";</para><para>table1.Columns[1].TotalsCalculation = ExcelTotalsCalculation.Sum;</para><para>table1.Columns[2].TotalsCalculation = ExcelTotalsCalculation.Sum;</para><para>//Save to file</para><para>workbook.SaveToFile("Table.xlsx");</para>
Public property Code example Id
Gets column id of current column. Read-only.
Examples
The following code illustrates how create table using the data in the range "A1:C6" and print first column's name,id and index:
Copy 
<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>//Print Column Name, ID, Index</para><para>Console.WriteLine("Column Name " + table1.Columns[0].Name);</para><para>Console.WriteLine("Column ID " + table1.Columns[0].Id);</para><para>Console.WriteLine("Column Index " + table1.Columns[0].Index);</para><para>//Save to file</para><para>workbook.SaveToFile("Table.xlsx");</para>
Public property Code example Index
Gets column index.
Examples
The following code illustrates how create table using the data in the range "A1:C6" and print first column's name,id and index:
Copy 
<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>//Print Column Name, ID, Index</para><para>Console.WriteLine("Column Name " + table1.Columns[0].Name);</para><para>Console.WriteLine("Column ID " + table1.Columns[0].Id);</para><para>Console.WriteLine("Column Index " + table1.Columns[0].Index);</para><para>//Save to file</para><para>workbook.SaveToFile("Table.xlsx");</para>
Public property Code example Name
Gets or sets name of the column.
Examples
The following code illustrates how create table using the data in the range "A1:C6" and print first column's name,id and index:
Copy 
<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>//Print Column Name, ID, Index</para><para>Console.WriteLine("Column Name " + table1.Columns[0].Name);</para><para>Console.WriteLine("Column ID " + table1.Columns[0].Id);</para><para>Console.WriteLine("Column Index " + table1.Columns[0].Index);</para><para>//Save to file</para><para>workbook.SaveToFile("Table.xlsx");</para>
Public property Code example TotalsCalculation
Gets or sets function used for totals calculation.
Examples
The following code illustrates how to set IListObject.ShowTotals to "True" to enable totals and set ExcelTotalsCalculation.Sum for second and third columns to get sum of values in the respective columns:
Copy 
<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>//Total row</para><para>table1.ShowTotals = true;</para><para>table1.Columns[0].TotalsRowLabel = "Total";</para><para>table1.Columns[1].TotalsCalculation = ExcelTotalsCalculation.Sum;</para><para>table1.Columns[2].TotalsCalculation = ExcelTotalsCalculation.Sum;</para><para>//Save to file</para><para>workbook.SaveToFile("Table.xlsx");</para>
Public property Code example TotalsRowLabel
Gets or sets label of the totals row.
Examples
The following code illustrates how to set a string "Total" to the first column's TotalsRowLabel property to indicate that it's adjacent cell holds sum of the values of it's column:
Copy 
<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>//Total row</para><para>table1.ShowTotals = true;</para><para>table1.Columns[0].TotalsRowLabel = "Total";</para><para>table1.Columns[1].TotalsCalculation = ExcelTotalsCalculation.Sum;</para><para>table1.Columns[2].TotalsCalculation = ExcelTotalsCalculation.Sum;</para><para>//Save to file</para><para>workbook.SaveToFile("Table.xlsx");</para>
Top
See Also