protected SheetRowItem FindRow(uint rindex)
{
SheetRowItem result = null;
if (SheetRows != null && SheetRows.Any(x => x.RowIndex == rindex))
{
result = SheetRows.First(x => x.RowIndex == rindex);
}
return(result);
}
public void AddRow(SheetRowItem row)
{
if (SheetRows == null)
{
SheetRows = new List <SheetRowItem>();
}
if (SheetRows.Any(x => x.RowIndex == row.RowIndex))
{
throw new Exception("rowindex exist");
}
SheetRows.Add(row);
}
public void AddCell(SheetCellItem cell, uint rindex, SheetRowFormats rowFormats)
{
if (rindex < 1)
{
throw new ArgumentOutOfRangeException("rindex", "rowindex must greater than zero");
}
var r = FindRow(rindex);
if (r == null)
{
r = new SheetRowItem(new List <SheetCellItem>(), rindex);
if (rowFormats != null)
{
r.RowHeight = rowFormats.RowHeight;
}
AddRow(r);
}
cell.RowIndex = rindex;
r.RowCells.Add(cell);
}
protected Row CreateSheetRow(SheetRowItem item, uint rowIndex, SharedStringTablePart shareStringPart)
{
Row result = null;
if (item != null && item.RowCells != null && item.RowCells.Any())
{
result = new Row {
RowIndex = rowIndex
};
if (item.RowHeight > 0)
{
result.CustomHeight = BooleanValue.FromBoolean(true);
result.Height = item.RowHeight;
}
foreach (var itm in item.RowCells.OrderBy(x => x.ColIndex))
{
Cell cell = CreateCell(ColumnLetter((int)itm.ColIndex), item.RowIndex, itm.Data, itm.DataType, itm.Texts, shareStringPart, itm.FormatIndex);
result.AppendChild(cell);
}
}
return(result);
}
