Class ColumnCollection
Represents a collection of columns in a sheet
Inheritance
System.Object
ColumnCollection
Assembly: DRIT.Spreadsheet.dll
Syntax
public class ColumnCollection : INotifyCollectionChanged
Properties
Item[Int32]
Declaration
public Column this[int index] { get; }
Parameters
| Type |
Name |
Description |
| System.Int32 |
index |
|
Property Value
Item[String]
Declaration
public Column this[string label] { get; }
Parameters
| Type |
Name |
Description |
| System.String |
label |
|
Property Value
Width
Sets the Width of all columns on the worksheet.
TODO Remove Reset to default width.
Declaration
public double Width { set; }
Property Value
| Type |
Description |
| System.Double |
|
Methods
Autofit()
Autofit all columns on a worksheet.
Declaration
Delete(Int32)
Declaration
public void Delete(int index)
Parameters
| Type |
Name |
Description |
| System.Int32 |
index |
|
GetAllColumns()
Declaration
public IEnumerable<Column> GetAllColumns()
Returns
| Type |
Description |
| IEnumerable<Column> |
|
GetColumnIndexAtXPixels(Double)
Declaration
public int GetColumnIndexAtXPixels(double y)
Parameters
| Type |
Name |
Description |
| System.Double |
y |
|
Returns
| Type |
Description |
| System.Int32 |
|
GetModifiedColumns()
Declaration
public IEnumerable<Column> GetModifiedColumns()
Returns
| Type |
Description |
| IEnumerable<Column> |
|
Group(Int32, Int32, Boolean)
Declaration
public void Group(int fromIndex, int toIndex, bool collapse)
Parameters
| Type |
Name |
Description |
| System.Int32 |
fromIndex |
|
| System.Int32 |
toIndex |
|
| System.Boolean |
collapse |
|
Hide(Int32, Int32)
Declaration
public void Hide(int fromIndex, int toIndex)
Parameters
| Type |
Name |
Description |
| System.Int32 |
fromIndex |
|
| System.Int32 |
toIndex |
|
Insert(Int32)
Declaration
public void Insert(int index)
Parameters
| Type |
Name |
Description |
| System.Int32 |
index |
|
SetWidthCharacters(Int32, Int32, Double)
Declaration
public void SetWidthCharacters(int fromIndex, int toIndex, double width)
Parameters
| Type |
Name |
Description |
| System.Int32 |
fromIndex |
|
| System.Int32 |
toIndex |
|
| System.Double |
width |
|
SetWidthCharacters(String, String, Double)
Declaration
public void SetWidthCharacters(string fromLabel, string toLabel, double width)
Parameters
| Type |
Name |
Description |
| System.String |
fromLabel |
|
| System.String |
toLabel |
|
| System.Double |
width |
|
Ungroup(Int32, Int32)
Declaration
public void Ungroup(int fromIndex, int toIndex)
Parameters
| Type |
Name |
Description |
| System.Int32 |
fromIndex |
|
| System.Int32 |
toIndex |
|
Events
CollectionChanged
Declaration
public event NotifyCollectionChangedEventHandler CollectionChanged
Event Type
| Type |
Description |
| NotifyCollectionChangedEventHandler |
|