public Models.DataTable ObtainTable(string filePath, IEnumerable <FilterValue> filterValues, bool isEditable, string sheetName = "")
{
var dataTable = new Models.DataTable();
using (var document = SpreadsheetDocument.Open(filePath, isEditable))
{
dataTable.DataRows = ExtractDataFromDocument(document, filterValues, sheetName);
}
return(dataTable);
}
public Models.DataTable ObtainTable(Stream stream, IEnumerable <FilterValue> filterValues, bool isEditable, bool disposeStreamAfterReading = true, string sheetName = "")
{
var dataTable = new Models.DataTable();
using (var document = SpreadsheetDocument.Open(stream, isEditable))
{
dataTable.DataRows = ExtractDataFromDocument(document, filterValues, sheetName);
}
return(dataTable);
}
public async Task <Models.DataTable> ObtainTableAsync(Stream stream, IEnumerable <FilterValue> filterValues, bool isEditable, string sheetName = "")
{
var dataTable = new Models.DataTable();
using (var document = SpreadsheetDocument.Open(stream, isEditable))
{
var rows = await ExtractDataFromDocumentAsync(document, filterValues, sheetName);
dataTable.DataRows = rows.ToList();
}
return(dataTable);
}
public Models.DataTable WriteToTable(Stream stream, IEnumerable <FilterSet> filterSets, bool isEditable, RowStyles rowStyle, string sheetName = "")
{
var dataTable = new Models.DataTable();
using (SpreadsheetDocument document =
SpreadsheetDocument.Open(stream, true))
{
var result = WriteDataToDocument(document, filterSets, rowStyle == RowStyles.Bordered, sheetName);
document.Save();
}
dataTable.DataRows = null;
return(dataTable);
}
