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))); }