private ExcelParser(IXLRangeBase range, CsvConfiguration configuration)
{
Workbook = range.Worksheet.Workbook;
this.range = range;
Configuration = configuration ?? new CsvConfiguration(CultureInfo.InvariantCulture);
FieldCount = range.CellsUsed().Max(cell => cell.Address.ColumnNumber) -
range.CellsUsed().Min(cell => cell.Address.ColumnNumber) + 1;
Context = new ReadingContext(TextReader.Null, Configuration, false);
FieldReader = new CsvFieldReader(TextReader.Null, Configuration, false);
}
private ExcelParser(IXLRangeBase range, CsvConfiguration configuration)
{
Workbook = range.Worksheet.Workbook;
this.range = range;
Configuration = configuration ?? new CsvConfiguration();
FieldCount = range.CellsUsed().Max(cell => cell.Address.ColumnNumber) - range.CellsUsed().Min(cell => cell.Address.ColumnNumber) + 1;
}
public static IXLCells CellsUsedWithoutFormulas(this IXLRangeBase range)
{
return(range.CellsUsed(c => !c.HasFormula));
}
public static IXLCells CellsUsedWithoutFormulas(this IXLRangeBase range, XLCellsUsedOptions options, Func <IXLCell, bool> predicate)
{
return(range.CellsUsed(options, c => predicate(c) && !c.HasFormula));
}
public static IXLCells CellsUsedWithoutFormulas(this IXLRangeBase range, XLCellsUsedOptions options)
{
return(range.CellsUsed(options, c => !c.HasFormula));
}