public DataTable ConvertCellSetToDataTable(ICellSetWrapper cellSet)
{
if (cellSet == null)
{
return(null);
}
var dataTable = new DataTable();
SetColumns(cellSet, dataTable);
WriteValues(cellSet, dataTable);
return(dataTable);
}
private void SetColumns(ICellSetWrapper cellSet, DataTable dataTable)
{
//...read data from this CellSet and build data columns
}
private void WriteValues(ICellSetWrapper cellSet, DataTable dataTable)
{
//...assign value to datarows
}
