diff --git a/ClosedXML/ClosedXML/ClosedXML/ClosedXML.csproj b/ClosedXML/ClosedXML/ClosedXML/ClosedXML.csproj index 7e6cd49..3e96499 100644 --- a/ClosedXML/ClosedXML/ClosedXML/ClosedXML.csproj +++ b/ClosedXML/ClosedXML/ClosedXML/ClosedXML.csproj @@ -34,6 +34,8 @@ TRACE prompt 4 + + @@ -49,7 +51,9 @@ + + diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/IXLCell.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/IXLCell.cs index 52651bd..99c5a3e 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/IXLCell.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/IXLCell.cs @@ -10,20 +10,106 @@ public interface IXLCell: IXLStylized { + /// + /// Gets or sets the cell's value. To get a strongly typed object use the method GetValue<T>. + /// If the object is an IEnumerable ClosedXML will copy the collection's data into a table starting from this cell. + /// If the object is a range ClosedXML will copy the range starting from this cell. + /// Setting the value to an object (not IEnumerable/range) will call the object's ToString() method. + /// ClosedXML will try to translate it to the corresponding type, if it can't then the value will be left as a string. + /// + /// + /// The object containing the value(s) to set. + /// Object Value { get; set; } + + /// Gets this cell's address, relative to the worksheet. + /// The cell's address. IXLAddress Address { get; } + + /// + /// Gets or sets the type of this cell's data. + /// Changing the data type will cause ClosedXML to covert the current value to the new data type. + /// An exception will be thrown if the current value cannot be converted to the new data type. + /// + /// + /// The type of the cell's data. + /// + /// XLCellValues DataType { get; set; } + + /// + /// Gets the cell's value converted to the T type. + /// ClosedXML will try to covert the current value to the T type. + /// An exception will be thrown if the current value cannot be converted to the T type. + /// + /// The return type. + /// T GetValue(); + + /// + /// Gets the cell's value converted to a String. + /// String GetString(); + + /// + /// Gets the cell's value formatted depending on the cell's data type and style. + /// String GetFormattedString(); + + /// + /// Gets the cell's value converted to Double. + /// ClosedXML will try to covert the current value to Double. + /// An exception will be thrown if the current value cannot be converted to Double. + /// Double GetDouble(); + + /// + /// Gets the cell's value converted to Boolean. + /// ClosedXML will try to covert the current value to Boolean. + /// An exception will be thrown if the current value cannot be converted to Boolean. + /// Boolean GetBoolean(); + + /// + /// Gets the cell's value converted to DateTime. + /// ClosedXML will try to covert the current value to DateTime. + /// An exception will be thrown if the current value cannot be converted to DateTime. + /// DateTime GetDateTime(); + + /// + /// Gets the cell's value converted to TimeSpan. + /// ClosedXML will try to covert the current value to TimeSpan. + /// An exception will be thrown if the current value cannot be converted to TimeSpan. + /// TimeSpan GetTimeSpan(); + + /// + /// Clears the contents of this cell (including styles). + /// void Clear(); + + /// + /// Deletes the current cell and shifts the surrounding cells according to the shiftDeleteCells parameter. + /// + /// How to shift the surrounding cells. void Delete(XLShiftDeletedCells shiftDeleteCells); + + /// + /// Gets or sets the cell's formula with A1 references. + /// + /// The formula with A1 references. String FormulaA1 { get; set; } + + /// + /// Gets or sets the cell's formula with R1C1 references. + /// + /// The formula with R1C1 references. String FormulaR1C1 { get; set; } + + /// + /// Returns this cell as an IXLRange. + /// IXLRange AsRange(); } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/IXLCells.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/IXLCells.cs new file mode 100644 index 0000000..e36b7ce --- /dev/null +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/IXLCells.cs @@ -0,0 +1,12 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; + +namespace ClosedXML.Excel +{ + public interface IXLCells : IEnumerable, IXLStylized + { + + } +} diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCell.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCell.cs index 95523d7..ce5926a 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCell.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCell.cs @@ -24,7 +24,13 @@ public IXLAddress Address { get; private set; } public String InnerText { - get { return cellValue; } + get + { + if (StringExtensions.IsNullOrWhiteSpace(cellValue)) + return FormulaA1; + else + return cellValue; + } } public IXLRange AsRange() { diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCells.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCells.cs new file mode 100644 index 0000000..0220ad7 --- /dev/null +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Cells/XLCells.cs @@ -0,0 +1,98 @@ +using System; +using System.Collections.Generic; +using System.Linq; +using System.Text; + +namespace ClosedXML.Excel +{ + internal class XLCells: IXLCells + { + private Boolean entireWorksheet; + private XLWorksheet worksheet; + public XLCells(XLWorksheet worksheet, Boolean entireWorksheet = false) + { + this.worksheet = worksheet; + this.entireWorksheet = entireWorksheet; + Style = worksheet.Style; + } + + private List cells = new List(); + public IEnumerator GetEnumerator() + { + var retList = new List(); + cells.ForEach(c => retList.Add(c)); + return retList.GetEnumerator(); + } + + System.Collections.IEnumerator System.Collections.IEnumerable.GetEnumerator() + { + return GetEnumerator(); + } + public void Add(XLCell cell) + { + cells.Add(cell); + } + public void AddRange(IEnumerable cellsToAdd) + { + cells.AddRange(cellsToAdd); + } + + #region IXLStylized Members + + private IXLStyle style; + public IXLStyle Style + { + get + { + return style; + } + set + { + style = new XLStyle(this, value); + + if (entireWorksheet) + { + worksheet.Style = value; + } + else + { + var maxRow = 0; + if (worksheet.Internals.RowsCollection.Count > 0) + maxRow = worksheet.Internals.RowsCollection.Keys.Max(); + foreach (var c in cells) + { + c.Style = value; + } + } + } + } + + public IEnumerable Styles + { + get + { + UpdatingStyle = true; + yield return style; + if (entireWorksheet) + { + yield return worksheet.Style; + } + else + { + var maxRow = 0; + if (worksheet.Internals.RowsCollection.Count > 0) + maxRow = worksheet.Internals.RowsCollection.Keys.Max(); + foreach (var c in cells) + { + yield return c.Style; + } + } + UpdatingStyle = false; + } + } + + public Boolean UpdatingStyle { get; set; } + + #endregion + } +} diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/IXLColumn.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/IXLColumn.cs index a7dd91f..7229dad 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/IXLColumn.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/IXLColumn.cs @@ -7,27 +7,145 @@ { public interface IXLColumn : IXLRangeBase { + /// + /// Gets or sets the width of this column. + /// + /// + /// The width of this column. + /// Double Width { get; set; } + + /// + /// Deletes this column and shifts the columns at the right of this one accordingly. + /// void Delete(); + + /// + /// Gets this column's number + /// Int32 ColumnNumber(); + + /// + /// Gets this column's letter + /// String ColumnLetter(); + + /// + /// Inserts X number of columns at the right of this one. + /// All columns at the right will be shifted accordingly. + /// + /// The number of columns to insert. void InsertColumnsAfter(Int32 numberOfColumns); + + /// + /// Inserts X number of columns at the left of this one. + /// This column and all at the right will be shifted accordingly. + /// + /// The number of columns to insert. void InsertColumnsBefore(Int32 numberOfColumns); + + /// + /// Clears the contents of this column (including styles). + /// void Clear(); - IXLCell Cell(int row); + /// + /// Gets the cell in the specified row. + /// + /// The cell's row. + IXLCell Cell(Int32 rowNumber); + + /// + /// Returns the specified group of cells, separated by commas. + /// e.g. Cells("1"), Cells("1:5"), Cells("1,3:5") + /// + /// The column cells to return. + IXLCells Cells(String cellsInColumn); + + /// + /// Returns the specified group of cells. + /// + /// The first row in the group of cells to return. + /// The last row in the group of cells to return. + IXLCells Cells(Int32 firstRow, Int32 lastRow); + + /// + /// Converts this column to a range object. + /// + IXLRange AsRange(); + + + /// + /// Adjusts the width of the column based on its contents. + /// void AdjustToContents(); + + + /// + /// Hides this column. + /// void Hide(); + + /// Unhides this column. void Unhide(); + + /// + /// Gets a value indicating whether this column is hidden or not. + /// + /// + /// true if this column is hidden; otherwise, false. + /// Boolean IsHidden { get; } + + /// + /// Gets or sets the outline level of this column. + /// + /// + /// The outline level of this column. + /// Int32 OutlineLevel { get; set; } + + /// + /// Adds this column to the next outline level (Increments the outline level for this column by 1). + /// void Group(); + + /// + /// Adds this column to the next outline level (Increments the outline level for this column by 1). + /// + /// If set to true the column will be shown collapsed. void Group(Boolean collapse); + + /// + /// Sets outline level for this column. + /// + /// The outline level. void Group(Int32 outlineLevel); + + /// + /// Sets outline level for this column. + /// + /// The outline level. + /// If set to true the column will be shown collapsed. void Group(Int32 outlineLevel, Boolean collapse); + + /// + /// Adds this column to the previous outline level (decrements the outline level for this column by 1). + /// void Ungroup(); + + /// + /// Adds this column to the previous outline level (decrements the outline level for this column by 1). + /// + /// If set to true it will remove this column from all outline levels. void Ungroup(Boolean fromAll); + + /// + /// Show this column as collapsed. + /// void Collapse(); + + /// Expands this column (if it's collapsed). void Expand(); } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/IXLColumns.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/IXLColumns.cs index 380ee97..8ad4ed8 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/IXLColumns.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/IXLColumns.cs @@ -7,18 +7,89 @@ { public interface IXLColumns: IEnumerable, IXLStylized { + /// + /// Sets the width of all columns. + /// + /// + /// The width of all columns. + /// Double Width { set; } + + /// + /// Deletes all columns and shifts the columns at the right of them accordingly. + /// void Delete(); + + /// + /// Adjusts the width of all columns based on its contents. + /// void AdjustToContents(); + + /// + /// Hides all columns. + /// void Hide(); + + /// Unhides all columns. void Unhide(); + + /// + /// Increments the outline level of all columns by 1. + /// void Group(); + + /// + /// Increments the outline level of all columns by 1. + /// + /// If set to true the columns will be shown collapsed. void Group(Boolean collapse); + + /// + /// Sets outline level for all columns. + /// + /// The outline level. void Group(Int32 outlineLevel); - void Group(Int32 outlineLevel, Boolean collapse = false); + + /// + /// Sets outline level for all columns. + /// + /// The outline level. + /// If set to true the columns will be shown collapsed. + void Group(Int32 outlineLevel, Boolean collapse); + + /// + /// Decrements the outline level of all columns by 1. + /// void Ungroup(); - void Ungroup(Boolean fromAll = false); + + /// + /// Decrements the outline level of all columns by 1. + /// + /// If set to true it will remove the columns from all outline levels. + void Ungroup(Boolean fromAll); + + /// + /// Show all columns as collapsed. + /// void Collapse(); + + /// Expands all columns (if they're collapsed). void Expand(); + + /// + /// Returns the collection of cells. + /// + IXLCells Cells(); + + /// + /// Returns the collection of cells that have a value. + /// + IXLCells CellsUsed(); + + /// + /// Returns the collection of cells that have a value. + /// + /// if set to true will return all cells with a value or a style different than the default. + IXLCells CellsUsed(Boolean includeStyles); } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/XLColumn.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/XLColumn.cs index 3bf8ec8..8ff1c68 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/XLColumn.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/XLColumn.cs @@ -91,9 +91,25 @@ this.Style = Worksheet.Style; } - public IXLCell Cell(int row) + public IXLCell Cell(Int32 rowNumber) { - return base.Cell(row, 1); + return base.Cell(rowNumber, 1); + } + + public IXLCells Cells(String cellsInColumn) + { + var retVal = new XLCells(Worksheet); + var rangePairs = cellsInColumn.Split(','); + foreach (var pair in rangePairs) + { + retVal.AddRange(Range(pair).Cells()); + } + return retVal; + } + + public IXLCells Cells(Int32 firstRow, Int32 lastRow) + { + return Cells(firstRow + ":" + lastRow); } #endregion @@ -119,19 +135,23 @@ else { style = new XLStyle(this, value); - - foreach (var c in Worksheet.Internals.CellsCollection.Values.Where(c => c.Address.ColumnNumber == this.ColumnNumber())) + Int32 thisCo = this.ColumnNumber(); + foreach (var c in Worksheet.Internals.CellsCollection.Values.Where(c => c.Address.ColumnNumber == thisCo)) { c.Style = value; } - var maxRow = 0; + Int32 maxRow = 0; + Int32 minRow = 1; if (Worksheet.Internals.RowsCollection.Count > 0) - maxRow = Worksheet.Internals.RowsCollection.Keys.Max(); - - for (var ro = 1; ro <= maxRow; ro++) { - Worksheet.Cell(ro, this.ColumnNumber()).Style = value; + maxRow = Worksheet.Internals.RowsCollection.Keys.Max(); + minRow = Worksheet.Internals.RowsCollection.Keys.Min(); + } + + for (Int32 ro = minRow; ro <= maxRow; ro++) + { + Worksheet.Cell(ro, thisCo).Style = value; } } } @@ -199,6 +219,28 @@ { return Range(1, 1, XLWorksheet.MaxNumberOfRows, 1); } + public override IXLRange Range(String rangeAddressStr) + { + String rangeAddressToUse; + if (rangeAddressStr.Contains(":")) + { + String[] arrRange = rangeAddressStr.Split(':'); + var firstPart = arrRange[0]; + var secondPart = arrRange[1]; + rangeAddressToUse = FixColumnAddress(firstPart) + ":" + FixColumnAddress(secondPart); + } + else + { + rangeAddressToUse = FixColumnAddress(rangeAddressStr); + } + + var rangeAddress = new XLRangeAddress(rangeAddressToUse); + return Range(rangeAddress); + } + public IXLRangeColumn Range(int firstRow, int lastRow) + { + return Range(firstRow, 1, lastRow, 1).Column(1); + } public void AdjustToContents() { diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/XLColumns.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/XLColumns.cs index 1b15d19..01150e6 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/XLColumns.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Columns/XLColumns.cs @@ -188,5 +188,59 @@ { columns.ForEach(c => c.Expand()); } + + public IXLCells Cells() + { + var cellHash = new HashSet(); + foreach (var container in columns) + { + foreach (var cell in container.Cells()) + { + if (!cellHash.Contains(cell)) + { + cellHash.Add(cell); + } + } + } + var cells = new XLCells(worksheet, entireWorksheet); + cells.AddRange(cellHash); + return (IXLCells)cells; + } + + public IXLCells CellsUsed() + { + var cellHash = new HashSet(); + foreach (var container in columns) + { + foreach (var cell in container.CellsUsed()) + { + if (!cellHash.Contains(cell)) + { + cellHash.Add(cell); + } + } + } + var cells = new XLCells(worksheet, entireWorksheet); + cells.AddRange(cellHash); + return (IXLCells)cells; + } + + public IXLCells CellsUsed(Boolean includeStyles) + { + var cellHash = new HashSet(); + foreach (var container in columns) + { + foreach (var cell in container.CellsUsed(includeStyles)) + { + if (!cellHash.Contains(cell)) + { + cellHash.Add(cell); + } + } + } + var cells = new XLCells(worksheet, entireWorksheet); + cells.AddRange(cellHash); + return (IXLCells)cells; + } } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/IXLWorksheet.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/IXLWorksheet.cs index d0efd04..2181fac 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/IXLWorksheet.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/IXLWorksheet.cs @@ -7,51 +7,228 @@ { public interface IXLWorksheet: IXLRangeBase { + /// + /// Gets or sets the default column width for this worksheet. + /// Double ColumnWidth { get; set; } + /// + /// Gets or sets the default row height for this worksheet. + /// Double RowHeight { get; set; } + /// + /// Gets or sets the name (caption) of this worksheet. + /// String Name { get; set; } + /// + /// Gets or sets the position of the sheet (zero based). + /// When setting the SheetIndex all other sheets' indexes are shifted accordingly. + /// Int32 SheetIndex { get; set; } + /// + /// Gets an object to manipulate the sheet's print options. + /// IXLPageSetup PageSetup { get; } + /// + /// Gets an object to manipulate the Outline levels. + /// IXLOutline Outline { get; } + /// + /// Gets the first row of the worksheet. + /// + IXLRow FirstRow(); + /// + /// Gets the first row of the worksheet that contains a cell with a value. + /// IXLRow FirstRowUsed(); + /// + /// Gets the last row of the worksheet. + /// + IXLRow LastRow(); + /// + /// Gets the last row of the worksheet that contains a cell with a value. + /// IXLRow LastRowUsed(); + /// + /// Gets the first column of the worksheet. + /// + IXLColumn FirstColumn(); + /// + /// Gets the first column of the worksheet that contains a cell with a value. + /// IXLColumn FirstColumnUsed(); + /// + /// Gets the last column of the worksheet. + /// + IXLColumn LastColumn(); + /// + /// Gets the last column of the worksheet that contains a cell with a value. + /// IXLColumn LastColumnUsed(); + /// + /// Gets a collection of all columns in this worksheet. + /// IXLColumns Columns(); + /// + /// Gets a collection of the specified columns in this worksheet, separated by commas. + /// e.g. Columns("G:H"), Columns("10:11,13:14"), Columns("P:Q,S:T"), Columns("V") + /// + /// The columns to return. IXLColumns Columns(String columns); + /// + /// Gets a collection of the specified columns in this worksheet. + /// + /// The first column to return. + /// The last column to return. IXLColumns Columns(String firstColumn, String lastColumn); + /// + /// Gets a collection of the specified columns in this worksheet. + /// + /// The first column to return. + /// The last column to return. IXLColumns Columns(Int32 firstColumn, Int32 lastColumn); + /// + /// Gets a collection of all rows in this worksheet. + /// IXLRows Rows(); + /// + /// Gets a collection of the specified rows in this worksheet, separated by commas. + /// e.g. Rows("4:5"), Rows("7:8,10:11"), Rows("13") + /// + /// The rows to return. IXLRows Rows(String rows); + /// + /// Gets a collection of the specified rows in this worksheet. + /// + /// The first row to return. + /// The last row to return. + /// IXLRows Rows(Int32 firstRow, Int32 lastRow); + /// + /// Gets the specified row of the worksheet. + /// + /// The worksheet's row. IXLRow Row(Int32 row); + /// + /// Gets the specified column of the worksheet. + /// + /// The worksheet's column. IXLColumn Column(Int32 column); + /// + /// Gets the specified column of the worksheet. + /// + /// The worksheet's column. IXLColumn Column(String column); - IXLRange Range(int firstCellRow, int firstCellColumn, int lastCellRow, int lastCellColumn); - + /// + /// Gets the cell at the specified row and column. + /// + /// The cell's row. + /// The cell's column. IXLCell Cell(int row, int column); + /// Gets the cell at the specified address. + /// The cell address in the worksheet. IXLCell Cell(string cellAddressInRange); + /// + /// Gets the cell at the specified row and column. + /// + /// The cell's row. + /// The cell's column. IXLCell Cell(int row, string column); + /// Gets the cell at the specified address. + /// The cell address in the worksheet. IXLCell Cell(IXLAddress cellAddressInRange); + /// + /// Returns the specified range. + /// + /// The range boundaries. + IXLRange Range(IXLRangeAddress rangeAddress); + + /// Returns the specified range. + /// e.g. Range("A1"), Range("A1:C2") + /// The range boundaries. + IXLRange Range(string rangeAddress); + + /// Returns the specified range. + /// The first cell address in the worksheet. + /// The last cell address in the worksheet. + IXLRange Range(string firstCellAddress, string lastCellAddress); + + /// Returns the specified range. + /// The first cell address in the worksheet. + /// The last cell address in the worksheet. + IXLRange Range(IXLAddress firstCellAddress, IXLAddress lastCellAddress); + + /// Returns a collection of ranges, separated by commas. + /// e.g. Ranges("A1"), Ranges("A1:C2"), Ranges("A1:B2,D1:D4") + /// The ranges to return. + IXLRanges Ranges(string ranges); + + /// Returns the specified range. + /// The first cell's row of the range to return. + /// The first cell's column of the range to return. + /// The last cell's row of the range to return. + /// The last cell's column of the range to return. + /// . + IXLRange Range(int firstCellRow, int firstCellColumn, int lastCellRow, int lastCellColumn); + + /// Gets the number of rows in this range. int RowCount(); + + /// Gets the number of columns in this range. int ColumnCount(); + /// + /// Collapses all outlined rows. + /// void CollapseRows(); + /// + /// Collapses all outlined columns. + /// void CollapseColumns(); + /// + /// Expands all outlined rows. + /// void ExpandRows(); + /// + /// Expands all outlined columns. + /// void ExpandColumns(); + /// + /// Collapses the outlined rows of the specified level. + /// + /// The outline level. void CollapseRows(Int32 outlineLevel); + /// + /// Collapses the outlined columns of the specified level. + /// + /// The outline level. void CollapseColumns(Int32 outlineLevel); + /// + /// Expands the outlined rows of the specified level. + /// + /// The outline level. void ExpandRows(Int32 outlineLevel); + /// + /// Expands the outlined columns of the specified level. + /// + /// The outline level. void ExpandColumns(Int32 outlineLevel); + /// + /// Deletes this worksheet. + /// void Delete(); + /// + /// Clears the contents of this worksheet (including styles). + /// void Clear(); + /// + /// Gets an object to manage this worksheet's named ranges. + /// IXLNamedRanges NamedRanges { get; } } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/NamedRanges/IXLNamedRange.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/NamedRanges/IXLNamedRange.cs index 94e1349..2020d9f 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/NamedRanges/IXLNamedRange.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/NamedRanges/IXLNamedRange.cs @@ -7,17 +7,86 @@ { public interface IXLNamedRange { + /// + /// Gets or sets the name of the range. + /// + /// + /// The name of the range. + /// String Name { get; set; } + + /// + /// Gets the ranges associated with this named range. + /// Note: A named range can point to multiple ranges. + /// IXLRanges Ranges { get; } + + /// + /// Gets the single range associated with this named range. + /// An exception will be thrown if there are multiple ranges associated with this named range. + /// IXLRange Range { get; } + + /// + /// Gets or sets the comment for this named range. + /// + /// + /// The comment for this named range. + /// String Comment { get; set; } + + /// + /// Adds the specified range to this named range. + /// Note: A named range can point to multiple ranges. + /// + /// The range address to add. IXLRanges Add(String rangeAddress); + + /// + /// Adds the specified range to this named range. + /// Note: A named range can point to multiple ranges. + /// + /// The range to add. IXLRanges Add(IXLRange range); + + /// + /// Adds the specified ranges to this named range. + /// Note: A named range can point to multiple ranges. + /// + /// The ranges to add. IXLRanges Add(IXLRanges ranges); + + + /// + /// Deletes this named range (not the cells). + /// void Delete(); + + /// + /// Clears the list of ranges associated with this named range. + /// (it does not clear the cells) + /// void Clear(); + + /// + /// Removes the specified range from this named range. + /// Note: A named range can point to multiple ranges. + /// + /// The range address to remove. void Remove(String rangeAddress); + + /// + /// Removes the specified range from this named range. + /// Note: A named range can point to multiple ranges. + /// + /// The range to remove. void Remove(IXLRange range); + + /// + /// Removes the specified ranges from this named range. + /// Note: A named range can point to multiple ranges. + /// + /// The ranges to remove. void Remove(IXLRanges ranges); } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/NamedRanges/IXLNamedRanges.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/NamedRanges/IXLNamedRanges.cs index 24233aa..3d7a1d7 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/NamedRanges/IXLNamedRanges.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/NamedRanges/IXLNamedRanges.cs @@ -7,16 +7,82 @@ { public interface IXLNamedRanges: IEnumerable { + /// + /// Gets the specified named range. + /// + /// Name of the range. IXLNamedRange NamedRange(String rangeName); + + /// + /// Gets the specified named range's index + /// + /// Index of the named range. IXLNamedRange NamedRange(Int32 rangeIndex); + + /// + /// Adds a new named range. + /// + /// Name of the range to add. + /// The range address to add. + /// IXLNamedRange Add(String rangeName, String rangeAddress); + + /// + /// Adds a new named range. + /// + /// Name of the range to add. + /// The range to add. + /// IXLNamedRange Add(String rangeName, IXLRange range); + + /// + /// Adds a new named range. + /// + /// Name of the range to add. + /// The ranges to add. + /// IXLNamedRange Add(String rangeName, IXLRanges ranges); + + /// + /// Adds a new named range. + /// + /// Name of the ranges to add. + /// The range address to add. + /// The comment for the new named range. IXLNamedRange Add(String rangeName, String rangeAddress, String comment); + + /// + /// Adds a new named range. + /// + /// Name of the ranges to add. + /// The range to add. + /// The comment for the new named range. IXLNamedRange Add(String rangeName, IXLRange range, String comment); + + /// + /// Adds a new named range. + /// + /// Name of the ranges to add. + /// The ranges to add. + /// The comment for the new named range. IXLNamedRange Add(String rangeName, IXLRanges ranges, String comment); + + /// + /// Deletes the specified named range (not the cells). + /// + /// Name of the range to delete. void Delete(String rangeName); + + /// + /// Deletes the specified named range's index (not the cells). + /// + /// Index of the named range to delete. void Delete(Int32 rangeIndex); + + + /// + /// Deletes all named ranges (not the cells). + /// void DeleteAll(); } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLHFItem.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLHFItem.cs index 4beabc9..92e08c1 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLHFItem.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLHFItem.cs @@ -16,13 +16,56 @@ public interface IXLHFItem { + /// + /// Gets the text of the specified header/footer occurrence. + /// + /// The occurrence. String GetText(XLHFOccurrence occurrence); + + /// + /// Adds the given text to this header/footer item. + /// + /// The text to add to this header/footer item. void AddText(String text); + + /// + /// Adds the given predefined text to this header/footer item. + /// + /// The predefined text to add to this header/footer item. void AddText(XLHFPredefinedText predefinedText); + + /// + /// Adds the given text to this header/footer item. + /// + /// The text to add to this header/footer item. + /// The occurrence for the text. void AddText(String text, XLHFOccurrence occurrence); + + /// + /// Adds the given predefined text to this header/footer item. + /// + /// The predefined text to add to this header/footer item. + /// The occurrence for the predefined text. void AddText(XLHFPredefinedText predefinedText, XLHFOccurrence occurrence); + + /// + /// Adds the given text to this header/footer item. + /// + /// The text to add to this header/footer item. + /// The occurrence for the text. + /// The font for the text. void AddText(String text, XLHFOccurrence occurrence, IXLFont xlFont); + + /// + /// Adds the given predefined text to this header/footer item. + /// + /// The predefined text to add to this header/footer item. + /// The occurrence for the predefined text. + /// The font for the text. void AddText(XLHFPredefinedText predefinedText, XLHFOccurrence occurrence, IXLFont xlFont); + + /// Clears the text/formats of this header/footer item. + /// The occurrence to clear. void Clear(XLHFOccurrence occurrence = XLHFOccurrence.AllPages); } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLHeaderFooter.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLHeaderFooter.cs index 5dddd14..fc03d5b 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLHeaderFooter.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLHeaderFooter.cs @@ -8,9 +8,25 @@ public enum XLHFMode { OddPagesOnly, OddAndEvenPages, Odd } public interface IXLHeaderFooter { + /// + /// Gets the left header/footer item. + /// IXLHFItem Left { get; } + + /// + /// Gets the middle header/footer item. + /// IXLHFItem Center { get; } + + /// + /// Gets the right header/footer item. + /// IXLHFItem Right { get; } + + /// + /// Gets the text of the specified header/footer occurrence. + /// + /// The occurrence. String GetText(XLHFOccurrence occurrence); } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLMargins.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLMargins.cs index 68e28f6..4c58812 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLMargins.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLMargins.cs @@ -7,11 +7,28 @@ { public interface IXLMargins { + /// Gets or sets the Left margin. + /// The Left margin. Double Left { get; set; } + + /// Gets or sets the Right margin. + /// The Right margin. Double Right { get; set; } + + /// Gets or sets the Top margin. + /// The Top margin. Double Top { get; set; } + + /// Gets or sets the Bottom margin. + /// The Bottom margin. Double Bottom { get; set; } + + /// Gets or sets the Header margin. + /// The Header margin. Double Header { get; set; } + + /// Gets or sets the Footer margin. + /// The Footer margin. Double Footer { get; set; } } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLPageSetup.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLPageSetup.cs index bc9f804..3ad8f3f 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLPageSetup.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLPageSetup.cs @@ -81,47 +81,207 @@ public interface IXLPageSetup { + /// + /// Gets an object to manage the print areas of the worksheet. + /// IXLPrintAreas PrintAreas { get; } + /// + /// Gets the first row that will repeat on the top of the printed pages. + /// Use SetRowsToRepeatAtTop() to set the rows that will be repeated on the top of the printed pages. + /// Int32 FirstRowToRepeatAtTop { get; } + /// + /// Gets the last row that will repeat on the top of the printed pages. + /// Use SetRowsToRepeatAtTop() to set the rows that will be repeated on the top of the printed pages. + /// Int32 LastRowToRepeatAtTop { get; } + /// + /// Sets the rows to repeat on the top of the printed pages. + /// + /// The range of rows to repeat on the top of the printed pages. void SetRowsToRepeatAtTop(String range); + /// + /// Sets the rows to repeat on the top of the printed pages. + /// + /// The first row to repeat at top. + /// The last row to repeat at top. void SetRowsToRepeatAtTop(Int32 firstRowToRepeatAtTop, Int32 lastRowToRepeatAtTop); + + /// Gets the first column to repeat on the left of the printed pages. + /// The first column to repeat on the left of the printed pages. Int32 FirstColumnToRepeatAtLeft { get; } + /// Gets the last column to repeat on the left of the printed pages. + /// The last column to repeat on the left of the printed pages. Int32 LastColumnToRepeatAtLeft { get; } + /// + /// Sets the rows to repeat on the left of the printed pages. + /// + /// The first column to repeat at left. + /// The last column to repeat at left. void SetColumnsToRepeatAtLeft(Int32 firstColumnToRepeatAtLeft, Int32 lastColumnToRepeatAtLeft); + /// + /// Sets the rows to repeat on the left of the printed pages. + /// + /// The range of rows to repeat on the left of the printed pages. void SetColumnsToRepeatAtLeft(String range); + + /// Gets or sets the page orientation for printing. + /// The page orientation. XLPageOrientation PageOrientation { get; set; } + /// + /// Gets or sets the number of pages wide (horizontal) the worksheet will be printed on. + /// If you don't specify the PagesTall, Excel will adjust that value + /// based on the contents of the worksheet and the PagesWide number. + /// Setting this value will override the Scale value. + /// Int32 PagesWide { get; set; } + /// + /// Gets or sets the number of pages tall (vertical) the worksheet will be printed on. + /// If you don't specify the PagesWide, Excel will adjust that value + /// based on the contents of the worksheet and the PagesTall number. + /// Setting this value will override the Scale value. + /// Int32 PagesTall { get; set; } + /// + /// Gets or sets the scale at which the worksheet will be printed. + /// The worksheet will be printed on as many pages as necessary to print at the given scale. + /// Setting this value will override the PagesWide and PagesTall values. + /// Int32 Scale { get; set; } + /// + /// Gets or sets the horizontal dpi for printing the worksheet. + /// Int32 HorizontalDpi { get; set; } + /// + /// Gets or sets the vertical dpi for printing the worksheet. + /// Int32 VerticalDpi { get; set; } + /// + /// Gets or sets the page number that will begin the printout. + /// For example, the first page of your printout could be numbered page 5. + /// Int32 FirstPageNumber { get; set; } + /// + /// Gets or sets a value indicating whether the worksheet will be centered on the page horizontally. + /// + /// + /// true if the worksheet will be centered on the page horizontally; otherwise, false. + /// Boolean CenterHorizontally { get; set; } + /// + /// Gets or sets a value indicating whether the worksheet will be centered on the page vertically. + /// + /// + /// true if the worksheet will be centered on the page vartically; otherwise, false. + /// Boolean CenterVertically { get; set; } + /// + /// Sets the scale at which the worksheet will be printed. This is equivalent to setting the Scale property. + /// The worksheet will be printed on as many pages as necessary to print at the given scale. + /// Setting this value will override the PagesWide and PagesTall values. + /// + /// The scale at which the worksheet will be printed. void AdjustTo(Int32 pctOfNormalSize); + /// + /// Gets or sets the number of pages the worksheet will be printed on. + /// This is equivalent to setting both PagesWide and PagesTall properties. + /// Setting this value will override the Scale value. + /// + /// The pages wide. + /// The pages tall. void FitToPages(Int32 pagesWide, Int32 pagesTall); + /// + /// Gets or sets the size of the paper to print the worksheet. + /// XLPaperSize PaperSize { get; set; } + /// + /// Gets an object to work with the page margins. + /// IXLMargins Margins { get; } + /// + /// Gets an object to work with the page headers. + /// IXLHeaderFooter Header { get; } + /// + /// Gets an object to work with the page footers. + /// IXLHeaderFooter Footer { get; } + /// + /// Gets or sets a value indicating whether Excel will automatically adjust the font size to the scale of the worksheet. + /// + /// + /// true if Excel will automatically adjust the font size to the scale of the worksheet; otherwise, false. + /// Boolean ScaleHFWithDocument { get; set; } + /// + /// Gets or sets a value indicating whether the header and footer margins are aligned with the left and right margins of the worksheet. + /// + /// + /// true if the header and footer margins are aligned with the left and right margins of the worksheet; otherwise, false. + /// Boolean AlignHFWithMargins { get; set; } + /// + /// Gets or sets a value indicating whether the gridlines will be printed. + /// + /// + /// true if the gridlines will be printed; otherwise, false. + /// Boolean ShowGridlines { get; set; } + /// + /// Gets or sets a value indicating whether to show row numbers and column letters/numbers. + /// + /// + /// true to show row numbers and column letters/numbers; otherwise, false. + /// Boolean ShowRowAndColumnHeadings { get; set; } + /// + /// Gets or sets a value indicating whether the worksheet will be printed in black and white. + /// + /// + /// true if the worksheet will be printed in black and white; otherwise, false. + /// Boolean BlackAndWhite { get; set; } + /// + /// Gets or sets a value indicating whether the worksheet will be printed in draft quality. + /// + /// + /// true if the worksheet will be printed in draft quality; otherwise, false. + /// Boolean DraftQuality { get; set; } + /// + /// Gets or sets the page order for printing. + /// XLPageOrderValues PageOrder { get; set; } + /// + /// Gets or sets how the comments will be printed. + /// XLShowCommentsValues ShowComments { get; set; } - + /// + /// Gets a list with the row breaks (for printing). + /// List RowBreaks { get; } + /// + /// Gets a list with the column breaks (for printing). + /// List ColumnBreaks { get; } + /// + /// Adds a horizontal page break after the given row. + /// + /// The row to insert the break. void AddHorizontalPageBreak(Int32 row); + + /// + /// Adds a vertical page break after the given column. + /// + /// The column to insert the break. void AddVerticalPageBreak(Int32 column); + /// + /// Gets or sets how error values will be printed. + /// XLPrintErrorValues PrintErrorValue { get; set; } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLPrintAreas.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLPrintAreas.cs index 2072f00..e72d193 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLPrintAreas.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/PageSetup/IXLPrintAreas.cs @@ -7,10 +7,28 @@ { public interface IXLPrintAreas: IEnumerable { + /// Removes the print areas from the worksheet. void Clear(); + + /// Adds a range to the print areas. + /// The first cell row. + /// The first cell column. + /// The last cell row. + /// The last cell column. void Add(Int32 firstCellRow, Int32 firstCellColumn, Int32 lastCellRow, Int32 lastCellColumn); + + /// Adds a range to the print areas. + /// The range address to add. void Add(String rangeAddress); + + /// Adds a range to the print areas. + /// The first cell address. + /// The last cell address. void Add(String firstCellAddress, String lastCellAddress); + + /// Adds a range to the print areas. + /// The first cell address. + /// The last cell address. void Add(IXLAddress firstCellAddress, IXLAddress lastCellAddress); } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRange.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRange.cs index 72fdb41..4fa7b2b 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRange.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRange.cs @@ -10,45 +10,212 @@ public enum XLTransposeOptions { MoveCells, ReplaceCells } public interface IXLRange: IXLRangeBase { + /// + /// Gets the cell at the specified row and column. + /// The cell address is relative to the parent range. + /// + /// The cell's row. + /// The cell's column. IXLCell Cell(int row, int column); + + /// Gets the cell at the specified address. + /// The cell address is relative to the parent range. + /// The cell address in the parent range. IXLCell Cell(string cellAddressInRange); + + /// + /// Gets the cell at the specified row and column. + /// The cell address is relative to the parent range. + /// + /// The cell's row. + /// The cell's column. IXLCell Cell(int row, string column); + /// Gets the cell at the specified address. + /// The cell address is relative to the parent range. + /// The cell address in the parent range. IXLCell Cell(IXLAddress cellAddressInRange); + /// + /// Gets the specified column of the range. + /// + /// The range column. IXLRangeColumn Column(int column); + /// + /// Gets the specified column of the range. + /// + /// The range column. IXLRangeColumn Column(string column); + /// + /// Gets the first column of the range. + /// IXLRangeColumn FirstColumn(); + /// + /// Gets the first column of the range that contains a cell with a value. + /// IXLRangeColumn FirstColumnUsed(); + /// + /// Gets the last column of the range. + /// IXLRangeColumn LastColumn(); + /// + /// Gets the last column of the range that contains a cell with a value. + /// IXLRangeColumn LastColumnUsed(); + /// + /// Gets a collection of all columns in this range. + /// IXLRangeColumns Columns(); + /// + /// Gets a collection of the specified columns in this range. + /// + /// The first column to return. + /// The last column to return. IXLRangeColumns Columns(int firstColumn, int lastColumn); + /// + /// Gets a collection of the specified columns in this range. + /// + /// The first column to return. + /// The last column to return. IXLRangeColumns Columns(string firstColumn, string lastColumn); + /// + /// Gets a collection of the specified columns in this range, separated by commas. + /// e.g. Columns("G:H"), Columns("10:11,13:14"), Columns("P:Q,S:T"), Columns("V") + /// + /// The columns to return. IXLRangeColumns Columns(string columns); + /// + /// Gets the first row of the range. + /// IXLRangeRow FirstRow(); + /// + /// Gets the first row of the range that contains a cell with a value. + /// IXLRangeRow FirstRowUsed(); + /// + /// Gets the last row of the range. + /// IXLRangeRow LastRow(); + /// + /// Gets the last row of the range that contains a cell with a value. + /// IXLRangeRow LastRowUsed(); + /// + /// Gets the specified row of the range. + /// + /// The range row. IXLRangeRow Row(int row); + /// + /// Gets a collection of all rows in this range. + /// IXLRangeRows Rows(); + /// + /// Gets a collection of the specified rows in this range. + /// + /// The first row to return. + /// The last row to return. + /// IXLRangeRows Rows(int firstRow, int lastRow); + /// + /// Gets a collection of the specified rows in this range, separated by commas. + /// e.g. Rows("4:5"), Rows("7:8,10:11"), Rows("13") + /// + /// The rows to return. IXLRangeRows Rows(string rows); + /// + /// Returns the specified range. + /// + /// The range boundaries. + IXLRange Range(IXLRangeAddress rangeAddress); + + /// Returns the specified range. + /// e.g. Range("A1"), Range("A1:C2") + /// The range boundaries. + IXLRange Range(string rangeAddress); + + /// Returns the specified range. + /// The first cell address in the range. + /// The last cell address in the range. + IXLRange Range(string firstCellAddress, string lastCellAddress); + + /// Returns the specified range. + /// The first cell address in the range. + /// The last cell address in the range. + IXLRange Range(IXLAddress firstCellAddress, IXLAddress lastCellAddress); + + /// Returns a collection of ranges, separated by commas. + /// e.g. Ranges("A1"), Ranges("A1:C2"), Ranges("A1:B2,D1:D4") + /// The ranges to return. + IXLRanges Ranges(string ranges); + + /// Returns the specified range. + /// The first cell's row of the range to return. + /// The first cell's column of the range to return. + /// The last cell's row of the range to return. + /// The last cell's column of the range to return. + /// . IXLRange Range(int firstCellRow, int firstCellColumn, int lastCellRow, int lastCellColumn); + /// Gets the number of rows in this range. int RowCount(); + + /// Gets the number of columns in this range. int ColumnCount(); + /// + /// Inserts X number of columns to the right of this range. + /// All cells to the right of this range will be shifted X number of columns. + /// + /// Number of columns to insert. void InsertColumnsAfter(int numberOfColumns); + /// + /// Inserts X number of columns to the left of this range. + /// This range and all cells to the right of this range will be shifted X number of columns. + /// + /// Number of columns to insert. void InsertColumnsBefore(int numberOfColumns); + /// + /// Inserts X number of rows on top of this range. + /// This range and all cells below this range will be shifted X number of rows. + /// + /// Number of rows to insert. void InsertRowsAbove(int numberOfRows); + /// + /// Inserts X number of rows below this range. + /// All cells below this range will be shifted X number of rows. + /// + /// Number of rows to insert. void InsertRowsBelow(int numberOfRows); + + /// + /// Deletes this range and shifts the surrounding cells accordingly. + /// + /// How to shift the surrounding cells. void Delete(XLShiftDeletedCells shiftDeleteCells); + /// + /// Clears the contents of this range (including styles). + /// void Clear(); + /// + /// Transposes the contents and styles of all cells in this range. + /// + /// How to handle the surrounding cells when transposing the range. void Transpose(XLTransposeOptions transposeOption); + /// + /// Sets the formula for all cells in the range in A1 notation. + /// + /// + /// The formula A1. + /// String FormulaA1 { set; } + /// + /// Sets the formula for all cells in the range in R1C1 notation. + /// + /// + /// The formula R1C1. + /// String FormulaR1C1 { set; } } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeAddress.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeAddress.cs index 7edd278..18aea9d 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeAddress.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeAddress.cs @@ -7,9 +7,26 @@ { public interface IXLRangeAddress { - //IXLWorksheet Worksheet { get; set; } + /// + /// Gets or sets the first address in the range. + /// + /// + /// The first address. + /// IXLAddress FirstAddress { get; set; } + /// + /// Gets or sets the last address in the range. + /// + /// + /// The last address. + /// IXLAddress LastAddress { get; set; } + /// + /// Gets or sets a value indicating whether this range is invalid. + /// + /// + /// true if this instance is invalid; otherwise, false. + /// Boolean IsInvalid { get; set; } } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeBase.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeBase.cs index 77611b8..22916df 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeBase.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeBase.cs @@ -6,29 +6,96 @@ namespace ClosedXML.Excel { public enum XLScope { Workbook, Worksheet }; + public interface IXLRangeBase: IXLStylized { - IEnumerable Cells(); - IEnumerable CellsUsed(); + /// + /// Returns the collection of cells. + /// + IXLCells Cells(); + + /// + /// Returns the collection of cells that have a value. + /// + IXLCells CellsUsed(); + + /// + /// Returns the collection of cells that have a value. + /// + /// if set to true will return all cells with a value or a style different than the default. + IXLCells CellsUsed(Boolean includeStyles); + + /// + /// Gets an object with the boundaries of this range. + /// IXLRangeAddress RangeAddress { get; } + /// + /// Returns the first cell of this range. + /// IXLCell FirstCell(); + /// + /// Returns the first cell with a value of this range. + /// The cell's address is going to be ([First Row with a value], [First Column with a value]) + /// IXLCell FirstCellUsed(); - IXLCell FirstCellUsed(Boolean ignoreStyle); + + /// Returns the first cell with a value of this range. + /// The cell's address is going to be ([First Row with a value], [First Column with a value]) + /// if set to true will return all cells with a value or a style different than the default. + IXLCell FirstCellUsed(Boolean includeStyles); + /// + /// Returns the last cell of this range. + /// IXLCell LastCell(); + /// + /// Returns the last cell with a value of this range. + /// The cell's address is going to be ([Last Row with a value], [Last Column with a value]) + /// IXLCell LastCellUsed(); - IXLCell LastCellUsed(Boolean ignoreStyle); - IXLRange Range(IXLRangeAddress rangeAddress); - IXLRange Range(string rangeAddress); - IXLRange Range(string firstCellAddress, string lastCellAddress); - IXLRange Range(IXLAddress firstCellAddress, IXLAddress lastCellAddress); - IXLRanges Ranges(params string[] ranges); - IXLRanges Ranges(string ranges); - IXLRange Unmerge(); - IXLRange Merge(); - IXLRange AsRange(); + + /// Returns the last cell with a value of this range. + /// The cell's address is going to be ([Last Row with a value], [Last Column with a value]) + /// if set to true will return all cells with a value or a style different than the default. + IXLCell LastCellUsed(Boolean includeStyles); + + /// + /// Determines whether this range contains the specified range address. + /// + /// The range address. + /// + /// true if this range contains the specified range address; otherwise, false. + /// Boolean ContainsRange(String rangeAddress); + /// + /// Unmerges this range. + /// + IXLRange Unmerge(); + /// + /// Merges this range. + /// The contents and style of the merged cells will be equal to the first cell. + /// + IXLRange Merge(); + /// + /// Creates a named range out of this range. + /// If the named range exists, it will add this range to that named range. + /// The default scope for the named range is Workbook. + /// + /// Name of the range. IXLRange AddToNamed(String rangeName); + + /// + /// Creates a named range out of this range. + /// If the named range exists, it will add this range to that named range. + /// Name of the range. + /// The scope for the named range. IXLRange AddToNamed(String rangeName, XLScope scope); + + /// + /// Creates a named range out of this range. + /// If the named range exists, it will add this range to that named range. + /// Name of the range. + /// The scope for the named range. + /// The comments for the named range. IXLRange AddToNamed(String rangeName, XLScope scope, String comment); } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeColumn.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeColumn.cs index 8d0c891..876e9a4 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeColumn.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeColumn.cs @@ -8,22 +8,81 @@ { public interface IXLRangeColumn: IXLRangeBase { - IXLCell Cell(int row); + /// + /// Gets the cell in the specified row. + /// + /// The cell's row. + IXLCell Cell(Int32 rowNumber); - IEnumerable Cells(int firstRow, int lastRow); - IXLRange Range(int firstColumn, int lastColumn); + /// + /// Returns the specified group of cells, separated by commas. + /// e.g. Cells("1"), Cells("1:5"), Cells("1:2,4:5") + /// + /// The column cells to return. + IXLCells Cells(String cellsInColumn); + /// + /// Returns the specified group of cells. + /// + /// The first row in the group of cells to return. + /// The last row in the group of cells to return. + IXLCells Cells(Int32 firstRow, Int32 lastRow); - int RowCount(); + /// + /// Converts this column to a range object. + /// + IXLRange AsRange(); + /// + /// Inserts X number of columns to the right of this range. + /// All cells to the right of this range will be shifted X number of columns. + /// + /// Number of columns to insert. void InsertColumnsAfter(int numberOfColumns); + /// + /// Inserts X number of columns to the left of this range. + /// This range and all cells to the right of this range will be shifted X number of columns. + /// + /// Number of columns to insert. void InsertColumnsBefore(int numberOfColumns); - void InsertRowsAbove(int numberOfRows); - void InsertRowsBelow(int numberOfRows); + /// + /// Inserts X number of cells on top of this column. + /// This column and all cells below it will be shifted X number of rows. + /// + /// Number of cells to insert. + void InsertCellsAbove(int numberOfRows); + /// + /// Inserts X number of cells below this range. + /// All cells below this column will be shifted X number of rows. + /// + /// Number of cells to insert. + void InsertCellsBelow(int numberOfRows); + /// + /// Deletes this range and shifts the cells at the right. + /// void Delete(); + /// + /// Deletes this range and shifts the surrounding cells accordingly. + /// + /// How to shift the surrounding cells. void Delete(XLShiftDeletedCells shiftDeleteCells); + /// + /// Clears the contents of the column (including styles). + /// void Clear(); + /// + /// Sets the formula for all cells in the column in A1 notation. + /// + /// + /// The formula A1. + /// String FormulaA1 { set; } + /// + /// Sets the formula for all cells in the column in R1C1 notation. + /// + /// + /// The formula R1C1. + /// String FormulaR1C1 { set; } } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeColumns.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeColumns.cs index c5745f0..2352f50 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeColumns.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeColumns.cs @@ -7,9 +7,45 @@ { public interface IXLRangeColumns: IEnumerable, IXLStylized { + /// + /// Clears the contents of the columns (including styles). + /// void Clear(); - void Add(IXLRangeColumn range); + + /// + /// Adds a column range to this group. + /// + /// The column range to add. + void Add(IXLRangeColumn columRange); + /// + /// Sets the formula for all cells in the columns in A1 notation. + /// + /// + /// The formula A1. + /// String FormulaA1 { set; } + /// + /// Sets the formula for all cells in the columns in R1C1 notation. + /// + /// + /// The formula R1C1. + /// String FormulaR1C1 { set; } + + /// + /// Returns the collection of cells in this column. + /// + IXLCells Cells(); + + /// + /// Returns the collection of cells that have a value in this column. + /// + IXLCells CellsUsed(); + + /// + /// Returns the collection of cells that have a value in this column. + /// + /// if set to true will return all cells with a value or a style different than the default. + IXLCells CellsUsed(Boolean includeStyles); } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeRow.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeRow.cs index 3afec0e..ee1ec53 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeRow.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeRow.cs @@ -8,24 +8,93 @@ { public interface IXLRangeRow: IXLRangeBase { - IXLCell Cell(int column); - IXLCell Cell(string column); + /// + /// Gets the cell in the specified column. + /// + /// The cell's column. + IXLCell Cell(Int32 columnNumber); - IEnumerable Cells(int firstColumn, int lastColumn); - IEnumerable Cells(String firstColumn, String lastColumn); - IXLRange Range(int firstRow, int lastRow); + /// + /// Gets the cell in the specified column. + /// + /// The cell's column. + IXLCell Cell(String columnLetter); - int ColumnCount(); + /// + /// Returns the specified group of cells, separated by commas. + /// e.g. Cells("1"), Cells("1:5"), Cells("1:2,4:5") + /// + /// The row's cells to return. + IXLCells Cells(String cellsInRow); + /// + /// Returns the specified group of cells. + /// + /// The first column in the group of cells to return. + /// The last column in the group of cells to return. + IXLCells Cells(Int32 firstColumn, Int32 lastColumn); + /// + /// Returns the specified group of cells. + /// + /// The first column in the group of cells to return. + /// The last column in the group of cells to return. + IXLCells Cells(String firstColumn, String lastColumn); - void InsertColumnsAfter(int numberOfColumns); - void InsertColumnsBefore(int numberOfColumns); + /// + /// Converts this row to a range object. + /// + IXLRange AsRange(); + + /// + /// Inserts X number of cells to the right of this row. + /// All cells to the right of this row will be shifted X number of columns. + /// + /// Number of cells to insert. + void InsertCellsAfter(int numberOfColumns); + /// + /// Inserts X number of cells to the left of this row. + /// This row and all cells to the right of it will be shifted X number of columns. + /// + /// Number of cells to insert. + void InsertCellsBefore(int numberOfColumns); + /// + /// Inserts X number of rows on top of this row. + /// This row and all cells below it will be shifted X number of rows. + /// + /// Number of rows to insert. void InsertRowsAbove(int numberOfRows); + /// + /// Inserts X number of rows below this row. + /// All cells below this row will be shifted X number of rows. + /// + /// Number of rows to insert. void InsertRowsBelow(int numberOfRows); + /// + /// Deletes this range and shifts the cells below. + /// void Delete(); + /// + /// Deletes this range and shifts the surrounding cells accordingly. + /// + /// How to shift the surrounding cells. void Delete(XLShiftDeletedCells shiftDeleteCells); + /// + /// Clears the contents of the row (including styles). + /// void Clear(); + /// + /// Sets the formula for all cells in the row in A1 notation. + /// + /// + /// The formula A1. + /// String FormulaA1 { set; } + /// + /// Sets the formula for all cells in the row in R1C1 notation. + /// + /// + /// The formula R1C1. + /// String FormulaR1C1 { set; } } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeRows.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeRows.cs index dc54bf7..050fdf9 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeRows.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRangeRows.cs @@ -7,9 +7,44 @@ { public interface IXLRangeRows: IEnumerable, IXLStylized { + /// + /// Adds a row range to this group. + /// + /// The row range to add. + void Add(IXLRangeRow rowRange); + /// + /// Clears the contents of the rows (including styles). + /// void Clear(); - void Add(IXLRangeRow range); + /// + /// Sets the formula for all cells in the rows in A1 notation. + /// + /// + /// The formula A1. + /// String FormulaA1 { set; } + /// + /// Sets the formula for all cells in the rows in R1C1 notation. + /// + /// + /// The formula R1C1. + /// String FormulaR1C1 { set; } + + /// + /// Returns the collection of cells. + /// + IXLCells Cells(); + + /// + /// Returns the collection of cells that have a value. + /// + IXLCells CellsUsed(); + + /// + /// Returns the collection of cells that have a value. + /// + /// if set to true will return all cells with a value or a style different than the default. + IXLCells CellsUsed(Boolean includeStyles); } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRanges.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRanges.cs index 28c627e..18cb224 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRanges.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/IXLRanges.cs @@ -7,8 +7,21 @@ { public interface IXLRanges: IEnumerable, IXLStylized { + /// + /// Clears the contents of the ranges (including styles). + /// void Clear(); + /// + /// Adds the specified range to this group. + /// + /// The range to add to this group. void Add(IXLRange range); + /// + /// Removes the specified range from this group. + /// + /// The range to remove from this group. void Remove(IXLRange range); + + } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeBase.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeBase.cs index 052a058..9415873 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeBase.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeBase.cs @@ -29,13 +29,11 @@ { return FirstCellUsed(true); } - public IXLCell FirstCellUsed(Boolean ignoreStyle) + public IXLCell FirstCellUsed(Boolean includeStyles) { - var cellsUsed = CellsUsed(); - if (ignoreStyle) - cellsUsed = cellsUsed.Where(c => c.GetString().Length != 0); + var cellsUsed = CellsUsed(includeStyles); - if (cellsUsed.Count() == 0) + if (cellsUsed.Count() == 0) { return null; } @@ -51,11 +49,9 @@ { return LastCellUsed(true); } - public IXLCell LastCellUsed(Boolean ignoreStyle) + public IXLCell LastCellUsed(Boolean includeStyles) { - var cellsUsed = CellsUsed(); - if (ignoreStyle) - cellsUsed = cellsUsed.Where(c => c.GetString().Length != 0); + var cellsUsed = CellsUsed(includeStyles); if (cellsUsed.Count() == 0) { @@ -133,7 +129,7 @@ return this.RangeAddress.LastAddress.ColumnNumber - this.RangeAddress.FirstAddress.ColumnNumber + 1; } - public IXLRange Range(String rangeAddressStr) + public virtual IXLRange Range(String rangeAddressStr) { var rangeAddress = new XLRangeAddress(rangeAddressStr); return Range(rangeAddress); @@ -178,11 +174,11 @@ var rangePairs = ranges.Split(','); foreach (var pair in rangePairs) { - retVal.Add(this.Range(pair)); + retVal.Add(Range(pair)); } return retVal; } - public IXLRanges Ranges( params String[] ranges) + public IXLRanges Ranges(params String[] ranges) { var retVal = new XLRanges(Worksheet.Internals.Workbook, Worksheet.Style); foreach (var pair in ranges) @@ -191,23 +187,59 @@ } return retVal; } - - public IEnumerable Cells() + protected String FixColumnAddress(String address) { + Int32 test; + if (Int32.TryParse(address, out test)) + return "A" + address; + else + return address; + } + protected String FixRowAddress(String address) + { + Int32 test; + if (Int32.TryParse(address, out test)) + return XLAddress.GetColumnLetterFromNumber(test) + "1"; + else + return address; + } + public IXLCells Cells() + { + var cellHash = new HashSet(); foreach (var row in Enumerable.Range(1, this.RowCount())) { foreach (var column in Enumerable.Range(1, this.ColumnCount())) { - yield return this.Cell(row, column); + cellHash.Add(this.Cell(row, column)); } } + var cells = new XLCells(Worksheet); + cells.AddRange(cellHash); + return (IXLCells)cells; } - public IEnumerable CellsUsed() + public IXLCells CellsUsed() { - var list = this.Worksheet.Internals.CellsCollection.Where(c => this.ContainsRange(c.Key.ToString())).Select(c => c.Value); - var retList = new List(); - list.ForEach(c => retList.Add(c)); - return retList.AsEnumerable(); + var list = this.Worksheet.Internals.CellsCollection.Where(c => !StringExtensions.IsNullOrWhiteSpace(c.Value.InnerText) && this.ContainsRange(c.Key.ToString())).Select(c => (IXLCell)c.Value); + var cells = new XLCells(Worksheet); + cells.AddRange(list.AsEnumerable()); + return (IXLCells)cells; + } + public IXLCells CellsUsed(Boolean includeStyles) + { + IEnumerable list; + if (includeStyles) + list = this.Worksheet.Internals.CellsCollection.Where(c => + (!StringExtensions.IsNullOrWhiteSpace(c.Value.InnerText) || !c.Value.Style.Equals(Worksheet.Style)) + && this.ContainsRange(c.Key.ToString()) + ).Select(c => (IXLCell)c.Value); + else + list = this.Worksheet.Internals.CellsCollection.Where(c => + !StringExtensions.IsNullOrWhiteSpace(c.Value.InnerText) + && this.ContainsRange(c.Key.ToString()) + ).Select(c => (IXLCell)c.Value); + var cells = new XLCells(Worksheet); + cells.AddRange(list); + return (IXLCells)cells; } public IXLRange Merge() diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeColumn.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeColumn.cs index 4d034d5..685450f 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeColumn.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeColumn.cs @@ -31,22 +31,59 @@ return Cell(row, 1); } - public IEnumerable Cells(int firstRow, int lastRow) + public IXLCells Cells(String cellsInColumn) { - return Cells() - .Where(c => c.Address.RowNumber >= firstRow - && c.Address.RowNumber <= lastRow); + var retVal = new XLCells(Worksheet); + var rangePairs = cellsInColumn.Split(','); + foreach (var pair in rangePairs) + { + retVal.AddRange(Range(pair).Cells()); + } + return retVal; } + public IXLCells Cells(Int32 firstRow, Int32 lastRow) + { + return Cells(firstRow + ":" + lastRow); + } + public IXLRange Range(int firstRow, int lastRow) { return Range(firstRow, 1, lastRow, 1); } + public override IXLRange Range(String rangeAddressStr) + { + String rangeAddressToUse; + if (rangeAddressStr.Contains(":")) + { + String[] arrRange = rangeAddressStr.Split(':'); + var firstPart = arrRange[0]; + var secondPart = arrRange[1]; + rangeAddressToUse = FixColumnAddress(firstPart) + ":" + FixColumnAddress(secondPart); + } + else + { + rangeAddressToUse = FixColumnAddress(rangeAddressStr); + } + + var rangeAddress = new XLRangeAddress(rangeAddressToUse); + return Range(rangeAddress); + } public void Delete() { Delete(XLShiftDeletedCells.ShiftCellsLeft); } + + public void InsertCellsAbove(int numberOfRows) + { + InsertRowsAbove(numberOfRows); + } + + public void InsertCellsBelow(int numberOfRows) + { + InsertRowsBelow(numberOfRows); + } } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeColumns.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeColumns.cs index 2f17867..5beb797 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeColumns.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeColumns.cs @@ -7,9 +7,11 @@ { internal class XLRangeColumns : IXLRangeColumns { + XLWorksheet worksheet; public XLRangeColumns(XLWorksheet worksheet) { Style = worksheet.Style; + this.worksheet = worksheet; } List ranges = new List(); @@ -93,5 +95,59 @@ ranges.ForEach(r => r.FormulaR1C1 = value); } } + + public IXLCells Cells() + { + var cellHash = new HashSet(); + foreach (var container in ranges) + { + foreach (var cell in container.Cells()) + { + if (!cellHash.Contains(cell)) + { + cellHash.Add(cell); + } + } + } + var cells = new XLCells(worksheet); + cells.AddRange(cellHash); + return (IXLCells)cells; + } + + public IXLCells CellsUsed() + { + var cellHash = new HashSet(); + foreach (var container in ranges) + { + foreach (var cell in container.CellsUsed()) + { + if (!cellHash.Contains(cell)) + { + cellHash.Add(cell); + } + } + } + var cells = new XLCells(worksheet); + cells.AddRange(cellHash); + return (IXLCells)cells; + } + + public IXLCells CellsUsed(Boolean includeStyles) + { + var cellHash = new HashSet(); + foreach (var container in ranges) + { + foreach (var cell in container.CellsUsed(includeStyles)) + { + if (!cellHash.Contains(cell)) + { + cellHash.Add(cell); + } + } + } + var cells = new XLCells(worksheet); + cells.AddRange(cellHash); + return (IXLCells)cells; + } } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeRow.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeRow.cs index 44db10e..f93d11c 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeRow.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeRow.cs @@ -34,19 +34,6 @@ return Cell(1, column); } - public IEnumerable Cells(int firstColumn, int lastColumn) - { - return Cells() - .Where(c => c.Address.ColumnNumber >= firstColumn - && c.Address.ColumnNumber <= lastColumn); - } - public IEnumerable Cells(String firstColumn, String lastColumn) - { - return Cells() - .Where(c => c.Address.ColumnNumber >= XLAddress.GetColumnNumberFromLetter(firstColumn) - && c.Address.ColumnNumber <= XLAddress.GetColumnNumberFromLetter(lastColumn)); - } - public IXLRange Range(int firstColumn, int lastColumn) { return Range(1, firstColumn, 1, lastColumn); @@ -56,6 +43,57 @@ { Delete(XLShiftDeletedCells.ShiftCellsUp); } + + public void InsertCellsAfter(int numberOfColumns) + { + InsertColumnsAfter(numberOfColumns); + } + + public void InsertCellsBefore(int numberOfColumns) + { + InsertColumnsBefore(numberOfColumns); + } + + public IXLCells Cells(String cellsInRow) + { + var retVal = new XLCells(Worksheet); + var rangePairs = cellsInRow.Split(','); + foreach (var pair in rangePairs) + { + retVal.AddRange(Range(pair).Cells()); + } + return retVal; + } + + public override IXLRange Range(String rangeAddressStr) + { + String rangeAddressToUse; + if (rangeAddressStr.Contains(":")) + { + String[] arrRange = rangeAddressStr.Split(':'); + var firstPart = arrRange[0]; + var secondPart = arrRange[1]; + rangeAddressToUse = FixRowAddress(firstPart) + ":" + FixRowAddress(secondPart); + } + else + { + rangeAddressToUse = FixRowAddress(rangeAddressStr); + } + + var rangeAddress = new XLRangeAddress(rangeAddressToUse); + return Range(rangeAddress); + } + + public IXLCells Cells(Int32 firstColumn, Int32 lastColumn) + { + return Cells(firstColumn + ":" + lastColumn); + } + + public IXLCells Cells(String firstColumn, String lastColumn) + { + return Cells(XLAddress.GetColumnNumberFromLetter(firstColumn) + ":" + + XLAddress.GetColumnNumberFromLetter(lastColumn)); + } } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeRows.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeRows.cs index ec1f47a..3322ddc 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeRows.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRangeRows.cs @@ -7,9 +7,11 @@ { internal class XLRangeRows : IXLRangeRows { + XLWorksheet worksheet; public XLRangeRows(XLWorksheet worksheet) { Style = worksheet.Style; + this.worksheet = worksheet; } List ranges = new List(); @@ -93,5 +95,59 @@ ranges.ForEach(r => r.FormulaR1C1 = value); } } + + public IXLCells Cells() + { + var cellHash = new HashSet(); + foreach (var container in ranges) + { + foreach (var cell in container.Cells()) + { + if (!cellHash.Contains(cell)) + { + cellHash.Add(cell); + } + } + } + var cells = new XLCells(worksheet); + cells.AddRange(cellHash); + return (IXLCells)cells; + } + + public IXLCells CellsUsed() + { + var cellHash = new HashSet(); + foreach (var container in ranges) + { + foreach (var cell in container.CellsUsed()) + { + if (!cellHash.Contains(cell)) + { + cellHash.Add(cell); + } + } + } + var cells = new XLCells(worksheet); + cells.AddRange(cellHash); + return (IXLCells)cells; + } + + public IXLCells CellsUsed(Boolean includeStyles) + { + var cellHash = new HashSet(); + foreach (var container in ranges) + { + foreach (var cell in container.CellsUsed(includeStyles)) + { + if (!cellHash.Contains(cell)) + { + cellHash.Add(cell); + } + } + } + var cells = new XLCells(worksheet); + cells.AddRange(cellHash); + return (IXLCells)cells; + } } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRanges.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRanges.cs index 75ecc26..d24fd7c 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRanges.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Ranges/XLRanges.cs @@ -102,5 +102,7 @@ if (retVal.Length > 0) retVal = retVal.Substring(0, retVal.Length - 1); return retVal; } + + } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/IXLRow.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/IXLRow.cs index 8d69e04..da5c318 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/IXLRow.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/IXLRow.cs @@ -7,28 +7,149 @@ { public interface IXLRow : IXLRangeBase { + /// + /// Gets or sets the height of this row. + /// + /// + /// The width of this row. + /// Double Height { get; set; } + + /// + /// Deletes this row and shifts the rows below this one accordingly. + /// void Delete(); + + /// + /// Gets this row's number + /// Int32 RowNumber(); + + /// + /// Inserts X number of rows below this one. + /// All rows below will be shifted accordingly. + /// + /// The number of rows to insert. void InsertRowsBelow(Int32 numberOfRows); + + /// + /// Inserts X number of rows above this one. + /// This row and all below will be shifted accordingly. + /// + /// The number of rows to insert. void InsertRowsAbove(Int32 numberOfRows); + + /// + /// Clears the contents of this row (including styles). + /// void Clear(); - IXLCell Cell(Int32 column); - IXLCell Cell(String column); - + /// + /// Adjusts the height of the row based on its contents. + /// void AdjustToContents(); + + /// Hides this row. void Hide(); + + /// Unhides this row. void Unhide(); + + /// + /// Gets a value indicating whether this row is hidden or not. + /// + /// + /// true if this row is hidden; otherwise, false. + /// Boolean IsHidden { get; } + + /// + /// Gets or sets the outline level of this row. + /// + /// + /// The outline level of this row. + /// Int32 OutlineLevel { get; set; } + + /// + /// Adds this row to the next outline level (Increments the outline level for this row by 1). + /// void Group(); + + /// + /// Adds this row to the next outline level (Increments the outline level for this row by 1). + /// + /// If set to true the row will be shown collapsed. void Group(Boolean collapse); + + /// + /// Sets outline level for this row. + /// + /// The outline level. void Group(Int32 outlineLevel); + + /// + /// Sets outline level for this row. + /// + /// The outline level. + /// If set to true the row will be shown collapsed. void Group(Int32 outlineLevel, Boolean collapse); + + /// + /// Adds this row to the previous outline level (decrements the outline level for this row by 1). + /// void Ungroup(); + + + /// + /// Adds this row to the previous outline level (decrements the outline level for this row by 1). + /// + /// If set to true it will remove this row from all outline levels. void Ungroup(Boolean fromAll); + + /// + /// Show this row as collapsed. + /// void Collapse(); + + /// + /// Gets the cell in the specified column. + /// + /// The cell's column. + IXLCell Cell(Int32 columnNumber); + + /// + /// Gets the cell in the specified column. + /// + /// The cell's column. + IXLCell Cell(String columnLetter); + + /// + /// Returns the specified group of cells, separated by commas. + /// e.g. Cells("1"), Cells("1:5"), Cells("1,3:5") + /// + /// The row's cells to return. + IXLCells Cells(String cellsInRow); + /// + /// Returns the specified group of cells. + /// + /// The first column in the group of cells to return. + /// The last column in the group of cells to return. + IXLCells Cells(Int32 firstColumn, Int32 lastColumn); + /// + /// Returns the specified group of cells. + /// + /// The first column in the group of cells to return. + /// The last column in the group of cells to return. + IXLCells Cells(String firstColumn, String lastColumn); + + /// + /// Converts this row to a range object. + /// + IXLRange AsRange(); + + /// Expands this row (if it's collapsed). void Expand(); + } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/IXLRows.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/IXLRows.cs index 9796f9c..290c775 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/IXLRows.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/IXLRows.cs @@ -7,18 +7,89 @@ { public interface IXLRows: IEnumerable, IXLStylized { + /// + /// Sets the height of all rows. + /// + /// + /// The height of all rows. + /// Double Height { set; } + + /// + /// Deletes all rows and shifts the rows below them accordingly. + /// void Delete(); + + /// + /// Adjusts the height of all rows based on its contents. + /// void AdjustToContents(); + + /// + /// Hides all rows. + /// void Hide(); + + /// Unhides all rows. void Unhide(); + + /// + /// Increments the outline level of all rows by 1. + /// void Group(); + + /// + /// Increments the outline level of all rows by 1. + /// + /// If set to true the rows will be shown collapsed. void Group(Boolean collapse); + + /// + /// Sets outline level for all rows. + /// + /// The outline level. void Group(Int32 outlineLevel); + + /// + /// Sets outline level for all rows. + /// + /// The outline level. + /// If set to true the rows will be shown collapsed. void Group(Int32 outlineLevel, Boolean collapse); + + /// + /// Decrements the outline level of all rows by 1. + /// void Ungroup(); + + /// + /// Decrements the outline level of all rows by 1. + /// + /// If set to true it will remove the rows from all outline levels. void Ungroup(Boolean fromAll); + + /// + /// Show all rows as collapsed. + /// void Collapse(); + + /// Expands all rows (if they're collapsed). void Expand(); + + /// + /// Returns the collection of cells. + /// + IXLCells Cells(); + + /// + /// Returns the collection of cells that have a value. + /// + IXLCells CellsUsed(); + + /// + /// Returns the collection of cells that have a value. + /// + /// if set to true will return all cells with a value or a style different than the default. + IXLCells CellsUsed(Boolean includeStyles); } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/XLRow.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/XLRow.cs index 721e158..c64dd1d 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/XLRow.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/XLRow.cs @@ -119,13 +119,54 @@ this.Style = Worksheet.Style; } - public IXLCell Cell(Int32 column) + public IXLCell Cell(Int32 columnNumber) { - return base.Cell(1, column); + return base.Cell(1, columnNumber); } - public new IXLCell Cell(String column) + public new IXLCell Cell(String columnLetter) { - return base.Cell(1, column); + return base.Cell(1, columnLetter); + } + + public IXLCells Cells(String cellsInRow) + { + var retVal = new XLCells(Worksheet); + var rangePairs = cellsInRow.Split(','); + foreach (var pair in rangePairs) + { + retVal.AddRange(Range(pair).Cells()); + } + return retVal; + } + + public override IXLRange Range(String rangeAddressStr) + { + String rangeAddressToUse; + if (rangeAddressStr.Contains(":")) + { + String[] arrRange = rangeAddressStr.Split(':'); + var firstPart = arrRange[0]; + var secondPart = arrRange[1]; + rangeAddressToUse = FixRowAddress(firstPart) + ":" + FixRowAddress(secondPart); + } + else + { + rangeAddressToUse = FixRowAddress(rangeAddressStr); + } + + var rangeAddress = new XLRangeAddress(rangeAddressToUse); + return Range(rangeAddress); + } + + public IXLCells Cells(Int32 firstColumn, Int32 lastColumn) + { + return Cells(firstColumn + ":" + lastColumn); + } + + public IXLCells Cells(String firstColumn, String lastColumn) + { + return Cells(XLAddress.GetColumnNumberFromLetter(firstColumn) + ":" + + XLAddress.GetColumnNumberFromLetter(lastColumn)); } public void AdjustToContents() @@ -207,12 +248,16 @@ c.Style = value; } - var maxColumn = 0; + Int32 maxColumn = 0; + Int32 minColumn = 1; if (Worksheet.Internals.ColumnsCollection.Count > 0) + { maxColumn = Worksheet.Internals.ColumnsCollection.Keys.Max(); + minColumn = Worksheet.Internals.ColumnsCollection.Keys.Min(); + } - for (var co = 1; co <= maxColumn; co++) + for (Int32 co = minColumn; co <= maxColumn; co++) { Worksheet.Cell(row, co).Style = value; } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/XLRows.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/XLRows.cs index 1013836..831a82f 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/XLRows.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Rows/XLRows.cs @@ -186,5 +186,59 @@ { rows.ForEach(r => r.Expand()); } + + public IXLCells Cells() + { + var cellHash = new HashSet(); + foreach (var container in rows) + { + foreach (var cell in container.Cells()) + { + if (!cellHash.Contains(cell)) + { + cellHash.Add(cell); + } + } + } + var cells = new XLCells(worksheet, entireWorksheet); + cells.AddRange(cellHash); + return (IXLCells)cells; + } + + public IXLCells CellsUsed() + { + var cellHash = new HashSet(); + foreach (var container in rows) + { + foreach (var cell in container.CellsUsed()) + { + if (!cellHash.Contains(cell)) + { + cellHash.Add(cell); + } + } + } + var cells = new XLCells(worksheet, entireWorksheet); + cells.AddRange(cellHash); + return (IXLCells)cells; + } + + public IXLCells CellsUsed(Boolean includeStyles) + { + var cellHash = new HashSet(); + foreach (var container in rows) + { + foreach (var cell in container.CellsUsed(includeStyles)) + { + if (!cellHash.Contains(cell)) + { + cellHash.Add(cell); + } + } + } + var cells = new XLCells(worksheet, entireWorksheet); + cells.AddRange(cellHash); + return (IXLCells)cells; + } } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/IXLColor.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/IXLColor.cs index 6a16ad9..e4b30e3 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/IXLColor.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/IXLColor.cs @@ -27,5 +27,6 @@ Int32 Indexed { get; } XLThemeColor ThemeColor { get; } Double ThemeTint { get; } + Boolean HasValue { get; } } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Internal.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Internal.cs index f8339bd..9a7b489 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Internal.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Internal.cs @@ -8,8 +8,8 @@ { public partial class XLColor { - internal Boolean HasValue { get; private set; } - internal XLColor(XLColor defaultColor) + + internal XLColor(IXLColor defaultColor) { if (defaultColor.ColorType == XLColorType.Theme) { @@ -25,5 +25,31 @@ this.Color = defaultColor.Color; } } + internal XLColor() + { + HasValue = false; + } + internal XLColor(Color color) + { + Color = color; + HasValue = true; + } + internal XLColor(Int32 index) + { + Indexed = index; + HasValue = true; + } + internal XLColor(XLThemeColor themeColor) + { + ThemeColor = themeColor; + ThemeTint = 1; + HasValue = true; + } + internal XLColor(XLThemeColor themeColor, Double themeTint) + { + ThemeColor = themeColor; + ThemeTint = themeTint; + HasValue = true; + } } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Public.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Public.cs index 60d23df..0673bf1 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Public.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Public.cs @@ -8,33 +8,8 @@ { public partial class XLColor: IXLColor { - public XLColor() - { - HasValue = false; - } + public Boolean HasValue { get; private set; } - public XLColor(Color color) - { - Color = color; - HasValue = true; - } - public XLColor(Int32 index) - { - Indexed = index; - HasValue = true; - } - public XLColor(XLThemeColor themeColor) - { - ThemeColor = themeColor; - ThemeTint = 1; - HasValue = true; - } - public XLColor(XLThemeColor themeColor, Double themeTint) - { - ThemeColor = themeColor; - ThemeTint = themeTint; - HasValue = true; - } public XLColorType ColorType { get; private set; } private Color color; public Color Color diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Static.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Static.cs index 8ba702b..57e846d 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Static.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/Colors/XLColor_Static.cs @@ -8,55 +8,55 @@ { public partial class XLColor { - public static XLColor FromColor(Color color) + public static IXLColor FromColor(Color color) { return new XLColor(color); } - public static XLColor FromArgb(Int32 argb) + public static IXLColor FromArgb(Int32 argb) { return new XLColor(Color.FromArgb(argb)); } - public static XLColor FromArgb(Int32 r, Int32 g, Int32 b) + public static IXLColor FromArgb(Int32 r, Int32 g, Int32 b) { return new XLColor(Color.FromArgb(r, g, b)); } - public static XLColor FromArgb(Int32 a, Int32 r, Int32 g, Int32 b) + public static IXLColor FromArgb(Int32 a, Int32 r, Int32 g, Int32 b) { return new XLColor(Color.FromArgb(a, r, g, b)); } - public static XLColor FromKnownColor(KnownColor color) + public static IXLColor FromKnownColor(KnownColor color) { return new XLColor(Color.FromKnownColor(color)); } - public static XLColor FromName(String name) + public static IXLColor FromName(String name) { return new XLColor(Color.FromName(name)); } - public static XLColor FromHtml(String htmlColor) + public static IXLColor FromHtml(String htmlColor) { return new XLColor(ColorTranslator.FromHtml(htmlColor)); } - public static XLColor FromIndex(Int32 index) + public static IXLColor FromIndex(Int32 index) { return new XLColor(index); } - public static XLColor FromTheme(XLThemeColor themeColor) + public static IXLColor FromTheme(XLThemeColor themeColor) { return new XLColor(themeColor); } - public static XLColor FromTheme(XLThemeColor themeColor, Double themeTint) + public static IXLColor FromTheme(XLThemeColor themeColor, Double themeTint) { return new XLColor(themeColor, themeTint); } - private static Dictionary indexedColors; - public static Dictionary IndexedColors + private static Dictionary indexedColors; + public static Dictionary IndexedColors { get { if (indexedColors == null) { - Dictionary retVal = new Dictionary(); + Dictionary retVal = new Dictionary(); retVal.Add(0, XLColor.FromHtml("#FF000000")); retVal.Add(1, XLColor.FromHtml("#FFFFFFFF")); retVal.Add(2, XLColor.FromHtml("#FFFF0000")); @@ -127,739 +127,739 @@ } } - public static XLColor AliceBlue { get { return FromColor(Color.AliceBlue); } } - public static XLColor AntiqueWhite { get { return FromColor(Color.AntiqueWhite); } } - public static XLColor Aqua { get { return FromColor(Color.Aqua); } } - public static XLColor Aquamarine { get { return FromColor(Color.Aquamarine); } } - public static XLColor Azure { get { return FromColor(Color.Azure); } } - public static XLColor Beige { get { return FromColor(Color.Beige); } } - public static XLColor Bisque { get { return FromColor(Color.Bisque); } } - public static XLColor Black { get { return FromColor(Color.Black); } } - public static XLColor BlanchedAlmond { get { return FromColor(Color.BlanchedAlmond); } } - public static XLColor Blue { get { return FromColor(Color.Blue); } } - public static XLColor BlueViolet { get { return FromColor(Color.BlueViolet); } } - public static XLColor Brown { get { return FromColor(Color.Brown); } } - public static XLColor BurlyWood { get { return FromColor(Color.BurlyWood); } } - public static XLColor CadetBlue { get { return FromColor(Color.CadetBlue); } } - public static XLColor Chartreuse { get { return FromColor(Color.Chartreuse); } } - public static XLColor Chocolate { get { return FromColor(Color.Chocolate); } } - public static XLColor Coral { get { return FromColor(Color.Coral); } } - public static XLColor CornflowerBlue { get { return FromColor(Color.CornflowerBlue); } } - public static XLColor Cornsilk { get { return FromColor(Color.Cornsilk); } } - public static XLColor Crimson { get { return FromColor(Color.Crimson); } } - public static XLColor Cyan { get { return FromColor(Color.Cyan); } } - public static XLColor DarkBlue { get { return FromColor(Color.DarkBlue); } } - public static XLColor DarkCyan { get { return FromColor(Color.DarkCyan); } } - public static XLColor DarkGoldenrod { get { return FromColor(Color.DarkGoldenrod); } } - public static XLColor DarkGray { get { return FromColor(Color.DarkGray); } } - public static XLColor DarkGreen { get { return FromColor(Color.DarkGreen); } } - public static XLColor DarkKhaki { get { return FromColor(Color.DarkKhaki); } } - public static XLColor DarkMagenta { get { return FromColor(Color.DarkMagenta); } } - public static XLColor DarkOliveGreen { get { return FromColor(Color.DarkOliveGreen); } } - public static XLColor DarkOrange { get { return FromColor(Color.DarkOrange); } } - public static XLColor DarkOrchid { get { return FromColor(Color.DarkOrchid); } } - public static XLColor DarkRed { get { return FromColor(Color.DarkRed); } } - public static XLColor DarkSalmon { get { return FromColor(Color.DarkSalmon); } } - public static XLColor DarkSeaGreen { get { return FromColor(Color.DarkSeaGreen); } } - public static XLColor DarkSlateBlue { get { return FromColor(Color.DarkSlateBlue); } } - public static XLColor DarkSlateGray { get { return FromColor(Color.DarkSlateGray); } } - public static XLColor DarkTurquoise { get { return FromColor(Color.DarkTurquoise); } } - public static XLColor DarkViolet { get { return FromColor(Color.DarkViolet); } } - public static XLColor DeepPink { get { return FromColor(Color.DeepPink); } } - public static XLColor DeepSkyBlue { get { return FromColor(Color.DeepSkyBlue); } } - public static XLColor DimGray { get { return FromColor(Color.DimGray); } } - public static XLColor DodgerBlue { get { return FromColor(Color.DodgerBlue); } } - public static XLColor Firebrick { get { return FromColor(Color.Firebrick); } } - public static XLColor FloralWhite { get { return FromColor(Color.FloralWhite); } } - public static XLColor ForestGreen { get { return FromColor(Color.ForestGreen); } } - public static XLColor Fuchsia { get { return FromColor(Color.Fuchsia); } } - public static XLColor Gainsboro { get { return FromColor(Color.Gainsboro); } } - public static XLColor GhostWhite { get { return FromColor(Color.GhostWhite); } } - public static XLColor Gold { get { return FromColor(Color.Gold); } } - public static XLColor Goldenrod { get { return FromColor(Color.Goldenrod); } } - public static XLColor Gray { get { return FromColor(Color.Gray); } } - public static XLColor Green { get { return FromColor(Color.Green); } } - public static XLColor GreenYellow { get { return FromColor(Color.GreenYellow); } } - public static XLColor Honeydew { get { return FromColor(Color.Honeydew); } } - public static XLColor HotPink { get { return FromColor(Color.HotPink); } } - public static XLColor IndianRed { get { return FromColor(Color.IndianRed); } } - public static XLColor Indigo { get { return FromColor(Color.Indigo); } } - public static XLColor Ivory { get { return FromColor(Color.Ivory); } } - public static XLColor Khaki { get { return FromColor(Color.Khaki); } } - public static XLColor Lavender { get { return FromColor(Color.Lavender); } } - public static XLColor LavenderBlush { get { return FromColor(Color.LavenderBlush); } } - public static XLColor LawnGreen { get { return FromColor(Color.LawnGreen); } } - public static XLColor LemonChiffon { get { return FromColor(Color.LemonChiffon); } } - public static XLColor LightBlue { get { return FromColor(Color.LightBlue); } } - public static XLColor LightCoral { get { return FromColor(Color.LightCoral); } } - public static XLColor LightCyan { get { return FromColor(Color.LightCyan); } } - public static XLColor LightGoldenrodYellow { get { return FromColor(Color.LightGoldenrodYellow); } } - public static XLColor LightGray { get { return FromColor(Color.LightGray); } } - public static XLColor LightGreen { get { return FromColor(Color.LightGreen); } } - public static XLColor LightPink { get { return FromColor(Color.LightPink); } } - public static XLColor LightSalmon { get { return FromColor(Color.LightSalmon); } } - public static XLColor LightSeaGreen { get { return FromColor(Color.LightSeaGreen); } } - public static XLColor LightSkyBlue { get { return FromColor(Color.LightSkyBlue); } } - public static XLColor LightSlateGray { get { return FromColor(Color.LightSlateGray); } } - public static XLColor LightSteelBlue { get { return FromColor(Color.LightSteelBlue); } } - public static XLColor LightYellow { get { return FromColor(Color.LightYellow); } } - public static XLColor Lime { get { return FromColor(Color.Lime); } } - public static XLColor LimeGreen { get { return FromColor(Color.LimeGreen); } } - public static XLColor Linen { get { return FromColor(Color.Linen); } } - public static XLColor Magenta { get { return FromColor(Color.Magenta); } } - public static XLColor Maroon { get { return FromColor(Color.Maroon); } } - public static XLColor MediumAquamarine { get { return FromColor(Color.MediumAquamarine); } } - public static XLColor MediumBlue { get { return FromColor(Color.MediumBlue); } } - public static XLColor MediumOrchid { get { return FromColor(Color.MediumOrchid); } } - public static XLColor MediumPurple { get { return FromColor(Color.MediumPurple); } } - public static XLColor MediumSeaGreen { get { return FromColor(Color.MediumSeaGreen); } } - public static XLColor MediumSlateBlue { get { return FromColor(Color.MediumSlateBlue); } } - public static XLColor MediumSpringGreen { get { return FromColor(Color.MediumSpringGreen); } } - public static XLColor MediumTurquoise { get { return FromColor(Color.MediumTurquoise); } } - public static XLColor MediumVioletRed { get { return FromColor(Color.MediumVioletRed); } } - public static XLColor MidnightBlue { get { return FromColor(Color.MidnightBlue); } } - public static XLColor MintCream { get { return FromColor(Color.MintCream); } } - public static XLColor MistyRose { get { return FromColor(Color.MistyRose); } } - public static XLColor Moccasin { get { return FromColor(Color.Moccasin); } } - public static XLColor NavajoWhite { get { return FromColor(Color.NavajoWhite); } } - public static XLColor Navy { get { return FromColor(Color.Navy); } } - public static XLColor OldLace { get { return FromColor(Color.OldLace); } } - public static XLColor Olive { get { return FromColor(Color.Olive); } } - public static XLColor OliveDrab { get { return FromColor(Color.OliveDrab); } } - public static XLColor Orange { get { return FromColor(Color.Orange); } } - public static XLColor OrangeRed { get { return FromColor(Color.OrangeRed); } } - public static XLColor Orchid { get { return FromColor(Color.Orchid); } } - public static XLColor PaleGoldenrod { get { return FromColor(Color.PaleGoldenrod); } } - public static XLColor PaleGreen { get { return FromColor(Color.PaleGreen); } } - public static XLColor PaleTurquoise { get { return FromColor(Color.PaleTurquoise); } } - public static XLColor PaleVioletRed { get { return FromColor(Color.PaleVioletRed); } } - public static XLColor PapayaWhip { get { return FromColor(Color.PapayaWhip); } } - public static XLColor PeachPuff { get { return FromColor(Color.PeachPuff); } } - public static XLColor Peru { get { return FromColor(Color.Peru); } } - public static XLColor Pink { get { return FromColor(Color.Pink); } } - public static XLColor Plum { get { return FromColor(Color.Plum); } } - public static XLColor PowderBlue { get { return FromColor(Color.PowderBlue); } } - public static XLColor Purple { get { return FromColor(Color.Purple); } } - public static XLColor Red { get { return FromColor(Color.Red); } } - public static XLColor RosyBrown { get { return FromColor(Color.RosyBrown); } } - public static XLColor RoyalBlue { get { return FromColor(Color.RoyalBlue); } } - public static XLColor SaddleBrown { get { return FromColor(Color.SaddleBrown); } } - public static XLColor Salmon { get { return FromColor(Color.Salmon); } } - public static XLColor SandyBrown { get { return FromColor(Color.SandyBrown); } } - public static XLColor SeaGreen { get { return FromColor(Color.SeaGreen); } } - public static XLColor SeaShell { get { return FromColor(Color.SeaShell); } } - public static XLColor Sienna { get { return FromColor(Color.Sienna); } } - public static XLColor Silver { get { return FromColor(Color.Silver); } } - public static XLColor SkyBlue { get { return FromColor(Color.SkyBlue); } } - public static XLColor SlateBlue { get { return FromColor(Color.SlateBlue); } } - public static XLColor SlateGray { get { return FromColor(Color.SlateGray); } } - public static XLColor Snow { get { return FromColor(Color.Snow); } } - public static XLColor SpringGreen { get { return FromColor(Color.SpringGreen); } } - public static XLColor SteelBlue { get { return FromColor(Color.SteelBlue); } } - public static XLColor Tan { get { return FromColor(Color.Tan); } } - public static XLColor Teal { get { return FromColor(Color.Teal); } } - public static XLColor Thistle { get { return FromColor(Color.Thistle); } } - public static XLColor Tomato { get { return FromColor(Color.Tomato); } } - public static XLColor Turquoise { get { return FromColor(Color.Turquoise); } } - public static XLColor Violet { get { return FromColor(Color.Violet); } } - public static XLColor Wheat { get { return FromColor(Color.Wheat); } } - public static XLColor White { get { return FromColor(Color.White); } } - public static XLColor WhiteSmoke { get { return FromColor(Color.WhiteSmoke); } } - public static XLColor Yellow { get { return FromColor(Color.Yellow); } } - public static XLColor YellowGreen { get { return FromColor(Color.YellowGreen); } } - public static XLColor AirForceBlue { get { return FromHtml("#FF5D8AA8"); } } - public static XLColor Alizarin { get { return FromHtml("#FFE32636"); } } - public static XLColor Almond { get { return FromHtml("#FFEFDECD"); } } - public static XLColor Amaranth { get { return FromHtml("#FFE52B50"); } } - public static XLColor Amber { get { return FromHtml("#FFFFBF00"); } } - public static XLColor AmberSaeEce { get { return FromHtml("#FFFF7E00"); } } - public static XLColor AmericanRose { get { return FromHtml("#FFFF033E"); } } - public static XLColor Amethyst { get { return FromHtml("#FF9966CC"); } } - public static XLColor AntiFlashWhite { get { return FromHtml("#FFF2F3F4"); } } - public static XLColor AntiqueBrass { get { return FromHtml("#FFCD9575"); } } - public static XLColor AntiqueFuchsia { get { return FromHtml("#FF915C83"); } } - public static XLColor AppleGreen { get { return FromHtml("#FF8DB600"); } } - public static XLColor Apricot { get { return FromHtml("#FFFBCEB1"); } } - public static XLColor Aquamarine1 { get { return FromHtml("#FF7FFFD0"); } } - public static XLColor ArmyGreen { get { return FromHtml("#FF4B5320"); } } - public static XLColor Arsenic { get { return FromHtml("#FF3B444B"); } } - public static XLColor ArylideYellow { get { return FromHtml("#FFE9D66B"); } } - public static XLColor AshGrey { get { return FromHtml("#FFB2BEB5"); } } - public static XLColor Asparagus { get { return FromHtml("#FF87A96B"); } } - public static XLColor AtomicTangerine { get { return FromHtml("#FFFF9966"); } } - public static XLColor Auburn { get { return FromHtml("#FF6D351A"); } } - public static XLColor Aureolin { get { return FromHtml("#FFFDEE00"); } } - public static XLColor Aurometalsaurus { get { return FromHtml("#FF6E7F80"); } } - public static XLColor Awesome { get { return FromHtml("#FFFF2052"); } } - public static XLColor AzureColorWheel { get { return FromHtml("#FF007FFF"); } } - public static XLColor BabyBlue { get { return FromHtml("#FF89CFF0"); } } - public static XLColor BabyBlueEyes { get { return FromHtml("#FFA1CAF1"); } } - public static XLColor BabyPink { get { return FromHtml("#FFF4C2C2"); } } - public static XLColor BallBlue { get { return FromHtml("#FF21ABCD"); } } - public static XLColor BananaMania { get { return FromHtml("#FFFAE7B5"); } } - public static XLColor BattleshipGrey { get { return FromHtml("#FF848482"); } } - public static XLColor Bazaar { get { return FromHtml("#FF98777B"); } } - public static XLColor BeauBlue { get { return FromHtml("#FFBCD4E6"); } } - public static XLColor Beaver { get { return FromHtml("#FF9F8170"); } } - public static XLColor Bistre { get { return FromHtml("#FF3D2B1F"); } } - public static XLColor Bittersweet { get { return FromHtml("#FFFE6F5E"); } } - public static XLColor BleuDeFrance { get { return FromHtml("#FF318CE7"); } } - public static XLColor BlizzardBlue { get { return FromHtml("#FFACE5EE"); } } - public static XLColor Blond { get { return FromHtml("#FFFAF0BE"); } } - public static XLColor BlueBell { get { return FromHtml("#FFA2A2D0"); } } - public static XLColor BlueGray { get { return FromHtml("#FF6699CC"); } } - public static XLColor BlueGreen { get { return FromHtml("#FF00DDDD"); } } - public static XLColor BluePigment { get { return FromHtml("#FF333399"); } } - public static XLColor BlueRyb { get { return FromHtml("#FF0247FE"); } } - public static XLColor Blush { get { return FromHtml("#FFDE5D83"); } } - public static XLColor Bole { get { return FromHtml("#FF79443B"); } } - public static XLColor BondiBlue { get { return FromHtml("#FF0095B6"); } } - public static XLColor BostonUniversityRed { get { return FromHtml("#FFCC0000"); } } - public static XLColor BrandeisBlue { get { return FromHtml("#FF0070FF"); } } - public static XLColor Brass { get { return FromHtml("#FFB5A642"); } } - public static XLColor BrickRed { get { return FromHtml("#FFCB4154"); } } - public static XLColor BrightCerulean { get { return FromHtml("#FF1DACD6"); } } - public static XLColor BrightGreen { get { return FromHtml("#FF66FF00"); } } - public static XLColor BrightLavender { get { return FromHtml("#FFBF94E4"); } } - public static XLColor BrightMaroon { get { return FromHtml("#FFC32148"); } } - public static XLColor BrightPink { get { return FromHtml("#FFFF007F"); } } - public static XLColor BrightTurquoise { get { return FromHtml("#FF08E8DE"); } } - public static XLColor BrightUbe { get { return FromHtml("#FFD19FE8"); } } - public static XLColor BrilliantLavender { get { return FromHtml("#FFF4BBFF"); } } - public static XLColor BrilliantRose { get { return FromHtml("#FFFF55A3"); } } - public static XLColor BrinkPink { get { return FromHtml("#FFFB607F"); } } - public static XLColor BritishRacingGreen { get { return FromHtml("#FF004225"); } } - public static XLColor Bronze { get { return FromHtml("#FFCD7F32"); } } - public static XLColor BrownTraditional { get { return FromHtml("#FF964B00"); } } - public static XLColor BubbleGum { get { return FromHtml("#FFFFC1CC"); } } - public static XLColor Bubbles { get { return FromHtml("#FFE7FEFF"); } } - public static XLColor Buff { get { return FromHtml("#FFF0DC82"); } } - public static XLColor BulgarianRose { get { return FromHtml("#FF480607"); } } - public static XLColor Burgundy { get { return FromHtml("#FF800020"); } } - public static XLColor BurntOrange { get { return FromHtml("#FFCC5500"); } } - public static XLColor BurntSienna { get { return FromHtml("#FFE97451"); } } - public static XLColor BurntUmber { get { return FromHtml("#FF8A3324"); } } - public static XLColor Byzantine { get { return FromHtml("#FFBD33A4"); } } - public static XLColor Byzantium { get { return FromHtml("#FF702963"); } } - public static XLColor Cadet { get { return FromHtml("#FF536872"); } } - public static XLColor CadetGrey { get { return FromHtml("#FF91A3B0"); } } - public static XLColor CadmiumGreen { get { return FromHtml("#FF006B3C"); } } - public static XLColor CadmiumOrange { get { return FromHtml("#FFED872D"); } } - public static XLColor CadmiumRed { get { return FromHtml("#FFE30022"); } } - public static XLColor CadmiumYellow { get { return FromHtml("#FFFFF600"); } } - public static XLColor CalPolyPomonaGreen { get { return FromHtml("#FF1E4D2B"); } } - public static XLColor CambridgeBlue { get { return FromHtml("#FFA3C1AD"); } } - public static XLColor Camel { get { return FromHtml("#FFC19A6B"); } } - public static XLColor CamouflageGreen { get { return FromHtml("#FF78866B"); } } - public static XLColor CanaryYellow { get { return FromHtml("#FFFFEF00"); } } - public static XLColor CandyAppleRed { get { return FromHtml("#FFFF0800"); } } - public static XLColor CandyPink { get { return FromHtml("#FFE4717A"); } } - public static XLColor CaputMortuum { get { return FromHtml("#FF592720"); } } - public static XLColor Cardinal { get { return FromHtml("#FFC41E3A"); } } - public static XLColor CaribbeanGreen { get { return FromHtml("#FF00CC99"); } } - public static XLColor Carmine { get { return FromHtml("#FF960018"); } } - public static XLColor CarminePink { get { return FromHtml("#FFEB4C42"); } } - public static XLColor CarmineRed { get { return FromHtml("#FFFF0038"); } } - public static XLColor CarnationPink { get { return FromHtml("#FFFFA6C9"); } } - public static XLColor Carnelian { get { return FromHtml("#FFB31B1B"); } } - public static XLColor CarolinaBlue { get { return FromHtml("#FF99BADD"); } } - public static XLColor CarrotOrange { get { return FromHtml("#FFED9121"); } } - public static XLColor Ceil { get { return FromHtml("#FF92A1CF"); } } - public static XLColor Celadon { get { return FromHtml("#FFACE1AF"); } } - public static XLColor CelestialBlue { get { return FromHtml("#FF4997D0"); } } - public static XLColor Cerise { get { return FromHtml("#FFDE3163"); } } - public static XLColor CerisePink { get { return FromHtml("#FFEC3B83"); } } - public static XLColor Cerulean { get { return FromHtml("#FF007BA7"); } } - public static XLColor CeruleanBlue { get { return FromHtml("#FF2A52BE"); } } - public static XLColor Chamoisee { get { return FromHtml("#FFA0785A"); } } - public static XLColor Champagne { get { return FromHtml("#FFF7E7CE"); } } - public static XLColor Charcoal { get { return FromHtml("#FF36454F"); } } - public static XLColor ChartreuseTraditional { get { return FromHtml("#FFDFFF00"); } } - public static XLColor CherryBlossomPink { get { return FromHtml("#FFFFB7C5"); } } - public static XLColor Chocolate1 { get { return FromHtml("#FF7B3F00"); } } - public static XLColor ChromeYellow { get { return FromHtml("#FFFFA700"); } } - public static XLColor Cinereous { get { return FromHtml("#FF98817B"); } } - public static XLColor Cinnabar { get { return FromHtml("#FFE34234"); } } - public static XLColor Citrine { get { return FromHtml("#FFE4D00A"); } } - public static XLColor ClassicRose { get { return FromHtml("#FFFBCCE7"); } } - public static XLColor Cobalt { get { return FromHtml("#FF0047AB"); } } - public static XLColor ColumbiaBlue { get { return FromHtml("#FF9BDDFF"); } } - public static XLColor CoolBlack { get { return FromHtml("#FF002E63"); } } - public static XLColor CoolGrey { get { return FromHtml("#FF8C92AC"); } } - public static XLColor Copper { get { return FromHtml("#FFB87333"); } } - public static XLColor CopperRose { get { return FromHtml("#FF996666"); } } - public static XLColor Coquelicot { get { return FromHtml("#FFFF3800"); } } - public static XLColor CoralPink { get { return FromHtml("#FFF88379"); } } - public static XLColor CoralRed { get { return FromHtml("#FFFF4040"); } } - public static XLColor Cordovan { get { return FromHtml("#FF893F45"); } } - public static XLColor Corn { get { return FromHtml("#FFFBEC5D"); } } - public static XLColor CornellRed { get { return FromHtml("#FFB31B1B"); } } - public static XLColor CosmicLatte { get { return FromHtml("#FFFFF8E7"); } } - public static XLColor CottonCandy { get { return FromHtml("#FFFFBCD9"); } } - public static XLColor Cream { get { return FromHtml("#FFFFFDD0"); } } - public static XLColor CrimsonGlory { get { return FromHtml("#FFBE0032"); } } - public static XLColor CyanProcess { get { return FromHtml("#FF00B7EB"); } } - public static XLColor Daffodil { get { return FromHtml("#FFFFFF31"); } } - public static XLColor Dandelion { get { return FromHtml("#FFF0E130"); } } - public static XLColor DarkBrown { get { return FromHtml("#FF654321"); } } - public static XLColor DarkByzantium { get { return FromHtml("#FF5D3954"); } } - public static XLColor DarkCandyAppleRed { get { return FromHtml("#FFA40000"); } } - public static XLColor DarkCerulean { get { return FromHtml("#FF08457E"); } } - public static XLColor DarkChampagne { get { return FromHtml("#FFC2B280"); } } - public static XLColor DarkChestnut { get { return FromHtml("#FF986960"); } } - public static XLColor DarkCoral { get { return FromHtml("#FFCD5B45"); } } - public static XLColor DarkElectricBlue { get { return FromHtml("#FF536878"); } } - public static XLColor DarkGreen1 { get { return FromHtml("#FF013220"); } } - public static XLColor DarkJungleGreen { get { return FromHtml("#FF1A2421"); } } - public static XLColor DarkLava { get { return FromHtml("#FF483C32"); } } - public static XLColor DarkLavender { get { return FromHtml("#FF734F96"); } } - public static XLColor DarkMidnightBlue { get { return FromHtml("#FF003366"); } } - public static XLColor DarkPastelBlue { get { return FromHtml("#FF779ECB"); } } - public static XLColor DarkPastelGreen { get { return FromHtml("#FF03C03C"); } } - public static XLColor DarkPastelPurple { get { return FromHtml("#FF966FD6"); } } - public static XLColor DarkPastelRed { get { return FromHtml("#FFC23B22"); } } - public static XLColor DarkPink { get { return FromHtml("#FFE75480"); } } - public static XLColor DarkPowderBlue { get { return FromHtml("#FF003399"); } } - public static XLColor DarkRaspberry { get { return FromHtml("#FF872657"); } } - public static XLColor DarkScarlet { get { return FromHtml("#FF560319"); } } - public static XLColor DarkSienna { get { return FromHtml("#FF3C1414"); } } - public static XLColor DarkSpringGreen { get { return FromHtml("#FF177245"); } } - public static XLColor DarkTan { get { return FromHtml("#FF918151"); } } - public static XLColor DarkTangerine { get { return FromHtml("#FFFFA812"); } } - public static XLColor DarkTaupe { get { return FromHtml("#FF483C32"); } } - public static XLColor DarkTerraCotta { get { return FromHtml("#FFCC4E5C"); } } - public static XLColor DartmouthGreen { get { return FromHtml("#FF00693E"); } } - public static XLColor DavysGrey { get { return FromHtml("#FF555555"); } } - public static XLColor DebianRed { get { return FromHtml("#FFD70A53"); } } - public static XLColor DeepCarmine { get { return FromHtml("#FFA9203E"); } } - public static XLColor DeepCarminePink { get { return FromHtml("#FFEF3038"); } } - public static XLColor DeepCarrotOrange { get { return FromHtml("#FFE9692C"); } } - public static XLColor DeepCerise { get { return FromHtml("#FFDA3287"); } } - public static XLColor DeepChampagne { get { return FromHtml("#FFFAD6A5"); } } - public static XLColor DeepChestnut { get { return FromHtml("#FFB94E48"); } } - public static XLColor DeepFuchsia { get { return FromHtml("#FFC154C1"); } } - public static XLColor DeepJungleGreen { get { return FromHtml("#FF004B49"); } } - public static XLColor DeepLilac { get { return FromHtml("#FF9955BB"); } } - public static XLColor DeepMagenta { get { return FromHtml("#FFCC00CC"); } } - public static XLColor DeepPeach { get { return FromHtml("#FFFFCBA4"); } } - public static XLColor DeepSaffron { get { return FromHtml("#FFFF9933"); } } - public static XLColor Denim { get { return FromHtml("#FF1560BD"); } } - public static XLColor Desert { get { return FromHtml("#FFC19A6B"); } } - public static XLColor DesertSand { get { return FromHtml("#FFEDC9AF"); } } - public static XLColor DogwoodRose { get { return FromHtml("#FFD71868"); } } - public static XLColor DollarBill { get { return FromHtml("#FF85BB65"); } } - public static XLColor Drab { get { return FromHtml("#FF967117"); } } - public static XLColor DukeBlue { get { return FromHtml("#FF00009C"); } } - public static XLColor EarthYellow { get { return FromHtml("#FFE1A95F"); } } - public static XLColor Ecru { get { return FromHtml("#FFC2B280"); } } - public static XLColor Eggplant { get { return FromHtml("#FF614051"); } } - public static XLColor Eggshell { get { return FromHtml("#FFF0EAD6"); } } - public static XLColor EgyptianBlue { get { return FromHtml("#FF1034A6"); } } - public static XLColor ElectricBlue { get { return FromHtml("#FF7DF9FF"); } } - public static XLColor ElectricCrimson { get { return FromHtml("#FFFF003F"); } } - public static XLColor ElectricIndigo { get { return FromHtml("#FF6F00FF"); } } - public static XLColor ElectricLavender { get { return FromHtml("#FFF4BBFF"); } } - public static XLColor ElectricLime { get { return FromHtml("#FFCCFF00"); } } - public static XLColor ElectricPurple { get { return FromHtml("#FFBF00FF"); } } - public static XLColor ElectricUltramarine { get { return FromHtml("#FF3F00FF"); } } - public static XLColor ElectricViolet { get { return FromHtml("#FF8F00FF"); } } - public static XLColor Emerald { get { return FromHtml("#FF50C878"); } } - public static XLColor EtonBlue { get { return FromHtml("#FF96C8A2"); } } - public static XLColor Fallow { get { return FromHtml("#FFC19A6B"); } } - public static XLColor FaluRed { get { return FromHtml("#FF801818"); } } - public static XLColor Fandango { get { return FromHtml("#FFB53389"); } } - public static XLColor FashionFuchsia { get { return FromHtml("#FFF400A1"); } } - public static XLColor Fawn { get { return FromHtml("#FFE5AA70"); } } - public static XLColor Feldgrau { get { return FromHtml("#FF4D5D53"); } } - public static XLColor FernGreen { get { return FromHtml("#FF4F7942"); } } - public static XLColor FerrariRed { get { return FromHtml("#FFFF2800"); } } - public static XLColor FieldDrab { get { return FromHtml("#FF6C541E"); } } - public static XLColor FireEngineRed { get { return FromHtml("#FFCE2029"); } } - public static XLColor Flame { get { return FromHtml("#FFE25822"); } } - public static XLColor FlamingoPink { get { return FromHtml("#FFFC8EAC"); } } - public static XLColor Flavescent { get { return FromHtml("#FFF7E98E"); } } - public static XLColor Flax { get { return FromHtml("#FFEEDC82"); } } - public static XLColor FluorescentOrange { get { return FromHtml("#FFFFBF00"); } } - public static XLColor FluorescentYellow { get { return FromHtml("#FFCCFF00"); } } - public static XLColor Folly { get { return FromHtml("#FFFF004F"); } } - public static XLColor ForestGreenTraditional { get { return FromHtml("#FF014421"); } } - public static XLColor FrenchBeige { get { return FromHtml("#FFA67B5B"); } } - public static XLColor FrenchBlue { get { return FromHtml("#FF0072BB"); } } - public static XLColor FrenchLilac { get { return FromHtml("#FF86608E"); } } - public static XLColor FrenchRose { get { return FromHtml("#FFF64A8A"); } } - public static XLColor FuchsiaPink { get { return FromHtml("#FFFF77FF"); } } - public static XLColor Fulvous { get { return FromHtml("#FFE48400"); } } - public static XLColor FuzzyWuzzy { get { return FromHtml("#FFCC6666"); } } - public static XLColor Gamboge { get { return FromHtml("#FFE49B0F"); } } - public static XLColor Ginger { get { return FromHtml("#FFF9F9FF"); } } - public static XLColor Glaucous { get { return FromHtml("#FF6082B6"); } } - public static XLColor GoldenBrown { get { return FromHtml("#FF996515"); } } - public static XLColor GoldenPoppy { get { return FromHtml("#FFFCC200"); } } - public static XLColor GoldenYellow { get { return FromHtml("#FFFFDF00"); } } - public static XLColor GoldMetallic { get { return FromHtml("#FFD4AF37"); } } - public static XLColor GrannySmithApple { get { return FromHtml("#FFA8E4A0"); } } - public static XLColor GrayAsparagus { get { return FromHtml("#FF465945"); } } - public static XLColor GreenPigment { get { return FromHtml("#FF00A550"); } } - public static XLColor GreenRyb { get { return FromHtml("#FF66B032"); } } - public static XLColor Grullo { get { return FromHtml("#FFA99A86"); } } - public static XLColor HalayaUbe { get { return FromHtml("#FF663854"); } } - public static XLColor HanBlue { get { return FromHtml("#FF446CCF"); } } - public static XLColor HanPurple { get { return FromHtml("#FF5218FA"); } } - public static XLColor HansaYellow { get { return FromHtml("#FFE9D66B"); } } - public static XLColor Harlequin { get { return FromHtml("#FF3FFF00"); } } - public static XLColor HarvardCrimson { get { return FromHtml("#FFC90016"); } } - public static XLColor HarvestGold { get { return FromHtml("#FFDA9100"); } } - public static XLColor Heliotrope { get { return FromHtml("#FFDF73FF"); } } - public static XLColor HollywoodCerise { get { return FromHtml("#FFF400A1"); } } - public static XLColor HookersGreen { get { return FromHtml("#FF007000"); } } - public static XLColor HotMagenta { get { return FromHtml("#FFFF1DCE"); } } - public static XLColor HunterGreen { get { return FromHtml("#FF355E3B"); } } - public static XLColor Iceberg { get { return FromHtml("#FF71A6D2"); } } - public static XLColor Icterine { get { return FromHtml("#FFFCF75E"); } } - public static XLColor Inchworm { get { return FromHtml("#FFB2EC5D"); } } - public static XLColor IndiaGreen { get { return FromHtml("#FF138808"); } } - public static XLColor IndianYellow { get { return FromHtml("#FFE3A857"); } } - public static XLColor IndigoDye { get { return FromHtml("#FF00416A"); } } - public static XLColor InternationalKleinBlue { get { return FromHtml("#FF002FA7"); } } - public static XLColor InternationalOrange { get { return FromHtml("#FFFF4F00"); } } - public static XLColor Iris { get { return FromHtml("#FF5A4FCF"); } } - public static XLColor Isabelline { get { return FromHtml("#FFF4F0EC"); } } - public static XLColor IslamicGreen { get { return FromHtml("#FF009000"); } } - public static XLColor Jade { get { return FromHtml("#FF00A86B"); } } - public static XLColor Jasper { get { return FromHtml("#FFD73B3E"); } } - public static XLColor JazzberryJam { get { return FromHtml("#FFA50B5E"); } } - public static XLColor Jonquil { get { return FromHtml("#FFFADA5E"); } } - public static XLColor JuneBud { get { return FromHtml("#FFBDDA57"); } } - public static XLColor JungleGreen { get { return FromHtml("#FF29AB87"); } } - public static XLColor KellyGreen { get { return FromHtml("#FF4CBB17"); } } - public static XLColor KhakiHtmlCssKhaki { get { return FromHtml("#FFC3B091"); } } - public static XLColor LanguidLavender { get { return FromHtml("#FFD6CADD"); } } - public static XLColor LapisLazuli { get { return FromHtml("#FF26619C"); } } - public static XLColor LaSalleGreen { get { return FromHtml("#FF087830"); } } - public static XLColor LaserLemon { get { return FromHtml("#FFFEFE22"); } } - public static XLColor Lava { get { return FromHtml("#FFCF1020"); } } - public static XLColor LavenderBlue { get { return FromHtml("#FFCCCCFF"); } } - public static XLColor LavenderFloral { get { return FromHtml("#FFB57EDC"); } } - public static XLColor LavenderGray { get { return FromHtml("#FFC4C3D0"); } } - public static XLColor LavenderIndigo { get { return FromHtml("#FF9457EB"); } } - public static XLColor LavenderPink { get { return FromHtml("#FFFBAED2"); } } - public static XLColor LavenderPurple { get { return FromHtml("#FF967BB6"); } } - public static XLColor LavenderRose { get { return FromHtml("#FFFBA0E3"); } } - public static XLColor Lemon { get { return FromHtml("#FFFFF700"); } } - public static XLColor LightApricot { get { return FromHtml("#FFFDD5B1"); } } - public static XLColor LightBrown { get { return FromHtml("#FFB5651D"); } } - public static XLColor LightCarminePink { get { return FromHtml("#FFE66771"); } } - public static XLColor LightCornflowerBlue { get { return FromHtml("#FF93CCEA"); } } - public static XLColor LightFuchsiaPink { get { return FromHtml("#FFF984EF"); } } - public static XLColor LightMauve { get { return FromHtml("#FFDCD0FF"); } } - public static XLColor LightPastelPurple { get { return FromHtml("#FFB19CD9"); } } - public static XLColor LightSalmonPink { get { return FromHtml("#FFFF9999"); } } - public static XLColor LightTaupe { get { return FromHtml("#FFB38B6D"); } } - public static XLColor LightThulianPink { get { return FromHtml("#FFE68FAC"); } } - public static XLColor LightYellow1 { get { return FromHtml("#FFFFFFED"); } } - public static XLColor Lilac { get { return FromHtml("#FFC8A2C8"); } } - public static XLColor LimeColorWheel { get { return FromHtml("#FFBFFF00"); } } - public static XLColor LincolnGreen { get { return FromHtml("#FF195905"); } } - public static XLColor Liver { get { return FromHtml("#FF534B4F"); } } - public static XLColor Lust { get { return FromHtml("#FFE62020"); } } - public static XLColor MacaroniAndCheese { get { return FromHtml("#FFFFBD88"); } } - public static XLColor MagentaDye { get { return FromHtml("#FFCA1F7B"); } } - public static XLColor MagentaProcess { get { return FromHtml("#FFFF0090"); } } - public static XLColor MagicMint { get { return FromHtml("#FFAAF0D1"); } } - public static XLColor Magnolia { get { return FromHtml("#FFF8F4FF"); } } - public static XLColor Mahogany { get { return FromHtml("#FFC04000"); } } - public static XLColor Maize { get { return FromHtml("#FFFBEC5D"); } } - public static XLColor MajorelleBlue { get { return FromHtml("#FF6050DC"); } } - public static XLColor Malachite { get { return FromHtml("#FF0BDA51"); } } - public static XLColor Manatee { get { return FromHtml("#FF979AAA"); } } - public static XLColor MangoTango { get { return FromHtml("#FFFF8243"); } } - public static XLColor MaroonX11 { get { return FromHtml("#FFB03060"); } } - public static XLColor Mauve { get { return FromHtml("#FFE0B0FF"); } } - public static XLColor Mauvelous { get { return FromHtml("#FFEF98AA"); } } - public static XLColor MauveTaupe { get { return FromHtml("#FF915F6D"); } } - public static XLColor MayaBlue { get { return FromHtml("#FF73C2FB"); } } - public static XLColor MeatBrown { get { return FromHtml("#FFE5B73B"); } } - public static XLColor MediumAquamarine1 { get { return FromHtml("#FF66DDAA"); } } - public static XLColor MediumCandyAppleRed { get { return FromHtml("#FFE2062C"); } } - public static XLColor MediumCarmine { get { return FromHtml("#FFAF4035"); } } - public static XLColor MediumChampagne { get { return FromHtml("#FFF3E5AB"); } } - public static XLColor MediumElectricBlue { get { return FromHtml("#FF035096"); } } - public static XLColor MediumJungleGreen { get { return FromHtml("#FF1C352D"); } } - public static XLColor MediumPersianBlue { get { return FromHtml("#FF0067A5"); } } - public static XLColor MediumRedViolet { get { return FromHtml("#FFBB3385"); } } - public static XLColor MediumSpringBud { get { return FromHtml("#FFC9DC87"); } } - public static XLColor MediumTaupe { get { return FromHtml("#FF674C47"); } } - public static XLColor Melon { get { return FromHtml("#FFFDBCB4"); } } - public static XLColor MidnightGreenEagleGreen { get { return FromHtml("#FF004953"); } } - public static XLColor MikadoYellow { get { return FromHtml("#FFFFC40C"); } } - public static XLColor Mint { get { return FromHtml("#FF3EB489"); } } - public static XLColor MintGreen { get { return FromHtml("#FF98FF98"); } } - public static XLColor ModeBeige { get { return FromHtml("#FF967117"); } } - public static XLColor MoonstoneBlue { get { return FromHtml("#FF73A9C2"); } } - public static XLColor MordantRed19 { get { return FromHtml("#FFAE0C00"); } } - public static XLColor MossGreen { get { return FromHtml("#FFADDFAD"); } } - public static XLColor MountainMeadow { get { return FromHtml("#FF30BA8F"); } } - public static XLColor MountbattenPink { get { return FromHtml("#FF997A8D"); } } - public static XLColor MsuGreen { get { return FromHtml("#FF18453B"); } } - public static XLColor Mulberry { get { return FromHtml("#FFC54B8C"); } } - public static XLColor Mustard { get { return FromHtml("#FFFFDB58"); } } - public static XLColor Myrtle { get { return FromHtml("#FF21421E"); } } - public static XLColor NadeshikoPink { get { return FromHtml("#FFF6ADC6"); } } - public static XLColor NapierGreen { get { return FromHtml("#FF2A8000"); } } - public static XLColor NaplesYellow { get { return FromHtml("#FFFADA5E"); } } - public static XLColor NeonCarrot { get { return FromHtml("#FFFFA343"); } } - public static XLColor NeonFuchsia { get { return FromHtml("#FFFE59C2"); } } - public static XLColor NeonGreen { get { return FromHtml("#FF39FF14"); } } - public static XLColor NonPhotoBlue { get { return FromHtml("#FFA4DDED"); } } - public static XLColor OceanBoatBlue { get { return FromHtml("#FFCC7422"); } } - public static XLColor Ochre { get { return FromHtml("#FFCC7722"); } } - public static XLColor OldGold { get { return FromHtml("#FFCFB53B"); } } - public static XLColor OldLavender { get { return FromHtml("#FF796878"); } } - public static XLColor OldMauve { get { return FromHtml("#FF673147"); } } - public static XLColor OldRose { get { return FromHtml("#FFC08081"); } } - public static XLColor OliveDrab7 { get { return FromHtml("#FF3C341F"); } } - public static XLColor Olivine { get { return FromHtml("#FF9AB973"); } } - public static XLColor Onyx { get { return FromHtml("#FF0F0F0F"); } } - public static XLColor OperaMauve { get { return FromHtml("#FFB784A7"); } } - public static XLColor OrangeColorWheel { get { return FromHtml("#FFFF7F00"); } } - public static XLColor OrangePeel { get { return FromHtml("#FFFF9F00"); } } - public static XLColor OrangeRyb { get { return FromHtml("#FFFB9902"); } } - public static XLColor OtterBrown { get { return FromHtml("#FF654321"); } } - public static XLColor OuCrimsonRed { get { return FromHtml("#FF990000"); } } - public static XLColor OuterSpace { get { return FromHtml("#FF414A4C"); } } - public static XLColor OutrageousOrange { get { return FromHtml("#FFFF6E4A"); } } - public static XLColor OxfordBlue { get { return FromHtml("#FF002147"); } } - public static XLColor PakistanGreen { get { return FromHtml("#FF00421B"); } } - public static XLColor PalatinateBlue { get { return FromHtml("#FF273BE2"); } } - public static XLColor PalatinatePurple { get { return FromHtml("#FF682860"); } } - public static XLColor PaleAqua { get { return FromHtml("#FFBCD4E6"); } } - public static XLColor PaleBrown { get { return FromHtml("#FF987654"); } } - public static XLColor PaleCarmine { get { return FromHtml("#FFAF4035"); } } - public static XLColor PaleCerulean { get { return FromHtml("#FF9BC4E2"); } } - public static XLColor PaleChestnut { get { return FromHtml("#FFDDADAF"); } } - public static XLColor PaleCopper { get { return FromHtml("#FFDA8A67"); } } - public static XLColor PaleCornflowerBlue { get { return FromHtml("#FFABCDEF"); } } - public static XLColor PaleGold { get { return FromHtml("#FFE6BE8A"); } } - public static XLColor PaleMagenta { get { return FromHtml("#FFF984E5"); } } - public static XLColor PalePink { get { return FromHtml("#FFFADADD"); } } - public static XLColor PaleRobinEggBlue { get { return FromHtml("#FF96DED1"); } } - public static XLColor PaleSilver { get { return FromHtml("#FFC9C0BB"); } } - public static XLColor PaleSpringBud { get { return FromHtml("#FFECEBBD"); } } - public static XLColor PaleTaupe { get { return FromHtml("#FFBC987E"); } } - public static XLColor PansyPurple { get { return FromHtml("#FF78184A"); } } - public static XLColor ParisGreen { get { return FromHtml("#FF50C878"); } } - public static XLColor PastelBlue { get { return FromHtml("#FFAEC6CF"); } } - public static XLColor PastelBrown { get { return FromHtml("#FF836953"); } } - public static XLColor PastelGray { get { return FromHtml("#FFCFCFC4"); } } - public static XLColor PastelGreen { get { return FromHtml("#FF77DD77"); } } - public static XLColor PastelMagenta { get { return FromHtml("#FFF49AC2"); } } - public static XLColor PastelOrange { get { return FromHtml("#FFFFB347"); } } - public static XLColor PastelPink { get { return FromHtml("#FFFFD1DC"); } } - public static XLColor PastelPurple { get { return FromHtml("#FFB39EB5"); } } - public static XLColor PastelRed { get { return FromHtml("#FFFF6961"); } } - public static XLColor PastelViolet { get { return FromHtml("#FFCB99C9"); } } - public static XLColor PastelYellow { get { return FromHtml("#FFFDFD96"); } } - public static XLColor PaynesGrey { get { return FromHtml("#FF40404F"); } } - public static XLColor Peach { get { return FromHtml("#FFFFE5B4"); } } - public static XLColor PeachOrange { get { return FromHtml("#FFFFCC99"); } } - public static XLColor PeachYellow { get { return FromHtml("#FFFADFAD"); } } - public static XLColor Pear { get { return FromHtml("#FFD1E231"); } } - public static XLColor Pearl { get { return FromHtml("#FFF0EAD6"); } } - public static XLColor Peridot { get { return FromHtml("#FFE6E200"); } } - public static XLColor Periwinkle { get { return FromHtml("#FFCCCCFF"); } } - public static XLColor PersianBlue { get { return FromHtml("#FF1C39BB"); } } - public static XLColor PersianGreen { get { return FromHtml("#FF00A693"); } } - public static XLColor PersianIndigo { get { return FromHtml("#FF32127A"); } } - public static XLColor PersianOrange { get { return FromHtml("#FFD99058"); } } - public static XLColor PersianPink { get { return FromHtml("#FFF77FBE"); } } - public static XLColor PersianPlum { get { return FromHtml("#FF701C1C"); } } - public static XLColor PersianRed { get { return FromHtml("#FFCC3333"); } } - public static XLColor PersianRose { get { return FromHtml("#FFFE28A2"); } } - public static XLColor Persimmon { get { return FromHtml("#FFEC5800"); } } - public static XLColor Phlox { get { return FromHtml("#FFDF00FF"); } } - public static XLColor PhthaloBlue { get { return FromHtml("#FF000F89"); } } - public static XLColor PhthaloGreen { get { return FromHtml("#FF123524"); } } - public static XLColor PiggyPink { get { return FromHtml("#FFFDDDE6"); } } - public static XLColor PineGreen { get { return FromHtml("#FF01796F"); } } - public static XLColor PinkOrange { get { return FromHtml("#FFFF9966"); } } - public static XLColor PinkPearl { get { return FromHtml("#FFE7ACCF"); } } - public static XLColor PinkSherbet { get { return FromHtml("#FFF78FA7"); } } - public static XLColor Pistachio { get { return FromHtml("#FF93C572"); } } - public static XLColor Platinum { get { return FromHtml("#FFE5E4E2"); } } - public static XLColor PlumTraditional { get { return FromHtml("#FF8E4585"); } } - public static XLColor PortlandOrange { get { return FromHtml("#FFFF5A36"); } } - public static XLColor PrincetonOrange { get { return FromHtml("#FFFF8F00"); } } - public static XLColor Prune { get { return FromHtml("#FF701C1C"); } } - public static XLColor PrussianBlue { get { return FromHtml("#FF003153"); } } - public static XLColor PsychedelicPurple { get { return FromHtml("#FFDF00FF"); } } - public static XLColor Puce { get { return FromHtml("#FFCC8899"); } } - public static XLColor Pumpkin { get { return FromHtml("#FFFF7518"); } } - public static XLColor PurpleHeart { get { return FromHtml("#FF69359C"); } } - public static XLColor PurpleMountainMajesty { get { return FromHtml("#FF9678B6"); } } - public static XLColor PurpleMunsell { get { return FromHtml("#FF9F00C5"); } } - public static XLColor PurplePizzazz { get { return FromHtml("#FFFE4EDA"); } } - public static XLColor PurpleTaupe { get { return FromHtml("#FF50404D"); } } - public static XLColor PurpleX11 { get { return FromHtml("#FFA020F0"); } } - public static XLColor RadicalRed { get { return FromHtml("#FFFF355E"); } } - public static XLColor Raspberry { get { return FromHtml("#FFE30B5D"); } } - public static XLColor RaspberryGlace { get { return FromHtml("#FF915F6D"); } } - public static XLColor RaspberryPink { get { return FromHtml("#FFE25098"); } } - public static XLColor RaspberryRose { get { return FromHtml("#FFB3446C"); } } - public static XLColor RawUmber { get { return FromHtml("#FF826644"); } } - public static XLColor RazzleDazzleRose { get { return FromHtml("#FFFF33CC"); } } - public static XLColor Razzmatazz { get { return FromHtml("#FFE3256B"); } } - public static XLColor RedMunsell { get { return FromHtml("#FFF2003C"); } } - public static XLColor RedNcs { get { return FromHtml("#FFC40233"); } } - public static XLColor RedPigment { get { return FromHtml("#FFED1C24"); } } - public static XLColor RedRyb { get { return FromHtml("#FFFE2712"); } } - public static XLColor Redwood { get { return FromHtml("#FFAB4E52"); } } - public static XLColor Regalia { get { return FromHtml("#FF522D80"); } } - public static XLColor RichBlack { get { return FromHtml("#FF004040"); } } - public static XLColor RichBrilliantLavender { get { return FromHtml("#FFF1A7FE"); } } - public static XLColor RichCarmine { get { return FromHtml("#FFD70040"); } } - public static XLColor RichElectricBlue { get { return FromHtml("#FF0892D0"); } } - public static XLColor RichLavender { get { return FromHtml("#FFA76BCF"); } } - public static XLColor RichLilac { get { return FromHtml("#FFB666D2"); } } - public static XLColor RichMaroon { get { return FromHtml("#FFB03060"); } } - public static XLColor RifleGreen { get { return FromHtml("#FF414833"); } } - public static XLColor RobinEggBlue { get { return FromHtml("#FF00CCCC"); } } - public static XLColor Rose { get { return FromHtml("#FFFF007F"); } } - public static XLColor RoseBonbon { get { return FromHtml("#FFF9429E"); } } - public static XLColor RoseEbony { get { return FromHtml("#FF674846"); } } - public static XLColor RoseGold { get { return FromHtml("#FFB76E79"); } } - public static XLColor RoseMadder { get { return FromHtml("#FFE32636"); } } - public static XLColor RosePink { get { return FromHtml("#FFFF66CC"); } } - public static XLColor RoseQuartz { get { return FromHtml("#FFAA98A9"); } } - public static XLColor RoseTaupe { get { return FromHtml("#FF905D5D"); } } - public static XLColor RoseVale { get { return FromHtml("#FFAB4E52"); } } - public static XLColor Rosewood { get { return FromHtml("#FF65000B"); } } - public static XLColor RossoCorsa { get { return FromHtml("#FFD40000"); } } - public static XLColor RoyalAzure { get { return FromHtml("#FF0038A8"); } } - public static XLColor RoyalBlueTraditional { get { return FromHtml("#FF002366"); } } - public static XLColor RoyalFuchsia { get { return FromHtml("#FFCA2C92"); } } - public static XLColor RoyalPurple { get { return FromHtml("#FF7851A9"); } } - public static XLColor Ruby { get { return FromHtml("#FFE0115F"); } } - public static XLColor Ruddy { get { return FromHtml("#FFFF0028"); } } - public static XLColor RuddyBrown { get { return FromHtml("#FFBB6528"); } } - public static XLColor RuddyPink { get { return FromHtml("#FFE18E96"); } } - public static XLColor Rufous { get { return FromHtml("#FFA81C07"); } } - public static XLColor Russet { get { return FromHtml("#FF80461B"); } } - public static XLColor Rust { get { return FromHtml("#FFB7410E"); } } - public static XLColor SacramentoStateGreen { get { return FromHtml("#FF00563F"); } } - public static XLColor SafetyOrangeBlazeOrange { get { return FromHtml("#FFFF6700"); } } - public static XLColor Saffron { get { return FromHtml("#FFF4C430"); } } - public static XLColor Salmon1 { get { return FromHtml("#FFFF8C69"); } } - public static XLColor SalmonPink { get { return FromHtml("#FFFF91A4"); } } - public static XLColor Sand { get { return FromHtml("#FFC2B280"); } } - public static XLColor SandDune { get { return FromHtml("#FF967117"); } } - public static XLColor Sandstorm { get { return FromHtml("#FFECD540"); } } - public static XLColor SandyTaupe { get { return FromHtml("#FF967117"); } } - public static XLColor Sangria { get { return FromHtml("#FF92000A"); } } - public static XLColor SapGreen { get { return FromHtml("#FF507D2A"); } } - public static XLColor Sapphire { get { return FromHtml("#FF082567"); } } - public static XLColor SatinSheenGold { get { return FromHtml("#FFCBA135"); } } - public static XLColor Scarlet { get { return FromHtml("#FFFF2000"); } } - public static XLColor SchoolBusYellow { get { return FromHtml("#FFFFD800"); } } - public static XLColor ScreaminGreen { get { return FromHtml("#FF76FF7A"); } } - public static XLColor SealBrown { get { return FromHtml("#FF321414"); } } - public static XLColor SelectiveYellow { get { return FromHtml("#FFFFBA00"); } } - public static XLColor Sepia { get { return FromHtml("#FF704214"); } } - public static XLColor Shadow { get { return FromHtml("#FF8A795D"); } } - public static XLColor ShamrockGreen { get { return FromHtml("#FF009E60"); } } - public static XLColor ShockingPink { get { return FromHtml("#FFFC0FC0"); } } - public static XLColor Sienna1 { get { return FromHtml("#FF882D17"); } } - public static XLColor Sinopia { get { return FromHtml("#FFCB410B"); } } - public static XLColor Skobeloff { get { return FromHtml("#FF007474"); } } - public static XLColor SkyMagenta { get { return FromHtml("#FFCF71AF"); } } - public static XLColor SmaltDarkPowderBlue { get { return FromHtml("#FF003399"); } } - public static XLColor SmokeyTopaz { get { return FromHtml("#FF933D41"); } } - public static XLColor SmokyBlack { get { return FromHtml("#FF100C08"); } } - public static XLColor SpiroDiscoBall { get { return FromHtml("#FF0FC0FC"); } } - public static XLColor SplashedWhite { get { return FromHtml("#FFFEFDFF"); } } - public static XLColor SpringBud { get { return FromHtml("#FFA7FC00"); } } - public static XLColor StPatricksBlue { get { return FromHtml("#FF23297A"); } } - public static XLColor StilDeGrainYellow { get { return FromHtml("#FFFADA5E"); } } - public static XLColor Straw { get { return FromHtml("#FFE4D96F"); } } - public static XLColor Sunglow { get { return FromHtml("#FFFFCC33"); } } - public static XLColor Sunset { get { return FromHtml("#FFFAD6A5"); } } - public static XLColor Tangelo { get { return FromHtml("#FFF94D00"); } } - public static XLColor Tangerine { get { return FromHtml("#FFF28500"); } } - public static XLColor TangerineYellow { get { return FromHtml("#FFFFCC00"); } } - public static XLColor Taupe { get { return FromHtml("#FF483C32"); } } - public static XLColor TaupeGray { get { return FromHtml("#FF8B8589"); } } - public static XLColor TeaGreen { get { return FromHtml("#FFD0F0C0"); } } - public static XLColor TealBlue { get { return FromHtml("#FF367588"); } } - public static XLColor TealGreen { get { return FromHtml("#FF006D5B"); } } - public static XLColor TeaRoseOrange { get { return FromHtml("#FFF88379"); } } - public static XLColor TeaRoseRose { get { return FromHtml("#FFF4C2C2"); } } - public static XLColor TennéTawny { get { return FromHtml("#FFCD5700"); } } - public static XLColor TerraCotta { get { return FromHtml("#FFE2725B"); } } - public static XLColor ThulianPink { get { return FromHtml("#FFDE6FA1"); } } - public static XLColor TickleMePink { get { return FromHtml("#FFFC89AC"); } } - public static XLColor TiffanyBlue { get { return FromHtml("#FF0ABAB5"); } } - public static XLColor TigersEye { get { return FromHtml("#FFE08D3C"); } } - public static XLColor Timberwolf { get { return FromHtml("#FFDBD7D2"); } } - public static XLColor TitaniumYellow { get { return FromHtml("#FFEEE600"); } } - public static XLColor Toolbox { get { return FromHtml("#FF746CC0"); } } - public static XLColor TractorRed { get { return FromHtml("#FFFD0E35"); } } - public static XLColor TropicalRainForest { get { return FromHtml("#FF00755E"); } } - public static XLColor TuftsBlue { get { return FromHtml("#FF417DC1"); } } - public static XLColor Tumbleweed { get { return FromHtml("#FFDEAA88"); } } - public static XLColor TurkishRose { get { return FromHtml("#FFB57281"); } } - public static XLColor Turquoise1 { get { return FromHtml("#FF30D5C8"); } } - public static XLColor TurquoiseBlue { get { return FromHtml("#FF00FFEF"); } } - public static XLColor TurquoiseGreen { get { return FromHtml("#FFA0D6B4"); } } - public static XLColor TuscanRed { get { return FromHtml("#FF823535"); } } - public static XLColor TwilightLavender { get { return FromHtml("#FF8A496B"); } } - public static XLColor TyrianPurple { get { return FromHtml("#FF66023C"); } } - public static XLColor UaBlue { get { return FromHtml("#FF0033AA"); } } - public static XLColor UaRed { get { return FromHtml("#FFD9004C"); } } - public static XLColor Ube { get { return FromHtml("#FF8878C3"); } } - public static XLColor UclaBlue { get { return FromHtml("#FF536895"); } } - public static XLColor UclaGold { get { return FromHtml("#FFFFB300"); } } - public static XLColor UfoGreen { get { return FromHtml("#FF3CD070"); } } - public static XLColor Ultramarine { get { return FromHtml("#FF120A8F"); } } - public static XLColor UltramarineBlue { get { return FromHtml("#FF4166F5"); } } - public static XLColor UltraPink { get { return FromHtml("#FFFF6FFF"); } } - public static XLColor Umber { get { return FromHtml("#FF635147"); } } - public static XLColor UnitedNationsBlue { get { return FromHtml("#FF5B92E5"); } } - public static XLColor UnmellowYellow { get { return FromHtml("#FFFFFF66"); } } - public static XLColor UpForestGreen { get { return FromHtml("#FF014421"); } } - public static XLColor UpMaroon { get { return FromHtml("#FF7B1113"); } } - public static XLColor UpsdellRed { get { return FromHtml("#FFAE2029"); } } - public static XLColor Urobilin { get { return FromHtml("#FFE1AD21"); } } - public static XLColor UscCardinal { get { return FromHtml("#FF990000"); } } - public static XLColor UscGold { get { return FromHtml("#FFFFCC00"); } } - public static XLColor UtahCrimson { get { return FromHtml("#FFD3003F"); } } - public static XLColor Vanilla { get { return FromHtml("#FFF3E5AB"); } } - public static XLColor VegasGold { get { return FromHtml("#FFC5B358"); } } - public static XLColor VenetianRed { get { return FromHtml("#FFC80815"); } } - public static XLColor Verdigris { get { return FromHtml("#FF43B3AE"); } } - public static XLColor Vermilion { get { return FromHtml("#FFE34234"); } } - public static XLColor Veronica { get { return FromHtml("#FFA020F0"); } } - public static XLColor Violet1 { get { return FromHtml("#FF8F00FF"); } } - public static XLColor VioletColorWheel { get { return FromHtml("#FF7F00FF"); } } - public static XLColor VioletRyb { get { return FromHtml("#FF8601AF"); } } - public static XLColor Viridian { get { return FromHtml("#FF40826D"); } } - public static XLColor VividAuburn { get { return FromHtml("#FF922724"); } } - public static XLColor VividBurgundy { get { return FromHtml("#FF9F1D35"); } } - public static XLColor VividCerise { get { return FromHtml("#FFDA1D81"); } } - public static XLColor VividTangerine { get { return FromHtml("#FFFFA089"); } } - public static XLColor VividViolet { get { return FromHtml("#FF9F00FF"); } } - public static XLColor WarmBlack { get { return FromHtml("#FF004242"); } } - public static XLColor Wenge { get { return FromHtml("#FF645452"); } } - public static XLColor WildBlueYonder { get { return FromHtml("#FFA2ADD0"); } } - public static XLColor WildStrawberry { get { return FromHtml("#FFFF43A4"); } } - public static XLColor WildWatermelon { get { return FromHtml("#FFFC6C85"); } } - public static XLColor Wisteria { get { return FromHtml("#FFC9A0DC"); } } - public static XLColor Xanadu { get { return FromHtml("#FF738678"); } } - public static XLColor YaleBlue { get { return FromHtml("#FF0F4D92"); } } - public static XLColor YellowMunsell { get { return FromHtml("#FFEFCC00"); } } - public static XLColor YellowNcs { get { return FromHtml("#FFFFD300"); } } - public static XLColor YellowProcess { get { return FromHtml("#FFFFEF00"); } } - public static XLColor YellowRyb { get { return FromHtml("#FFFEFE33"); } } - public static XLColor Zaffre { get { return FromHtml("#FF0014A8"); } } - public static XLColor ZinnwalditeBrown { get { return FromHtml("#FF2C1608"); } } + public static IXLColor AliceBlue { get { return FromColor(Color.AliceBlue); } } + public static IXLColor AntiqueWhite { get { return FromColor(Color.AntiqueWhite); } } + public static IXLColor Aqua { get { return FromColor(Color.Aqua); } } + public static IXLColor Aquamarine { get { return FromColor(Color.Aquamarine); } } + public static IXLColor Azure { get { return FromColor(Color.Azure); } } + public static IXLColor Beige { get { return FromColor(Color.Beige); } } + public static IXLColor Bisque { get { return FromColor(Color.Bisque); } } + public static IXLColor Black { get { return FromColor(Color.Black); } } + public static IXLColor BlanchedAlmond { get { return FromColor(Color.BlanchedAlmond); } } + public static IXLColor Blue { get { return FromColor(Color.Blue); } } + public static IXLColor BlueViolet { get { return FromColor(Color.BlueViolet); } } + public static IXLColor Brown { get { return FromColor(Color.Brown); } } + public static IXLColor BurlyWood { get { return FromColor(Color.BurlyWood); } } + public static IXLColor CadetBlue { get { return FromColor(Color.CadetBlue); } } + public static IXLColor Chartreuse { get { return FromColor(Color.Chartreuse); } } + public static IXLColor Chocolate { get { return FromColor(Color.Chocolate); } } + public static IXLColor Coral { get { return FromColor(Color.Coral); } } + public static IXLColor CornflowerBlue { get { return FromColor(Color.CornflowerBlue); } } + public static IXLColor Cornsilk { get { return FromColor(Color.Cornsilk); } } + public static IXLColor Crimson { get { return FromColor(Color.Crimson); } } + public static IXLColor Cyan { get { return FromColor(Color.Cyan); } } + public static IXLColor DarkBlue { get { return FromColor(Color.DarkBlue); } } + public static IXLColor DarkCyan { get { return FromColor(Color.DarkCyan); } } + public static IXLColor DarkGoldenrod { get { return FromColor(Color.DarkGoldenrod); } } + public static IXLColor DarkGray { get { return FromColor(Color.DarkGray); } } + public static IXLColor DarkGreen { get { return FromColor(Color.DarkGreen); } } + public static IXLColor DarkKhaki { get { return FromColor(Color.DarkKhaki); } } + public static IXLColor DarkMagenta { get { return FromColor(Color.DarkMagenta); } } + public static IXLColor DarkOliveGreen { get { return FromColor(Color.DarkOliveGreen); } } + public static IXLColor DarkOrange { get { return FromColor(Color.DarkOrange); } } + public static IXLColor DarkOrchid { get { return FromColor(Color.DarkOrchid); } } + public static IXLColor DarkRed { get { return FromColor(Color.DarkRed); } } + public static IXLColor DarkSalmon { get { return FromColor(Color.DarkSalmon); } } + public static IXLColor DarkSeaGreen { get { return FromColor(Color.DarkSeaGreen); } } + public static IXLColor DarkSlateBlue { get { return FromColor(Color.DarkSlateBlue); } } + public static IXLColor DarkSlateGray { get { return FromColor(Color.DarkSlateGray); } } + public static IXLColor DarkTurquoise { get { return FromColor(Color.DarkTurquoise); } } + public static IXLColor DarkViolet { get { return FromColor(Color.DarkViolet); } } + public static IXLColor DeepPink { get { return FromColor(Color.DeepPink); } } + public static IXLColor DeepSkyBlue { get { return FromColor(Color.DeepSkyBlue); } } + public static IXLColor DimGray { get { return FromColor(Color.DimGray); } } + public static IXLColor DodgerBlue { get { return FromColor(Color.DodgerBlue); } } + public static IXLColor Firebrick { get { return FromColor(Color.Firebrick); } } + public static IXLColor FloralWhite { get { return FromColor(Color.FloralWhite); } } + public static IXLColor ForestGreen { get { return FromColor(Color.ForestGreen); } } + public static IXLColor Fuchsia { get { return FromColor(Color.Fuchsia); } } + public static IXLColor Gainsboro { get { return FromColor(Color.Gainsboro); } } + public static IXLColor GhostWhite { get { return FromColor(Color.GhostWhite); } } + public static IXLColor Gold { get { return FromColor(Color.Gold); } } + public static IXLColor Goldenrod { get { return FromColor(Color.Goldenrod); } } + public static IXLColor Gray { get { return FromColor(Color.Gray); } } + public static IXLColor Green { get { return FromColor(Color.Green); } } + public static IXLColor GreenYellow { get { return FromColor(Color.GreenYellow); } } + public static IXLColor Honeydew { get { return FromColor(Color.Honeydew); } } + public static IXLColor HotPink { get { return FromColor(Color.HotPink); } } + public static IXLColor IndianRed { get { return FromColor(Color.IndianRed); } } + public static IXLColor Indigo { get { return FromColor(Color.Indigo); } } + public static IXLColor Ivory { get { return FromColor(Color.Ivory); } } + public static IXLColor Khaki { get { return FromColor(Color.Khaki); } } + public static IXLColor Lavender { get { return FromColor(Color.Lavender); } } + public static IXLColor LavenderBlush { get { return FromColor(Color.LavenderBlush); } } + public static IXLColor LawnGreen { get { return FromColor(Color.LawnGreen); } } + public static IXLColor LemonChiffon { get { return FromColor(Color.LemonChiffon); } } + public static IXLColor LightBlue { get { return FromColor(Color.LightBlue); } } + public static IXLColor LightCoral { get { return FromColor(Color.LightCoral); } } + public static IXLColor LightCyan { get { return FromColor(Color.LightCyan); } } + public static IXLColor LightGoldenrodYellow { get { return FromColor(Color.LightGoldenrodYellow); } } + public static IXLColor LightGray { get { return FromColor(Color.LightGray); } } + public static IXLColor LightGreen { get { return FromColor(Color.LightGreen); } } + public static IXLColor LightPink { get { return FromColor(Color.LightPink); } } + public static IXLColor LightSalmon { get { return FromColor(Color.LightSalmon); } } + public static IXLColor LightSeaGreen { get { return FromColor(Color.LightSeaGreen); } } + public static IXLColor LightSkyBlue { get { return FromColor(Color.LightSkyBlue); } } + public static IXLColor LightSlateGray { get { return FromColor(Color.LightSlateGray); } } + public static IXLColor LightSteelBlue { get { return FromColor(Color.LightSteelBlue); } } + public static IXLColor LightYellow { get { return FromColor(Color.LightYellow); } } + public static IXLColor Lime { get { return FromColor(Color.Lime); } } + public static IXLColor LimeGreen { get { return FromColor(Color.LimeGreen); } } + public static IXLColor Linen { get { return FromColor(Color.Linen); } } + public static IXLColor Magenta { get { return FromColor(Color.Magenta); } } + public static IXLColor Maroon { get { return FromColor(Color.Maroon); } } + public static IXLColor MediumAquamarine { get { return FromColor(Color.MediumAquamarine); } } + public static IXLColor MediumBlue { get { return FromColor(Color.MediumBlue); } } + public static IXLColor MediumOrchid { get { return FromColor(Color.MediumOrchid); } } + public static IXLColor MediumPurple { get { return FromColor(Color.MediumPurple); } } + public static IXLColor MediumSeaGreen { get { return FromColor(Color.MediumSeaGreen); } } + public static IXLColor MediumSlateBlue { get { return FromColor(Color.MediumSlateBlue); } } + public static IXLColor MediumSpringGreen { get { return FromColor(Color.MediumSpringGreen); } } + public static IXLColor MediumTurquoise { get { return FromColor(Color.MediumTurquoise); } } + public static IXLColor MediumVioletRed { get { return FromColor(Color.MediumVioletRed); } } + public static IXLColor MidnightBlue { get { return FromColor(Color.MidnightBlue); } } + public static IXLColor MintCream { get { return FromColor(Color.MintCream); } } + public static IXLColor MistyRose { get { return FromColor(Color.MistyRose); } } + public static IXLColor Moccasin { get { return FromColor(Color.Moccasin); } } + public static IXLColor NavajoWhite { get { return FromColor(Color.NavajoWhite); } } + public static IXLColor Navy { get { return FromColor(Color.Navy); } } + public static IXLColor OldLace { get { return FromColor(Color.OldLace); } } + public static IXLColor Olive { get { return FromColor(Color.Olive); } } + public static IXLColor OliveDrab { get { return FromColor(Color.OliveDrab); } } + public static IXLColor Orange { get { return FromColor(Color.Orange); } } + public static IXLColor OrangeRed { get { return FromColor(Color.OrangeRed); } } + public static IXLColor Orchid { get { return FromColor(Color.Orchid); } } + public static IXLColor PaleGoldenrod { get { return FromColor(Color.PaleGoldenrod); } } + public static IXLColor PaleGreen { get { return FromColor(Color.PaleGreen); } } + public static IXLColor PaleTurquoise { get { return FromColor(Color.PaleTurquoise); } } + public static IXLColor PaleVioletRed { get { return FromColor(Color.PaleVioletRed); } } + public static IXLColor PapayaWhip { get { return FromColor(Color.PapayaWhip); } } + public static IXLColor PeachPuff { get { return FromColor(Color.PeachPuff); } } + public static IXLColor Peru { get { return FromColor(Color.Peru); } } + public static IXLColor Pink { get { return FromColor(Color.Pink); } } + public static IXLColor Plum { get { return FromColor(Color.Plum); } } + public static IXLColor PowderBlue { get { return FromColor(Color.PowderBlue); } } + public static IXLColor Purple { get { return FromColor(Color.Purple); } } + public static IXLColor Red { get { return FromColor(Color.Red); } } + public static IXLColor RosyBrown { get { return FromColor(Color.RosyBrown); } } + public static IXLColor RoyalBlue { get { return FromColor(Color.RoyalBlue); } } + public static IXLColor SaddleBrown { get { return FromColor(Color.SaddleBrown); } } + public static IXLColor Salmon { get { return FromColor(Color.Salmon); } } + public static IXLColor SandyBrown { get { return FromColor(Color.SandyBrown); } } + public static IXLColor SeaGreen { get { return FromColor(Color.SeaGreen); } } + public static IXLColor SeaShell { get { return FromColor(Color.SeaShell); } } + public static IXLColor Sienna { get { return FromColor(Color.Sienna); } } + public static IXLColor Silver { get { return FromColor(Color.Silver); } } + public static IXLColor SkyBlue { get { return FromColor(Color.SkyBlue); } } + public static IXLColor SlateBlue { get { return FromColor(Color.SlateBlue); } } + public static IXLColor SlateGray { get { return FromColor(Color.SlateGray); } } + public static IXLColor Snow { get { return FromColor(Color.Snow); } } + public static IXLColor SpringGreen { get { return FromColor(Color.SpringGreen); } } + public static IXLColor SteelBlue { get { return FromColor(Color.SteelBlue); } } + public static IXLColor Tan { get { return FromColor(Color.Tan); } } + public static IXLColor Teal { get { return FromColor(Color.Teal); } } + public static IXLColor Thistle { get { return FromColor(Color.Thistle); } } + public static IXLColor Tomato { get { return FromColor(Color.Tomato); } } + public static IXLColor Turquoise { get { return FromColor(Color.Turquoise); } } + public static IXLColor Violet { get { return FromColor(Color.Violet); } } + public static IXLColor Wheat { get { return FromColor(Color.Wheat); } } + public static IXLColor White { get { return FromColor(Color.White); } } + public static IXLColor WhiteSmoke { get { return FromColor(Color.WhiteSmoke); } } + public static IXLColor Yellow { get { return FromColor(Color.Yellow); } } + public static IXLColor YellowGreen { get { return FromColor(Color.YellowGreen); } } + public static IXLColor AirForceBlue { get { return FromHtml("#FF5D8AA8"); } } + public static IXLColor Alizarin { get { return FromHtml("#FFE32636"); } } + public static IXLColor Almond { get { return FromHtml("#FFEFDECD"); } } + public static IXLColor Amaranth { get { return FromHtml("#FFE52B50"); } } + public static IXLColor Amber { get { return FromHtml("#FFFFBF00"); } } + public static IXLColor AmberSaeEce { get { return FromHtml("#FFFF7E00"); } } + public static IXLColor AmericanRose { get { return FromHtml("#FFFF033E"); } } + public static IXLColor Amethyst { get { return FromHtml("#FF9966CC"); } } + public static IXLColor AntiFlashWhite { get { return FromHtml("#FFF2F3F4"); } } + public static IXLColor AntiqueBrass { get { return FromHtml("#FFCD9575"); } } + public static IXLColor AntiqueFuchsia { get { return FromHtml("#FF915C83"); } } + public static IXLColor AppleGreen { get { return FromHtml("#FF8DB600"); } } + public static IXLColor Apricot { get { return FromHtml("#FFFBCEB1"); } } + public static IXLColor Aquamarine1 { get { return FromHtml("#FF7FFFD0"); } } + public static IXLColor ArmyGreen { get { return FromHtml("#FF4B5320"); } } + public static IXLColor Arsenic { get { return FromHtml("#FF3B444B"); } } + public static IXLColor ArylideYellow { get { return FromHtml("#FFE9D66B"); } } + public static IXLColor AshGrey { get { return FromHtml("#FFB2BEB5"); } } + public static IXLColor Asparagus { get { return FromHtml("#FF87A96B"); } } + public static IXLColor AtomicTangerine { get { return FromHtml("#FFFF9966"); } } + public static IXLColor Auburn { get { return FromHtml("#FF6D351A"); } } + public static IXLColor Aureolin { get { return FromHtml("#FFFDEE00"); } } + public static IXLColor Aurometalsaurus { get { return FromHtml("#FF6E7F80"); } } + public static IXLColor Awesome { get { return FromHtml("#FFFF2052"); } } + public static IXLColor AzureColorWheel { get { return FromHtml("#FF007FFF"); } } + public static IXLColor BabyBlue { get { return FromHtml("#FF89CFF0"); } } + public static IXLColor BabyBlueEyes { get { return FromHtml("#FFA1CAF1"); } } + public static IXLColor BabyPink { get { return FromHtml("#FFF4C2C2"); } } + public static IXLColor BallBlue { get { return FromHtml("#FF21ABCD"); } } + public static IXLColor BananaMania { get { return FromHtml("#FFFAE7B5"); } } + public static IXLColor BattleshipGrey { get { return FromHtml("#FF848482"); } } + public static IXLColor Bazaar { get { return FromHtml("#FF98777B"); } } + public static IXLColor BeauBlue { get { return FromHtml("#FFBCD4E6"); } } + public static IXLColor Beaver { get { return FromHtml("#FF9F8170"); } } + public static IXLColor Bistre { get { return FromHtml("#FF3D2B1F"); } } + public static IXLColor Bittersweet { get { return FromHtml("#FFFE6F5E"); } } + public static IXLColor BleuDeFrance { get { return FromHtml("#FF318CE7"); } } + public static IXLColor BlizzardBlue { get { return FromHtml("#FFACE5EE"); } } + public static IXLColor Blond { get { return FromHtml("#FFFAF0BE"); } } + public static IXLColor BlueBell { get { return FromHtml("#FFA2A2D0"); } } + public static IXLColor BlueGray { get { return FromHtml("#FF6699CC"); } } + public static IXLColor BlueGreen { get { return FromHtml("#FF00DDDD"); } } + public static IXLColor BluePigment { get { return FromHtml("#FF333399"); } } + public static IXLColor BlueRyb { get { return FromHtml("#FF0247FE"); } } + public static IXLColor Blush { get { return FromHtml("#FFDE5D83"); } } + public static IXLColor Bole { get { return FromHtml("#FF79443B"); } } + public static IXLColor BondiBlue { get { return FromHtml("#FF0095B6"); } } + public static IXLColor BostonUniversityRed { get { return FromHtml("#FFCC0000"); } } + public static IXLColor BrandeisBlue { get { return FromHtml("#FF0070FF"); } } + public static IXLColor Brass { get { return FromHtml("#FFB5A642"); } } + public static IXLColor BrickRed { get { return FromHtml("#FFCB4154"); } } + public static IXLColor BrightCerulean { get { return FromHtml("#FF1DACD6"); } } + public static IXLColor BrightGreen { get { return FromHtml("#FF66FF00"); } } + public static IXLColor BrightLavender { get { return FromHtml("#FFBF94E4"); } } + public static IXLColor BrightMaroon { get { return FromHtml("#FFC32148"); } } + public static IXLColor BrightPink { get { return FromHtml("#FFFF007F"); } } + public static IXLColor BrightTurquoise { get { return FromHtml("#FF08E8DE"); } } + public static IXLColor BrightUbe { get { return FromHtml("#FFD19FE8"); } } + public static IXLColor BrilliantLavender { get { return FromHtml("#FFF4BBFF"); } } + public static IXLColor BrilliantRose { get { return FromHtml("#FFFF55A3"); } } + public static IXLColor BrinkPink { get { return FromHtml("#FFFB607F"); } } + public static IXLColor BritishRacingGreen { get { return FromHtml("#FF004225"); } } + public static IXLColor Bronze { get { return FromHtml("#FFCD7F32"); } } + public static IXLColor BrownTraditional { get { return FromHtml("#FF964B00"); } } + public static IXLColor BubbleGum { get { return FromHtml("#FFFFC1CC"); } } + public static IXLColor Bubbles { get { return FromHtml("#FFE7FEFF"); } } + public static IXLColor Buff { get { return FromHtml("#FFF0DC82"); } } + public static IXLColor BulgarianRose { get { return FromHtml("#FF480607"); } } + public static IXLColor Burgundy { get { return FromHtml("#FF800020"); } } + public static IXLColor BurntOrange { get { return FromHtml("#FFCC5500"); } } + public static IXLColor BurntSienna { get { return FromHtml("#FFE97451"); } } + public static IXLColor BurntUmber { get { return FromHtml("#FF8A3324"); } } + public static IXLColor Byzantine { get { return FromHtml("#FFBD33A4"); } } + public static IXLColor Byzantium { get { return FromHtml("#FF702963"); } } + public static IXLColor Cadet { get { return FromHtml("#FF536872"); } } + public static IXLColor CadetGrey { get { return FromHtml("#FF91A3B0"); } } + public static IXLColor CadmiumGreen { get { return FromHtml("#FF006B3C"); } } + public static IXLColor CadmiumOrange { get { return FromHtml("#FFED872D"); } } + public static IXLColor CadmiumRed { get { return FromHtml("#FFE30022"); } } + public static IXLColor CadmiumYellow { get { return FromHtml("#FFFFF600"); } } + public static IXLColor CalPolyPomonaGreen { get { return FromHtml("#FF1E4D2B"); } } + public static IXLColor CambridgeBlue { get { return FromHtml("#FFA3C1AD"); } } + public static IXLColor Camel { get { return FromHtml("#FFC19A6B"); } } + public static IXLColor CamouflageGreen { get { return FromHtml("#FF78866B"); } } + public static IXLColor CanaryYellow { get { return FromHtml("#FFFFEF00"); } } + public static IXLColor CandyAppleRed { get { return FromHtml("#FFFF0800"); } } + public static IXLColor CandyPink { get { return FromHtml("#FFE4717A"); } } + public static IXLColor CaputMortuum { get { return FromHtml("#FF592720"); } } + public static IXLColor Cardinal { get { return FromHtml("#FFC41E3A"); } } + public static IXLColor CaribbeanGreen { get { return FromHtml("#FF00CC99"); } } + public static IXLColor Carmine { get { return FromHtml("#FF960018"); } } + public static IXLColor CarminePink { get { return FromHtml("#FFEB4C42"); } } + public static IXLColor CarmineRed { get { return FromHtml("#FFFF0038"); } } + public static IXLColor CarnationPink { get { return FromHtml("#FFFFA6C9"); } } + public static IXLColor Carnelian { get { return FromHtml("#FFB31B1B"); } } + public static IXLColor CarolinaBlue { get { return FromHtml("#FF99BADD"); } } + public static IXLColor CarrotOrange { get { return FromHtml("#FFED9121"); } } + public static IXLColor Ceil { get { return FromHtml("#FF92A1CF"); } } + public static IXLColor Celadon { get { return FromHtml("#FFACE1AF"); } } + public static IXLColor CelestialBlue { get { return FromHtml("#FF4997D0"); } } + public static IXLColor Cerise { get { return FromHtml("#FFDE3163"); } } + public static IXLColor CerisePink { get { return FromHtml("#FFEC3B83"); } } + public static IXLColor Cerulean { get { return FromHtml("#FF007BA7"); } } + public static IXLColor CeruleanBlue { get { return FromHtml("#FF2A52BE"); } } + public static IXLColor Chamoisee { get { return FromHtml("#FFA0785A"); } } + public static IXLColor Champagne { get { return FromHtml("#FFF7E7CE"); } } + public static IXLColor Charcoal { get { return FromHtml("#FF36454F"); } } + public static IXLColor ChartreuseTraditional { get { return FromHtml("#FFDFFF00"); } } + public static IXLColor CherryBlossomPink { get { return FromHtml("#FFFFB7C5"); } } + public static IXLColor Chocolate1 { get { return FromHtml("#FF7B3F00"); } } + public static IXLColor ChromeYellow { get { return FromHtml("#FFFFA700"); } } + public static IXLColor Cinereous { get { return FromHtml("#FF98817B"); } } + public static IXLColor Cinnabar { get { return FromHtml("#FFE34234"); } } + public static IXLColor Citrine { get { return FromHtml("#FFE4D00A"); } } + public static IXLColor ClassicRose { get { return FromHtml("#FFFBCCE7"); } } + public static IXLColor Cobalt { get { return FromHtml("#FF0047AB"); } } + public static IXLColor ColumbiaBlue { get { return FromHtml("#FF9BDDFF"); } } + public static IXLColor CoolBlack { get { return FromHtml("#FF002E63"); } } + public static IXLColor CoolGrey { get { return FromHtml("#FF8C92AC"); } } + public static IXLColor Copper { get { return FromHtml("#FFB87333"); } } + public static IXLColor CopperRose { get { return FromHtml("#FF996666"); } } + public static IXLColor Coquelicot { get { return FromHtml("#FFFF3800"); } } + public static IXLColor CoralPink { get { return FromHtml("#FFF88379"); } } + public static IXLColor CoralRed { get { return FromHtml("#FFFF4040"); } } + public static IXLColor Cordovan { get { return FromHtml("#FF893F45"); } } + public static IXLColor Corn { get { return FromHtml("#FFFBEC5D"); } } + public static IXLColor CornellRed { get { return FromHtml("#FFB31B1B"); } } + public static IXLColor CosmicLatte { get { return FromHtml("#FFFFF8E7"); } } + public static IXLColor CottonCandy { get { return FromHtml("#FFFFBCD9"); } } + public static IXLColor Cream { get { return FromHtml("#FFFFFDD0"); } } + public static IXLColor CrimsonGlory { get { return FromHtml("#FFBE0032"); } } + public static IXLColor CyanProcess { get { return FromHtml("#FF00B7EB"); } } + public static IXLColor Daffodil { get { return FromHtml("#FFFFFF31"); } } + public static IXLColor Dandelion { get { return FromHtml("#FFF0E130"); } } + public static IXLColor DarkBrown { get { return FromHtml("#FF654321"); } } + public static IXLColor DarkByzantium { get { return FromHtml("#FF5D3954"); } } + public static IXLColor DarkCandyAppleRed { get { return FromHtml("#FFA40000"); } } + public static IXLColor DarkCerulean { get { return FromHtml("#FF08457E"); } } + public static IXLColor DarkChampagne { get { return FromHtml("#FFC2B280"); } } + public static IXLColor DarkChestnut { get { return FromHtml("#FF986960"); } } + public static IXLColor DarkCoral { get { return FromHtml("#FFCD5B45"); } } + public static IXLColor DarkElectricBlue { get { return FromHtml("#FF536878"); } } + public static IXLColor DarkGreen1 { get { return FromHtml("#FF013220"); } } + public static IXLColor DarkJungleGreen { get { return FromHtml("#FF1A2421"); } } + public static IXLColor DarkLava { get { return FromHtml("#FF483C32"); } } + public static IXLColor DarkLavender { get { return FromHtml("#FF734F96"); } } + public static IXLColor DarkMidnightBlue { get { return FromHtml("#FF003366"); } } + public static IXLColor DarkPastelBlue { get { return FromHtml("#FF779ECB"); } } + public static IXLColor DarkPastelGreen { get { return FromHtml("#FF03C03C"); } } + public static IXLColor DarkPastelPurple { get { return FromHtml("#FF966FD6"); } } + public static IXLColor DarkPastelRed { get { return FromHtml("#FFC23B22"); } } + public static IXLColor DarkPink { get { return FromHtml("#FFE75480"); } } + public static IXLColor DarkPowderBlue { get { return FromHtml("#FF003399"); } } + public static IXLColor DarkRaspberry { get { return FromHtml("#FF872657"); } } + public static IXLColor DarkScarlet { get { return FromHtml("#FF560319"); } } + public static IXLColor DarkSienna { get { return FromHtml("#FF3C1414"); } } + public static IXLColor DarkSpringGreen { get { return FromHtml("#FF177245"); } } + public static IXLColor DarkTan { get { return FromHtml("#FF918151"); } } + public static IXLColor DarkTangerine { get { return FromHtml("#FFFFA812"); } } + public static IXLColor DarkTaupe { get { return FromHtml("#FF483C32"); } } + public static IXLColor DarkTerraCotta { get { return FromHtml("#FFCC4E5C"); } } + public static IXLColor DartmouthGreen { get { return FromHtml("#FF00693E"); } } + public static IXLColor DavysGrey { get { return FromHtml("#FF555555"); } } + public static IXLColor DebianRed { get { return FromHtml("#FFD70A53"); } } + public static IXLColor DeepCarmine { get { return FromHtml("#FFA9203E"); } } + public static IXLColor DeepCarminePink { get { return FromHtml("#FFEF3038"); } } + public static IXLColor DeepCarrotOrange { get { return FromHtml("#FFE9692C"); } } + public static IXLColor DeepCerise { get { return FromHtml("#FFDA3287"); } } + public static IXLColor DeepChampagne { get { return FromHtml("#FFFAD6A5"); } } + public static IXLColor DeepChestnut { get { return FromHtml("#FFB94E48"); } } + public static IXLColor DeepFuchsia { get { return FromHtml("#FFC154C1"); } } + public static IXLColor DeepJungleGreen { get { return FromHtml("#FF004B49"); } } + public static IXLColor DeepLilac { get { return FromHtml("#FF9955BB"); } } + public static IXLColor DeepMagenta { get { return FromHtml("#FFCC00CC"); } } + public static IXLColor DeepPeach { get { return FromHtml("#FFFFCBA4"); } } + public static IXLColor DeepSaffron { get { return FromHtml("#FFFF9933"); } } + public static IXLColor Denim { get { return FromHtml("#FF1560BD"); } } + public static IXLColor Desert { get { return FromHtml("#FFC19A6B"); } } + public static IXLColor DesertSand { get { return FromHtml("#FFEDC9AF"); } } + public static IXLColor DogwoodRose { get { return FromHtml("#FFD71868"); } } + public static IXLColor DollarBill { get { return FromHtml("#FF85BB65"); } } + public static IXLColor Drab { get { return FromHtml("#FF967117"); } } + public static IXLColor DukeBlue { get { return FromHtml("#FF00009C"); } } + public static IXLColor EarthYellow { get { return FromHtml("#FFE1A95F"); } } + public static IXLColor Ecru { get { return FromHtml("#FFC2B280"); } } + public static IXLColor Eggplant { get { return FromHtml("#FF614051"); } } + public static IXLColor Eggshell { get { return FromHtml("#FFF0EAD6"); } } + public static IXLColor EgyptianBlue { get { return FromHtml("#FF1034A6"); } } + public static IXLColor ElectricBlue { get { return FromHtml("#FF7DF9FF"); } } + public static IXLColor ElectricCrimson { get { return FromHtml("#FFFF003F"); } } + public static IXLColor ElectricIndigo { get { return FromHtml("#FF6F00FF"); } } + public static IXLColor ElectricLavender { get { return FromHtml("#FFF4BBFF"); } } + public static IXLColor ElectricLime { get { return FromHtml("#FFCCFF00"); } } + public static IXLColor ElectricPurple { get { return FromHtml("#FFBF00FF"); } } + public static IXLColor ElectricUltramarine { get { return FromHtml("#FF3F00FF"); } } + public static IXLColor ElectricViolet { get { return FromHtml("#FF8F00FF"); } } + public static IXLColor Emerald { get { return FromHtml("#FF50C878"); } } + public static IXLColor EtonBlue { get { return FromHtml("#FF96C8A2"); } } + public static IXLColor Fallow { get { return FromHtml("#FFC19A6B"); } } + public static IXLColor FaluRed { get { return FromHtml("#FF801818"); } } + public static IXLColor Fandango { get { return FromHtml("#FFB53389"); } } + public static IXLColor FashionFuchsia { get { return FromHtml("#FFF400A1"); } } + public static IXLColor Fawn { get { return FromHtml("#FFE5AA70"); } } + public static IXLColor Feldgrau { get { return FromHtml("#FF4D5D53"); } } + public static IXLColor FernGreen { get { return FromHtml("#FF4F7942"); } } + public static IXLColor FerrariRed { get { return FromHtml("#FFFF2800"); } } + public static IXLColor FieldDrab { get { return FromHtml("#FF6C541E"); } } + public static IXLColor FireEngineRed { get { return FromHtml("#FFCE2029"); } } + public static IXLColor Flame { get { return FromHtml("#FFE25822"); } } + public static IXLColor FlamingoPink { get { return FromHtml("#FFFC8EAC"); } } + public static IXLColor Flavescent { get { return FromHtml("#FFF7E98E"); } } + public static IXLColor Flax { get { return FromHtml("#FFEEDC82"); } } + public static IXLColor FluorescentOrange { get { return FromHtml("#FFFFBF00"); } } + public static IXLColor FluorescentYellow { get { return FromHtml("#FFCCFF00"); } } + public static IXLColor Folly { get { return FromHtml("#FFFF004F"); } } + public static IXLColor ForestGreenTraditional { get { return FromHtml("#FF014421"); } } + public static IXLColor FrenchBeige { get { return FromHtml("#FFA67B5B"); } } + public static IXLColor FrenchBlue { get { return FromHtml("#FF0072BB"); } } + public static IXLColor FrenchLilac { get { return FromHtml("#FF86608E"); } } + public static IXLColor FrenchRose { get { return FromHtml("#FFF64A8A"); } } + public static IXLColor FuchsiaPink { get { return FromHtml("#FFFF77FF"); } } + public static IXLColor Fulvous { get { return FromHtml("#FFE48400"); } } + public static IXLColor FuzzyWuzzy { get { return FromHtml("#FFCC6666"); } } + public static IXLColor Gamboge { get { return FromHtml("#FFE49B0F"); } } + public static IXLColor Ginger { get { return FromHtml("#FFF9F9FF"); } } + public static IXLColor Glaucous { get { return FromHtml("#FF6082B6"); } } + public static IXLColor GoldenBrown { get { return FromHtml("#FF996515"); } } + public static IXLColor GoldenPoppy { get { return FromHtml("#FFFCC200"); } } + public static IXLColor GoldenYellow { get { return FromHtml("#FFFFDF00"); } } + public static IXLColor GoldMetallic { get { return FromHtml("#FFD4AF37"); } } + public static IXLColor GrannySmithApple { get { return FromHtml("#FFA8E4A0"); } } + public static IXLColor GrayAsparagus { get { return FromHtml("#FF465945"); } } + public static IXLColor GreenPigment { get { return FromHtml("#FF00A550"); } } + public static IXLColor GreenRyb { get { return FromHtml("#FF66B032"); } } + public static IXLColor Grullo { get { return FromHtml("#FFA99A86"); } } + public static IXLColor HalayaUbe { get { return FromHtml("#FF663854"); } } + public static IXLColor HanBlue { get { return FromHtml("#FF446CCF"); } } + public static IXLColor HanPurple { get { return FromHtml("#FF5218FA"); } } + public static IXLColor HansaYellow { get { return FromHtml("#FFE9D66B"); } } + public static IXLColor Harlequin { get { return FromHtml("#FF3FFF00"); } } + public static IXLColor HarvardCrimson { get { return FromHtml("#FFC90016"); } } + public static IXLColor HarvestGold { get { return FromHtml("#FFDA9100"); } } + public static IXLColor Heliotrope { get { return FromHtml("#FFDF73FF"); } } + public static IXLColor HollywoodCerise { get { return FromHtml("#FFF400A1"); } } + public static IXLColor HookersGreen { get { return FromHtml("#FF007000"); } } + public static IXLColor HotMagenta { get { return FromHtml("#FFFF1DCE"); } } + public static IXLColor HunterGreen { get { return FromHtml("#FF355E3B"); } } + public static IXLColor Iceberg { get { return FromHtml("#FF71A6D2"); } } + public static IXLColor Icterine { get { return FromHtml("#FFFCF75E"); } } + public static IXLColor Inchworm { get { return FromHtml("#FFB2EC5D"); } } + public static IXLColor IndiaGreen { get { return FromHtml("#FF138808"); } } + public static IXLColor IndianYellow { get { return FromHtml("#FFE3A857"); } } + public static IXLColor IndigoDye { get { return FromHtml("#FF00416A"); } } + public static IXLColor InternationalKleinBlue { get { return FromHtml("#FF002FA7"); } } + public static IXLColor InternationalOrange { get { return FromHtml("#FFFF4F00"); } } + public static IXLColor Iris { get { return FromHtml("#FF5A4FCF"); } } + public static IXLColor Isabelline { get { return FromHtml("#FFF4F0EC"); } } + public static IXLColor IslamicGreen { get { return FromHtml("#FF009000"); } } + public static IXLColor Jade { get { return FromHtml("#FF00A86B"); } } + public static IXLColor Jasper { get { return FromHtml("#FFD73B3E"); } } + public static IXLColor JazzberryJam { get { return FromHtml("#FFA50B5E"); } } + public static IXLColor Jonquil { get { return FromHtml("#FFFADA5E"); } } + public static IXLColor JuneBud { get { return FromHtml("#FFBDDA57"); } } + public static IXLColor JungleGreen { get { return FromHtml("#FF29AB87"); } } + public static IXLColor KellyGreen { get { return FromHtml("#FF4CBB17"); } } + public static IXLColor KhakiHtmlCssKhaki { get { return FromHtml("#FFC3B091"); } } + public static IXLColor LanguidLavender { get { return FromHtml("#FFD6CADD"); } } + public static IXLColor LapisLazuli { get { return FromHtml("#FF26619C"); } } + public static IXLColor LaSalleGreen { get { return FromHtml("#FF087830"); } } + public static IXLColor LaserLemon { get { return FromHtml("#FFFEFE22"); } } + public static IXLColor Lava { get { return FromHtml("#FFCF1020"); } } + public static IXLColor LavenderBlue { get { return FromHtml("#FFCCCCFF"); } } + public static IXLColor LavenderFloral { get { return FromHtml("#FFB57EDC"); } } + public static IXLColor LavenderGray { get { return FromHtml("#FFC4C3D0"); } } + public static IXLColor LavenderIndigo { get { return FromHtml("#FF9457EB"); } } + public static IXLColor LavenderPink { get { return FromHtml("#FFFBAED2"); } } + public static IXLColor LavenderPurple { get { return FromHtml("#FF967BB6"); } } + public static IXLColor LavenderRose { get { return FromHtml("#FFFBA0E3"); } } + public static IXLColor Lemon { get { return FromHtml("#FFFFF700"); } } + public static IXLColor LightApricot { get { return FromHtml("#FFFDD5B1"); } } + public static IXLColor LightBrown { get { return FromHtml("#FFB5651D"); } } + public static IXLColor LightCarminePink { get { return FromHtml("#FFE66771"); } } + public static IXLColor LightCornflowerBlue { get { return FromHtml("#FF93CCEA"); } } + public static IXLColor LightFuchsiaPink { get { return FromHtml("#FFF984EF"); } } + public static IXLColor LightMauve { get { return FromHtml("#FFDCD0FF"); } } + public static IXLColor LightPastelPurple { get { return FromHtml("#FFB19CD9"); } } + public static IXLColor LightSalmonPink { get { return FromHtml("#FFFF9999"); } } + public static IXLColor LightTaupe { get { return FromHtml("#FFB38B6D"); } } + public static IXLColor LightThulianPink { get { return FromHtml("#FFE68FAC"); } } + public static IXLColor LightYellow1 { get { return FromHtml("#FFFFFFED"); } } + public static IXLColor Lilac { get { return FromHtml("#FFC8A2C8"); } } + public static IXLColor LimeColorWheel { get { return FromHtml("#FFBFFF00"); } } + public static IXLColor LincolnGreen { get { return FromHtml("#FF195905"); } } + public static IXLColor Liver { get { return FromHtml("#FF534B4F"); } } + public static IXLColor Lust { get { return FromHtml("#FFE62020"); } } + public static IXLColor MacaroniAndCheese { get { return FromHtml("#FFFFBD88"); } } + public static IXLColor MagentaDye { get { return FromHtml("#FFCA1F7B"); } } + public static IXLColor MagentaProcess { get { return FromHtml("#FFFF0090"); } } + public static IXLColor MagicMint { get { return FromHtml("#FFAAF0D1"); } } + public static IXLColor Magnolia { get { return FromHtml("#FFF8F4FF"); } } + public static IXLColor Mahogany { get { return FromHtml("#FFC04000"); } } + public static IXLColor Maize { get { return FromHtml("#FFFBEC5D"); } } + public static IXLColor MajorelleBlue { get { return FromHtml("#FF6050DC"); } } + public static IXLColor Malachite { get { return FromHtml("#FF0BDA51"); } } + public static IXLColor Manatee { get { return FromHtml("#FF979AAA"); } } + public static IXLColor MangoTango { get { return FromHtml("#FFFF8243"); } } + public static IXLColor MaroonX11 { get { return FromHtml("#FFB03060"); } } + public static IXLColor Mauve { get { return FromHtml("#FFE0B0FF"); } } + public static IXLColor Mauvelous { get { return FromHtml("#FFEF98AA"); } } + public static IXLColor MauveTaupe { get { return FromHtml("#FF915F6D"); } } + public static IXLColor MayaBlue { get { return FromHtml("#FF73C2FB"); } } + public static IXLColor MeatBrown { get { return FromHtml("#FFE5B73B"); } } + public static IXLColor MediumAquamarine1 { get { return FromHtml("#FF66DDAA"); } } + public static IXLColor MediumCandyAppleRed { get { return FromHtml("#FFE2062C"); } } + public static IXLColor MediumCarmine { get { return FromHtml("#FFAF4035"); } } + public static IXLColor MediumChampagne { get { return FromHtml("#FFF3E5AB"); } } + public static IXLColor MediumElectricBlue { get { return FromHtml("#FF035096"); } } + public static IXLColor MediumJungleGreen { get { return FromHtml("#FF1C352D"); } } + public static IXLColor MediumPersianBlue { get { return FromHtml("#FF0067A5"); } } + public static IXLColor MediumRedViolet { get { return FromHtml("#FFBB3385"); } } + public static IXLColor MediumSpringBud { get { return FromHtml("#FFC9DC87"); } } + public static IXLColor MediumTaupe { get { return FromHtml("#FF674C47"); } } + public static IXLColor Melon { get { return FromHtml("#FFFDBCB4"); } } + public static IXLColor MidnightGreenEagleGreen { get { return FromHtml("#FF004953"); } } + public static IXLColor MikadoYellow { get { return FromHtml("#FFFFC40C"); } } + public static IXLColor Mint { get { return FromHtml("#FF3EB489"); } } + public static IXLColor MintGreen { get { return FromHtml("#FF98FF98"); } } + public static IXLColor ModeBeige { get { return FromHtml("#FF967117"); } } + public static IXLColor MoonstoneBlue { get { return FromHtml("#FF73A9C2"); } } + public static IXLColor MordantRed19 { get { return FromHtml("#FFAE0C00"); } } + public static IXLColor MossGreen { get { return FromHtml("#FFADDFAD"); } } + public static IXLColor MountainMeadow { get { return FromHtml("#FF30BA8F"); } } + public static IXLColor MountbattenPink { get { return FromHtml("#FF997A8D"); } } + public static IXLColor MsuGreen { get { return FromHtml("#FF18453B"); } } + public static IXLColor Mulberry { get { return FromHtml("#FFC54B8C"); } } + public static IXLColor Mustard { get { return FromHtml("#FFFFDB58"); } } + public static IXLColor Myrtle { get { return FromHtml("#FF21421E"); } } + public static IXLColor NadeshikoPink { get { return FromHtml("#FFF6ADC6"); } } + public static IXLColor NapierGreen { get { return FromHtml("#FF2A8000"); } } + public static IXLColor NaplesYellow { get { return FromHtml("#FFFADA5E"); } } + public static IXLColor NeonCarrot { get { return FromHtml("#FFFFA343"); } } + public static IXLColor NeonFuchsia { get { return FromHtml("#FFFE59C2"); } } + public static IXLColor NeonGreen { get { return FromHtml("#FF39FF14"); } } + public static IXLColor NonPhotoBlue { get { return FromHtml("#FFA4DDED"); } } + public static IXLColor OceanBoatBlue { get { return FromHtml("#FFCC7422"); } } + public static IXLColor Ochre { get { return FromHtml("#FFCC7722"); } } + public static IXLColor OldGold { get { return FromHtml("#FFCFB53B"); } } + public static IXLColor OldLavender { get { return FromHtml("#FF796878"); } } + public static IXLColor OldMauve { get { return FromHtml("#FF673147"); } } + public static IXLColor OldRose { get { return FromHtml("#FFC08081"); } } + public static IXLColor OliveDrab7 { get { return FromHtml("#FF3C341F"); } } + public static IXLColor Olivine { get { return FromHtml("#FF9AB973"); } } + public static IXLColor Onyx { get { return FromHtml("#FF0F0F0F"); } } + public static IXLColor OperaMauve { get { return FromHtml("#FFB784A7"); } } + public static IXLColor OrangeColorWheel { get { return FromHtml("#FFFF7F00"); } } + public static IXLColor OrangePeel { get { return FromHtml("#FFFF9F00"); } } + public static IXLColor OrangeRyb { get { return FromHtml("#FFFB9902"); } } + public static IXLColor OtterBrown { get { return FromHtml("#FF654321"); } } + public static IXLColor OuCrimsonRed { get { return FromHtml("#FF990000"); } } + public static IXLColor OuterSpace { get { return FromHtml("#FF414A4C"); } } + public static IXLColor OutrageousOrange { get { return FromHtml("#FFFF6E4A"); } } + public static IXLColor OxfordBlue { get { return FromHtml("#FF002147"); } } + public static IXLColor PakistanGreen { get { return FromHtml("#FF00421B"); } } + public static IXLColor PalatinateBlue { get { return FromHtml("#FF273BE2"); } } + public static IXLColor PalatinatePurple { get { return FromHtml("#FF682860"); } } + public static IXLColor PaleAqua { get { return FromHtml("#FFBCD4E6"); } } + public static IXLColor PaleBrown { get { return FromHtml("#FF987654"); } } + public static IXLColor PaleCarmine { get { return FromHtml("#FFAF4035"); } } + public static IXLColor PaleCerulean { get { return FromHtml("#FF9BC4E2"); } } + public static IXLColor PaleChestnut { get { return FromHtml("#FFDDADAF"); } } + public static IXLColor PaleCopper { get { return FromHtml("#FFDA8A67"); } } + public static IXLColor PaleCornflowerBlue { get { return FromHtml("#FFABCDEF"); } } + public static IXLColor PaleGold { get { return FromHtml("#FFE6BE8A"); } } + public static IXLColor PaleMagenta { get { return FromHtml("#FFF984E5"); } } + public static IXLColor PalePink { get { return FromHtml("#FFFADADD"); } } + public static IXLColor PaleRobinEggBlue { get { return FromHtml("#FF96DED1"); } } + public static IXLColor PaleSilver { get { return FromHtml("#FFC9C0BB"); } } + public static IXLColor PaleSpringBud { get { return FromHtml("#FFECEBBD"); } } + public static IXLColor PaleTaupe { get { return FromHtml("#FFBC987E"); } } + public static IXLColor PansyPurple { get { return FromHtml("#FF78184A"); } } + public static IXLColor ParisGreen { get { return FromHtml("#FF50C878"); } } + public static IXLColor PastelBlue { get { return FromHtml("#FFAEC6CF"); } } + public static IXLColor PastelBrown { get { return FromHtml("#FF836953"); } } + public static IXLColor PastelGray { get { return FromHtml("#FFCFCFC4"); } } + public static IXLColor PastelGreen { get { return FromHtml("#FF77DD77"); } } + public static IXLColor PastelMagenta { get { return FromHtml("#FFF49AC2"); } } + public static IXLColor PastelOrange { get { return FromHtml("#FFFFB347"); } } + public static IXLColor PastelPink { get { return FromHtml("#FFFFD1DC"); } } + public static IXLColor PastelPurple { get { return FromHtml("#FFB39EB5"); } } + public static IXLColor PastelRed { get { return FromHtml("#FFFF6961"); } } + public static IXLColor PastelViolet { get { return FromHtml("#FFCB99C9"); } } + public static IXLColor PastelYellow { get { return FromHtml("#FFFDFD96"); } } + public static IXLColor PaynesGrey { get { return FromHtml("#FF40404F"); } } + public static IXLColor Peach { get { return FromHtml("#FFFFE5B4"); } } + public static IXLColor PeachOrange { get { return FromHtml("#FFFFCC99"); } } + public static IXLColor PeachYellow { get { return FromHtml("#FFFADFAD"); } } + public static IXLColor Pear { get { return FromHtml("#FFD1E231"); } } + public static IXLColor Pearl { get { return FromHtml("#FFF0EAD6"); } } + public static IXLColor Peridot { get { return FromHtml("#FFE6E200"); } } + public static IXLColor Periwinkle { get { return FromHtml("#FFCCCCFF"); } } + public static IXLColor PersianBlue { get { return FromHtml("#FF1C39BB"); } } + public static IXLColor PersianGreen { get { return FromHtml("#FF00A693"); } } + public static IXLColor PersianIndigo { get { return FromHtml("#FF32127A"); } } + public static IXLColor PersianOrange { get { return FromHtml("#FFD99058"); } } + public static IXLColor PersianPink { get { return FromHtml("#FFF77FBE"); } } + public static IXLColor PersianPlum { get { return FromHtml("#FF701C1C"); } } + public static IXLColor PersianRed { get { return FromHtml("#FFCC3333"); } } + public static IXLColor PersianRose { get { return FromHtml("#FFFE28A2"); } } + public static IXLColor Persimmon { get { return FromHtml("#FFEC5800"); } } + public static IXLColor Phlox { get { return FromHtml("#FFDF00FF"); } } + public static IXLColor PhthaloBlue { get { return FromHtml("#FF000F89"); } } + public static IXLColor PhthaloGreen { get { return FromHtml("#FF123524"); } } + public static IXLColor PiggyPink { get { return FromHtml("#FFFDDDE6"); } } + public static IXLColor PineGreen { get { return FromHtml("#FF01796F"); } } + public static IXLColor PinkOrange { get { return FromHtml("#FFFF9966"); } } + public static IXLColor PinkPearl { get { return FromHtml("#FFE7ACCF"); } } + public static IXLColor PinkSherbet { get { return FromHtml("#FFF78FA7"); } } + public static IXLColor Pistachio { get { return FromHtml("#FF93C572"); } } + public static IXLColor Platinum { get { return FromHtml("#FFE5E4E2"); } } + public static IXLColor PlumTraditional { get { return FromHtml("#FF8E4585"); } } + public static IXLColor PortlandOrange { get { return FromHtml("#FFFF5A36"); } } + public static IXLColor PrincetonOrange { get { return FromHtml("#FFFF8F00"); } } + public static IXLColor Prune { get { return FromHtml("#FF701C1C"); } } + public static IXLColor PrussianBlue { get { return FromHtml("#FF003153"); } } + public static IXLColor PsychedelicPurple { get { return FromHtml("#FFDF00FF"); } } + public static IXLColor Puce { get { return FromHtml("#FFCC8899"); } } + public static IXLColor Pumpkin { get { return FromHtml("#FFFF7518"); } } + public static IXLColor PurpleHeart { get { return FromHtml("#FF69359C"); } } + public static IXLColor PurpleMountainMajesty { get { return FromHtml("#FF9678B6"); } } + public static IXLColor PurpleMunsell { get { return FromHtml("#FF9F00C5"); } } + public static IXLColor PurplePizzazz { get { return FromHtml("#FFFE4EDA"); } } + public static IXLColor PurpleTaupe { get { return FromHtml("#FF50404D"); } } + public static IXLColor PurpleX11 { get { return FromHtml("#FFA020F0"); } } + public static IXLColor RadicalRed { get { return FromHtml("#FFFF355E"); } } + public static IXLColor Raspberry { get { return FromHtml("#FFE30B5D"); } } + public static IXLColor RaspberryGlace { get { return FromHtml("#FF915F6D"); } } + public static IXLColor RaspberryPink { get { return FromHtml("#FFE25098"); } } + public static IXLColor RaspberryRose { get { return FromHtml("#FFB3446C"); } } + public static IXLColor RawUmber { get { return FromHtml("#FF826644"); } } + public static IXLColor RazzleDazzleRose { get { return FromHtml("#FFFF33CC"); } } + public static IXLColor Razzmatazz { get { return FromHtml("#FFE3256B"); } } + public static IXLColor RedMunsell { get { return FromHtml("#FFF2003C"); } } + public static IXLColor RedNcs { get { return FromHtml("#FFC40233"); } } + public static IXLColor RedPigment { get { return FromHtml("#FFED1C24"); } } + public static IXLColor RedRyb { get { return FromHtml("#FFFE2712"); } } + public static IXLColor Redwood { get { return FromHtml("#FFAB4E52"); } } + public static IXLColor Regalia { get { return FromHtml("#FF522D80"); } } + public static IXLColor RichBlack { get { return FromHtml("#FF004040"); } } + public static IXLColor RichBrilliantLavender { get { return FromHtml("#FFF1A7FE"); } } + public static IXLColor RichCarmine { get { return FromHtml("#FFD70040"); } } + public static IXLColor RichElectricBlue { get { return FromHtml("#FF0892D0"); } } + public static IXLColor RichLavender { get { return FromHtml("#FFA76BCF"); } } + public static IXLColor RichLilac { get { return FromHtml("#FFB666D2"); } } + public static IXLColor RichMaroon { get { return FromHtml("#FFB03060"); } } + public static IXLColor RifleGreen { get { return FromHtml("#FF414833"); } } + public static IXLColor RobinEggBlue { get { return FromHtml("#FF00CCCC"); } } + public static IXLColor Rose { get { return FromHtml("#FFFF007F"); } } + public static IXLColor RoseBonbon { get { return FromHtml("#FFF9429E"); } } + public static IXLColor RoseEbony { get { return FromHtml("#FF674846"); } } + public static IXLColor RoseGold { get { return FromHtml("#FFB76E79"); } } + public static IXLColor RoseMadder { get { return FromHtml("#FFE32636"); } } + public static IXLColor RosePink { get { return FromHtml("#FFFF66CC"); } } + public static IXLColor RoseQuartz { get { return FromHtml("#FFAA98A9"); } } + public static IXLColor RoseTaupe { get { return FromHtml("#FF905D5D"); } } + public static IXLColor RoseVale { get { return FromHtml("#FFAB4E52"); } } + public static IXLColor Rosewood { get { return FromHtml("#FF65000B"); } } + public static IXLColor RossoCorsa { get { return FromHtml("#FFD40000"); } } + public static IXLColor RoyalAzure { get { return FromHtml("#FF0038A8"); } } + public static IXLColor RoyalBlueTraditional { get { return FromHtml("#FF002366"); } } + public static IXLColor RoyalFuchsia { get { return FromHtml("#FFCA2C92"); } } + public static IXLColor RoyalPurple { get { return FromHtml("#FF7851A9"); } } + public static IXLColor Ruby { get { return FromHtml("#FFE0115F"); } } + public static IXLColor Ruddy { get { return FromHtml("#FFFF0028"); } } + public static IXLColor RuddyBrown { get { return FromHtml("#FFBB6528"); } } + public static IXLColor RuddyPink { get { return FromHtml("#FFE18E96"); } } + public static IXLColor Rufous { get { return FromHtml("#FFA81C07"); } } + public static IXLColor Russet { get { return FromHtml("#FF80461B"); } } + public static IXLColor Rust { get { return FromHtml("#FFB7410E"); } } + public static IXLColor SacramentoStateGreen { get { return FromHtml("#FF00563F"); } } + public static IXLColor SafetyOrangeBlazeOrange { get { return FromHtml("#FFFF6700"); } } + public static IXLColor Saffron { get { return FromHtml("#FFF4C430"); } } + public static IXLColor Salmon1 { get { return FromHtml("#FFFF8C69"); } } + public static IXLColor SalmonPink { get { return FromHtml("#FFFF91A4"); } } + public static IXLColor Sand { get { return FromHtml("#FFC2B280"); } } + public static IXLColor SandDune { get { return FromHtml("#FF967117"); } } + public static IXLColor Sandstorm { get { return FromHtml("#FFECD540"); } } + public static IXLColor SandyTaupe { get { return FromHtml("#FF967117"); } } + public static IXLColor Sangria { get { return FromHtml("#FF92000A"); } } + public static IXLColor SapGreen { get { return FromHtml("#FF507D2A"); } } + public static IXLColor Sapphire { get { return FromHtml("#FF082567"); } } + public static IXLColor SatinSheenGold { get { return FromHtml("#FFCBA135"); } } + public static IXLColor Scarlet { get { return FromHtml("#FFFF2000"); } } + public static IXLColor SchoolBusYellow { get { return FromHtml("#FFFFD800"); } } + public static IXLColor ScreaminGreen { get { return FromHtml("#FF76FF7A"); } } + public static IXLColor SealBrown { get { return FromHtml("#FF321414"); } } + public static IXLColor SelectiveYellow { get { return FromHtml("#FFFFBA00"); } } + public static IXLColor Sepia { get { return FromHtml("#FF704214"); } } + public static IXLColor Shadow { get { return FromHtml("#FF8A795D"); } } + public static IXLColor ShamrockGreen { get { return FromHtml("#FF009E60"); } } + public static IXLColor ShockingPink { get { return FromHtml("#FFFC0FC0"); } } + public static IXLColor Sienna1 { get { return FromHtml("#FF882D17"); } } + public static IXLColor Sinopia { get { return FromHtml("#FFCB410B"); } } + public static IXLColor Skobeloff { get { return FromHtml("#FF007474"); } } + public static IXLColor SkyMagenta { get { return FromHtml("#FFCF71AF"); } } + public static IXLColor SmaltDarkPowderBlue { get { return FromHtml("#FF003399"); } } + public static IXLColor SmokeyTopaz { get { return FromHtml("#FF933D41"); } } + public static IXLColor SmokyBlack { get { return FromHtml("#FF100C08"); } } + public static IXLColor SpiroDiscoBall { get { return FromHtml("#FF0FC0FC"); } } + public static IXLColor SplashedWhite { get { return FromHtml("#FFFEFDFF"); } } + public static IXLColor SpringBud { get { return FromHtml("#FFA7FC00"); } } + public static IXLColor StPatricksBlue { get { return FromHtml("#FF23297A"); } } + public static IXLColor StilDeGrainYellow { get { return FromHtml("#FFFADA5E"); } } + public static IXLColor Straw { get { return FromHtml("#FFE4D96F"); } } + public static IXLColor Sunglow { get { return FromHtml("#FFFFCC33"); } } + public static IXLColor Sunset { get { return FromHtml("#FFFAD6A5"); } } + public static IXLColor Tangelo { get { return FromHtml("#FFF94D00"); } } + public static IXLColor Tangerine { get { return FromHtml("#FFF28500"); } } + public static IXLColor TangerineYellow { get { return FromHtml("#FFFFCC00"); } } + public static IXLColor Taupe { get { return FromHtml("#FF483C32"); } } + public static IXLColor TaupeGray { get { return FromHtml("#FF8B8589"); } } + public static IXLColor TeaGreen { get { return FromHtml("#FFD0F0C0"); } } + public static IXLColor TealBlue { get { return FromHtml("#FF367588"); } } + public static IXLColor TealGreen { get { return FromHtml("#FF006D5B"); } } + public static IXLColor TeaRoseOrange { get { return FromHtml("#FFF88379"); } } + public static IXLColor TeaRoseRose { get { return FromHtml("#FFF4C2C2"); } } + public static IXLColor TennéTawny { get { return FromHtml("#FFCD5700"); } } + public static IXLColor TerraCotta { get { return FromHtml("#FFE2725B"); } } + public static IXLColor ThulianPink { get { return FromHtml("#FFDE6FA1"); } } + public static IXLColor TickleMePink { get { return FromHtml("#FFFC89AC"); } } + public static IXLColor TiffanyBlue { get { return FromHtml("#FF0ABAB5"); } } + public static IXLColor TigersEye { get { return FromHtml("#FFE08D3C"); } } + public static IXLColor Timberwolf { get { return FromHtml("#FFDBD7D2"); } } + public static IXLColor TitaniumYellow { get { return FromHtml("#FFEEE600"); } } + public static IXLColor Toolbox { get { return FromHtml("#FF746CC0"); } } + public static IXLColor TractorRed { get { return FromHtml("#FFFD0E35"); } } + public static IXLColor TropicalRainForest { get { return FromHtml("#FF00755E"); } } + public static IXLColor TuftsBlue { get { return FromHtml("#FF417DC1"); } } + public static IXLColor Tumbleweed { get { return FromHtml("#FFDEAA88"); } } + public static IXLColor TurkishRose { get { return FromHtml("#FFB57281"); } } + public static IXLColor Turquoise1 { get { return FromHtml("#FF30D5C8"); } } + public static IXLColor TurquoiseBlue { get { return FromHtml("#FF00FFEF"); } } + public static IXLColor TurquoiseGreen { get { return FromHtml("#FFA0D6B4"); } } + public static IXLColor TuscanRed { get { return FromHtml("#FF823535"); } } + public static IXLColor TwilightLavender { get { return FromHtml("#FF8A496B"); } } + public static IXLColor TyrianPurple { get { return FromHtml("#FF66023C"); } } + public static IXLColor UaBlue { get { return FromHtml("#FF0033AA"); } } + public static IXLColor UaRed { get { return FromHtml("#FFD9004C"); } } + public static IXLColor Ube { get { return FromHtml("#FF8878C3"); } } + public static IXLColor UclaBlue { get { return FromHtml("#FF536895"); } } + public static IXLColor UclaGold { get { return FromHtml("#FFFFB300"); } } + public static IXLColor UfoGreen { get { return FromHtml("#FF3CD070"); } } + public static IXLColor Ultramarine { get { return FromHtml("#FF120A8F"); } } + public static IXLColor UltramarineBlue { get { return FromHtml("#FF4166F5"); } } + public static IXLColor UltraPink { get { return FromHtml("#FFFF6FFF"); } } + public static IXLColor Umber { get { return FromHtml("#FF635147"); } } + public static IXLColor UnitedNationsBlue { get { return FromHtml("#FF5B92E5"); } } + public static IXLColor UnmellowYellow { get { return FromHtml("#FFFFFF66"); } } + public static IXLColor UpForestGreen { get { return FromHtml("#FF014421"); } } + public static IXLColor UpMaroon { get { return FromHtml("#FF7B1113"); } } + public static IXLColor UpsdellRed { get { return FromHtml("#FFAE2029"); } } + public static IXLColor Urobilin { get { return FromHtml("#FFE1AD21"); } } + public static IXLColor UscCardinal { get { return FromHtml("#FF990000"); } } + public static IXLColor UscGold { get { return FromHtml("#FFFFCC00"); } } + public static IXLColor UtahCrimson { get { return FromHtml("#FFD3003F"); } } + public static IXLColor Vanilla { get { return FromHtml("#FFF3E5AB"); } } + public static IXLColor VegasGold { get { return FromHtml("#FFC5B358"); } } + public static IXLColor VenetianRed { get { return FromHtml("#FFC80815"); } } + public static IXLColor Verdigris { get { return FromHtml("#FF43B3AE"); } } + public static IXLColor Vermilion { get { return FromHtml("#FFE34234"); } } + public static IXLColor Veronica { get { return FromHtml("#FFA020F0"); } } + public static IXLColor Violet1 { get { return FromHtml("#FF8F00FF"); } } + public static IXLColor VioletColorWheel { get { return FromHtml("#FF7F00FF"); } } + public static IXLColor VioletRyb { get { return FromHtml("#FF8601AF"); } } + public static IXLColor Viridian { get { return FromHtml("#FF40826D"); } } + public static IXLColor VividAuburn { get { return FromHtml("#FF922724"); } } + public static IXLColor VividBurgundy { get { return FromHtml("#FF9F1D35"); } } + public static IXLColor VividCerise { get { return FromHtml("#FFDA1D81"); } } + public static IXLColor VividTangerine { get { return FromHtml("#FFFFA089"); } } + public static IXLColor VividViolet { get { return FromHtml("#FF9F00FF"); } } + public static IXLColor WarmBlack { get { return FromHtml("#FF004242"); } } + public static IXLColor Wenge { get { return FromHtml("#FF645452"); } } + public static IXLColor WildBlueYonder { get { return FromHtml("#FFA2ADD0"); } } + public static IXLColor WildStrawberry { get { return FromHtml("#FFFF43A4"); } } + public static IXLColor WildWatermelon { get { return FromHtml("#FFFC6C85"); } } + public static IXLColor Wisteria { get { return FromHtml("#FFC9A0DC"); } } + public static IXLColor Xanadu { get { return FromHtml("#FF738678"); } } + public static IXLColor YaleBlue { get { return FromHtml("#FF0F4D92"); } } + public static IXLColor YellowMunsell { get { return FromHtml("#FFEFCC00"); } } + public static IXLColor YellowNcs { get { return FromHtml("#FFFFD300"); } } + public static IXLColor YellowProcess { get { return FromHtml("#FFFFEF00"); } } + public static IXLColor YellowRyb { get { return FromHtml("#FFFEFE33"); } } + public static IXLColor Zaffre { get { return FromHtml("#FF0014A8"); } } + public static IXLColor ZinnwalditeBrown { get { return FromHtml("#FF2C1608"); } } } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLAlignment.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLAlignment.cs index 9021888..d9d67e5 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLAlignment.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLAlignment.cs @@ -35,24 +35,48 @@ public interface IXLAlignment: IEquatable { + /// + /// Gets or sets the cell's horizontal alignment. + /// XLAlignmentHorizontalValues Horizontal { get; set; } + /// + /// Gets or sets the cell's vertical alignment. + /// XLAlignmentVerticalValues Vertical { get; set; } + /// + /// Gets or sets the cell's text indentation. + /// Int32 Indent { get; set; } - + /// + /// Gets or sets whether the cell's last line is justified or not. + /// Boolean JustifyLastLine { get; set; } - + /// + /// Gets or sets the cell's reading order. + /// XLAlignmentReadingOrderValues ReadingOrder { get; set; } - + /// + /// Gets or sets the cell's relative indent. + /// Int32 RelativeIndent { get; set; } - + /// + /// Gets or sets whether the cell's font size should decrease to fit the contents. + /// Boolean ShrinkToFit { get; set; } - + /// + /// Gets or sets the cell's text rotation. + /// Int32 TextRotation { get; set; } - + /// + /// Gets or sets whether the cell's text should wrap if it doesn't fit. + /// Boolean WrapText { get; set; } - + /// + /// Gets or sets wheter the cell's text should be displayed from to to bottom + /// (as opposed to the normal left to right). + /// Boolean TopToBottom { get; set; } } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLBorder.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLBorder.cs index d1b1d8f..ff980ff 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLBorder.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLBorder.cs @@ -27,19 +27,19 @@ { XLBorderStyleValues LeftBorder { get; set; } - XLColor LeftBorderColor { get; set; } + IXLColor LeftBorderColor { get; set; } XLBorderStyleValues RightBorder { get; set; } - XLColor RightBorderColor { get; set; } + IXLColor RightBorderColor { get; set; } XLBorderStyleValues TopBorder { get; set; } - XLColor TopBorderColor { get; set; } + IXLColor TopBorderColor { get; set; } XLBorderStyleValues BottomBorder { get; set; } - XLColor BottomBorderColor { get; set; } + IXLColor BottomBorderColor { get; set; } Boolean DiagonalUp { get; set; } @@ -47,6 +47,6 @@ XLBorderStyleValues DiagonalBorder { get; set; } - XLColor DiagonalBorderColor { get; set; } + IXLColor DiagonalBorderColor { get; set; } } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLFill.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLFill.cs index 9f73f3a..402c1c5 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLFill.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLFill.cs @@ -31,11 +31,11 @@ public interface IXLFill:IEquatable { - XLColor BackgroundColor { get; set; } + IXLColor BackgroundColor { get; set; } - XLColor PatternColor { get; set; } + IXLColor PatternColor { get; set; } - XLColor PatternBackgroundColor { get; set; } + IXLColor PatternBackgroundColor { get; set; } XLFillPatternValues PatternType { get; set; } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLFont.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLFont.cs index 784402f..e0b0890 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLFont.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/IXLFont.cs @@ -41,7 +41,7 @@ XLFontVerticalTextAlignmentValues VerticalAlignment { get; set; } Boolean Shadow { get; set; } Double FontSize { get; set; } - XLColor FontColor { get; set; } + IXLColor FontColor { get; set; } String FontName { get; set; } XLFontFamilyNumberingValues FontFamilyNumbering { get; set; } } diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLBorder.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLBorder.cs index 5514c3b..eedf8b1 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLBorder.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLBorder.cs @@ -47,8 +47,8 @@ } } - private XLColor leftBorderColor; - public XLColor LeftBorderColor + private IXLColor leftBorderColor; + public IXLColor LeftBorderColor { get { @@ -79,8 +79,8 @@ } } - private XLColor rightBorderColor; - public XLColor RightBorderColor + private IXLColor rightBorderColor; + public IXLColor RightBorderColor { get { @@ -111,8 +111,8 @@ } } - private XLColor topBorderColor; - public XLColor TopBorderColor + private IXLColor topBorderColor; + public IXLColor TopBorderColor { get { @@ -143,8 +143,8 @@ } } - private XLColor bottomBorderColor; - public XLColor BottomBorderColor + private IXLColor bottomBorderColor; + public IXLColor BottomBorderColor { get { @@ -175,8 +175,8 @@ } } - private XLColor diagonalBorderColor; - public XLColor DiagonalBorderColor + private IXLColor diagonalBorderColor; + public IXLColor DiagonalBorderColor { get { diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLFill.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLFill.cs index 086fc92..e9c4077 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLFill.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLFill.cs @@ -10,7 +10,7 @@ { #region Properties - public XLColor BackgroundColor + public IXLColor BackgroundColor { get { @@ -31,8 +31,8 @@ } } - private XLColor patternColor; - public XLColor PatternColor + private IXLColor patternColor; + public IXLColor PatternColor { get { @@ -47,8 +47,8 @@ } } - private XLColor patternBackgroundColor; - public XLColor PatternBackgroundColor + private IXLColor patternBackgroundColor; + public IXLColor PatternBackgroundColor { get { diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLFont.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLFont.cs index c7328cb..63008a9 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLFont.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/Style/XLFont.cs @@ -172,8 +172,8 @@ } } - private XLColor fontColor; - public XLColor FontColor + private IXLColor fontColor; + public IXLColor FontColor { get { diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook.cs index be8a749..323a090 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook.cs @@ -14,6 +14,9 @@ { private enum XLLoadSource { New, File, Stream }; private XLLoadSource loadSource = XLLoadSource.New; + /// + /// Creates a new Excel workbook. + /// public XLWorkbook() { DefaultRowHeight = 15; @@ -67,6 +70,10 @@ } private String originalFile; + /// + /// Opens an existing workbook from a file. + /// + /// The file to open. public XLWorkbook(String file): this() { loadSource = XLLoadSource.File; @@ -74,6 +81,10 @@ Load(file); } + /// + /// Opens an existing workbook from a stream. + /// + /// The stream to open. public XLWorkbook(Stream stream) : this() { @@ -83,7 +94,13 @@ #region IXLWorkbook Members + /// + /// Gets an object to manipulate the worksheets. + /// public IXLWorksheets Worksheets { get; private set; } + /// + /// Gets an object to manipulate this workbook's named ranges. + /// public IXLNamedRanges NamedRanges { get; private set; } /// @@ -95,9 +112,14 @@ /// Gets the file name of the workbook including its full directory. /// public String FullName { get; private set; } - + /// + /// Gets an object to manipulate this workbook's theme. + /// public IXLTheme Theme { get; private set; } + /// + /// Saves the current workbook. + /// public void Save() { if (loadSource == XLLoadSource.New) @@ -107,7 +129,9 @@ else CreatePackage(originalFile); } - + /// + /// Saves the current workbook to a file. + /// public void SaveAs(String file) { if (originalFile == null) @@ -117,19 +141,50 @@ CreatePackage(file); } - + /// + /// Saves the current workbook to a stream. + /// public void SaveAs(Stream stream) { CreatePackage(stream); } + /// + /// Gets or sets the default style for the workbook. + /// All new worksheets will use this style. + /// public IXLStyle Style { get; set; } + /// + /// Gets or sets the default row height for the workbook. + /// All new worksheets will use this row height. + /// public Double RowHeight { get; set; } + /// + /// Gets or sets the default column width for the workbook. + /// All new worksheets will use this column width. + /// public Double ColumnWidth { get; set; } + /// + /// Gets or sets the default page options for the workbook. + /// All new worksheets will use these page options. + /// public IXLPageSetup PageOptions { get; set; } + /// + /// Gets or sets the default outline options for the workbook. + /// All new worksheets will use these outline options. + /// public IXLOutline Outline { get; set; } + /// + /// Gets or sets the workbook's properties. + /// public XLWorkbookProperties Properties { get; set; } + /// + /// Gets or sets the workbook's calculation mode. + /// public XLCalculateMode CalculateMode { get; set; } + /// + /// Gets or sets the workbook's reference style. + /// public XLReferenceStyle ReferenceStyle { get; set; } #endregion diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs index 91f97b5..e0bb269 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs @@ -450,9 +450,9 @@ } private Dictionary colorList = new Dictionary(); - private XLColor GetColor(ColorType color) + private IXLColor GetColor(ColorType color) { - XLColor retVal = null; + IXLColor retVal = null; if (color != null) { if (color.Rgb != null) @@ -472,19 +472,7 @@ } else if (color.Indexed != null && color.Indexed < 64) { - var indexedColors = XLColor.IndexedColors; - String htmlColor = "#" + indexedColors[(Int32)color.Indexed.Value].Color.ToHex(); - System.Drawing.Color thisColor; - if (!colorList.ContainsKey(htmlColor)) - { - thisColor = System.Drawing.ColorTranslator.FromHtml(htmlColor); - colorList.Add(htmlColor, thisColor); - } - else - { - thisColor = colorList[htmlColor]; - } - retVal = new XLColor(thisColor); + retVal = new XLColor((Int32)color.Indexed.Value); } else if (color.Theme != null) { diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorksheet.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorksheet.cs index 659f6da..47bbe98 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorksheet.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorksheet.cs @@ -204,6 +204,23 @@ return null; } } + + public IXLColumn LastColumn() + { + return Column(MaxNumberOfColumns); + } + public IXLColumn FirstColumn() + { + return Column(1); + } + public IXLRow FirstRow() + { + return Row(1); + } + public IXLRow LastRow() + { + return Row(MaxNumberOfRows); + } public IXLColumn FirstColumnUsed() { var rngColumn = this.AsRange().FirstColumnUsed(); diff --git a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/MultipleRanges.cs b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/MultipleRanges.cs index e196a3b..9cfdbec 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/MultipleRanges.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Examples/Ranges/MultipleRanges.cs @@ -15,7 +15,7 @@ var ws = workbook.Worksheets.Add("Multiple Ranges"); // using multiple string range definitions - ws.Ranges("A1:B2", "C3:D4", "E5:F6").Style.Fill.BackgroundColor = XLColor.Red; + ws.Ranges("A1:B2,C3:D4,E5:F6").Style.Fill.BackgroundColor = XLColor.Red; // using a single string separated by commas ws.Ranges("A5:B6,E1:F2").Style.Fill.BackgroundColor = XLColor.Orange; diff --git a/ClosedXML/ClosedXML/ClosedXML_Net3.5/ClosedXML_Net3.5.csproj b/ClosedXML/ClosedXML/ClosedXML_Net3.5/ClosedXML_Net3.5.csproj index 697d48a..2920223 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Net3.5/ClosedXML_Net3.5.csproj +++ b/ClosedXML/ClosedXML/ClosedXML_Net3.5/ClosedXML_Net3.5.csproj @@ -33,6 +33,8 @@ TRACE prompt 4 + + @@ -50,12 +52,18 @@ Excel\Cells\IXLCell.cs + + Excel\Cells\IXLCells.cs + Excel\Cells\XLCell.cs Excel\Cells\XLCellCollection.cs + + Excel\Cells\XLCells.cs + Excel\Columns\IXLColumn.cs diff --git a/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs b/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs index a08f66f..0376b30 100644 --- a/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs +++ b/ClosedXML/ClosedXML/ClosedXML_Sandbox/Program.cs @@ -15,8 +15,20 @@ { var wb = new XLWorkbook(); var ws = wb.Worksheets.Add("Sheet1"); - ws.Cell(1, 1).Value = "Font Color = Theme Accent 6"; - ws.Cell(1, 1).Style.Font.FontColor = XLColor.FromTheme(XLThemeColor.Accent6); + var col = ws.Row(1); + col.Cells("1:2, 4:5").Style.Fill.BackgroundColor = XLColor.Red; + col.Cells("3").Style.Fill.BackgroundColor = XLColor.Blue; + col.Cell(6).Style.Fill.BackgroundColor = XLColor.Orange; + col.Cells(7, 8).Style.Fill.BackgroundColor = XLColor.Blue; + + var colRng = ws.Range("A2:H2").FirstRow(); + + colRng.Cells("1:2, 4:5").Style.Fill.BackgroundColor = XLColor.Red; + colRng.Cells("3").Style.Fill.BackgroundColor = XLColor.Blue; + colRng.Cell(6).Style.Fill.BackgroundColor = XLColor.Orange; + colRng.Cells(7, 8).Style.Fill.BackgroundColor = XLColor.Blue; + + wb.SaveAs(@"C:\Excel Files\ForTesting\Sandbox.xlsx"); } static void Main_5961(string[] args)