public void Add(String elementNumber, XLSortOrder sortOrder, Boolean ignoreBlanks, Boolean matchCase)
{
elements.Add(new XLSortElement()
{
ElementNumber = XLHelper.GetColumnNumberFromLetter(elementNumber),
SortOrder = sortOrder,
IgnoreBlanks = ignoreBlanks,
MatchCase = matchCase
});
}
public new IXLRangeColumn Column(String column)
{
if (XLHelper.IsValidColumn(column))
{
Int32 coNum = XLHelper.GetColumnNumberFromLetter(column);
return(coNum > ColumnCount() ? Column(_table.GetFieldIndex(column) + 1) : Column(coNum));
}
return(Column(_table.GetFieldIndex(column) + 1));
}
public IXLFilterColumn Column(String column)
{
var columnNumber = XLHelper.GetColumnNumberFromLetter(column);
if (columnNumber < 1 || columnNumber > XLHelper.MaxColumnNumber)
{
throw new ArgumentOutOfRangeException(nameof(column), "Column '" + column + "' is outside the allowed column range.");
}
return(Column(columnNumber));
}
public IXLCells Cells(string firstColumn, string lastColumn)
{
return(Cells(XLHelper.GetColumnNumberFromLetter(firstColumn) + ":"
+ XLHelper.GetColumnNumberFromLetter(lastColumn)));
}
public void SetColumnsToRepeatAtLeft(String firstColumnToRepeatAtLeft, String lastColumnToRepeatAtLeft)
{
SetColumnsToRepeatAtLeft(XLHelper.GetColumnNumberFromLetter(firstColumnToRepeatAtLeft), XLHelper.GetColumnNumberFromLetter(lastColumnToRepeatAtLeft));
}
/// <summary>
/// Initializes a new <see cref = "XLAddress" /> struct using a mixed notation.
/// </summary>
/// <param name = "worksheet"></param>
/// <param name = "rowNumber">The row number of the cell address.</param>
/// <param name = "columnLetter">The column letter of the cell address.</param>
/// <param name = "fixedRow"></param>
/// <param name = "fixedColumn"></param>
public XLAddress(XLWorksheet worksheet, int rowNumber, string columnLetter, bool fixedRow, bool fixedColumn)
: this(worksheet, rowNumber, XLHelper.GetColumnNumberFromLetter(columnLetter), fixedRow, fixedColumn)
{
_columnLetter = columnLetter;
}
public XLRangeColumn Column(String column)
{
return(Column(XLHelper.GetColumnNumberFromLetter(column)));
}
public IXLRangeColumns Columns(String firstColumn, String lastColumn)
{
return(Columns(XLHelper.GetColumnNumberFromLetter(firstColumn),
XLHelper.GetColumnNumberFromLetter(lastColumn)));
}
public virtual XLRangeColumn Column(String columnLetter)
{
return(Column(XLHelper.GetColumnNumberFromLetter(columnLetter)));
}
public IXLFilterColumn Column(String column)
{
return(Column(XLHelper.GetColumnNumberFromLetter(column)));
}