/// <summary>
/// Populates a worksheet with data
/// </summary>
/// <param name="activeSheet"></param>
public void Populate(Excel.IAmAWorksheet activeSheet)
{
foreach (var column in _rows.SelectMany(row => row))
{
column.Populate(activeSheet);
}
}
/// <summary>
/// Returns a Sheet from a Worksheet
/// </summary>
/// <param name="worksheet"></param>
/// <returns></returns>
public static Sheet FromWorksheet(Excel.IAmAWorksheet worksheet)
{
var sheet = new Sheet();
var index = 1;
while (!String.IsNullOrWhiteSpace((string)(worksheet.Cell(index, 1).Value)))
{
var row = sheet.AddRow();
row.AddColumn().Value = worksheet.Cell(index, 1).Value;
row.AddColumn().Value = worksheet.Cell(index, 2).Value;
index++;
}
return(sheet);
}
/// <summary>
/// Sets the value of a cell in a row
/// </summary>
/// <param name="sheet"></param>
public void Populate(Excel.IAmAWorksheet sheet)
{
sheet.Cell(_rowIndex, _index).Value = Value;
}
