void CreateColumns(WorksheetView view)
{
view.Columns.Add(new ColumnView()
{
Header = "A", Width = 200
});
view.Columns.Add(new ColumnView()
{
Header = "B"
});
view.Columns.Add(new ColumnView()
{
Header = "C", Width = 100
});
view.Columns.Add(new ColumnView()
{
Header = "D", IsSelected = true
});
view.Columns.Add(new ColumnView()
{
Header = "E"
});
view.Columns.Add(new ColumnView()
{
Header = "F", Width = 80
});
view.Columns.Add(new ColumnView()
{
Header = "G", Width = 120
});
view.Columns.Add(new ColumnView()
{
Header = "H"
});
}
public Task <WorksheetView> GetWorksheetViewAsync()
{
var result = new WorksheetView()
{
Name = "Sheet1"
};
CreateColumns(result);
CreateRows(result);
return(Task.FromResult(result));
}
void CreateRows(WorksheetView view)
{
for (int i = 0; i < 30; i++)
{
var row = new RowView()
{
Header = $"{i + 1}", IsSelected = i == 8
};
row.Height = 20;
row.Cells.Add(CellView.MakeText($"Sample { i + 1}")); // A
row.Cells.Add(CellView.MakeNumeric(i + 1)); // B
row.Cells.Add(CellView.MakeBool(i % 2 != 0)); // C
row.Cells.Add(
CellView.MakeNumeric(1.0 / (i + 1))
.Selected(i == 8)); // D
row.Cells.Add(CellView.MakeEmpty()); // E
row.Cells.Add(CellView.MakeError(i % 2 != 0 ? "#REF!" : "#N/A")); // F
row.Cells.Add(CellView.MakeText($"text { i + 1}")); // G
row.Cells.Add(CellView.MakeEmpty()); // H
view.Rows.Add(row);
}
}
