public static DataSet ApplyRules(this DataSet ds, XlsReaderOptions options)
{
var newDs = ds.Copy();
if (!String.IsNullOrEmpty(options.CommentSymbol))
{
var _commentSymbol = options.CommentSymbol;
foreach (DataTable table in ds.Tables)
{
if (table.TableName.StartsWith(_commentSymbol))
{
newDs.Tables.Remove(table.TableName);
}
else
{
foreach (DataColumn column in table.Columns)
{
if (column.ColumnName.StartsWith(_commentSymbol))
{
newDs.Tables[table.TableName].Columns.Remove(newDs.Tables[table.TableName].Columns[column.ColumnName]);
}
}
}
}
}
if (!String.IsNullOrEmpty(options.SheetNames))
{
var _sheets = options.SheetNames.Split(',').Select(x => x.Trim()).ToList();
foreach (DataTable table in ds.Tables)
{
if (_sheets != null && !_sheets.Contains(table.TableName))
{
newDs.Tables.Remove(table.TableName);
}
}
}
return(newDs);
}
public IFormatReader <XlsReaderOptions> CreateXlsReader(XlsReaderOptions options)
{
return(new XlsReader(options));
}
public ISource CreateXlsSource(XlsReaderOptions options)
{
var reader = _readerFactory.CreateXlsReader(options);
return(CreateSourceFromReader(reader));
}