/// <summary>
/// 插入一行数据
/// </summary>
/// <param name="row">待插入的数据行</param>
/// <param name="CStyle">数据行统一单元格样式</param>
public void InsertCellRow(CellRow row, CellStyle CStyle = null)
{
for (int i = row.LeftIndex; i <= row.RightIndex; i++)
{
SCell scell = new SCell();
scell.CStyle = CStyle ?? new CellStyle();
scell.Y = i;
scell.X = row.RowIndex;
if (row.Is_Pic)
{
scell.Image_Ms = (MemoryStream)(object)row.Obj_List[i - row.LeftIndex];
}
else
{
scell.Txt_Obj = (object)row.Obj_List[i - row.LeftIndex];
}
this.SCells.Add(scell);
}
}
/// <summary>
/// 插入一列数据
/// </summary>
/// <param name="rowlist">待插入数据列列表</param>
/// <param name="CStyle">数据列统一单元格样式</param>
public void InsertCellColm(CellColm clom, CellStyle CStyle = null)
{
for (int i = clom.TopIndex; i <= clom.ButtomIndex; i++)
{
SCell scell = new SCell();
scell.CStyle = CStyle ?? new CellStyle();
scell.Y = clom.ColmIndex;
scell.X = i;
if (clom.Is_Pic)
{
scell.Image_Ms = (MemoryStream)(object)clom.Obj_List[i - clom.TopIndex];
}
else
{
scell.Txt_Obj = (object)clom.Obj_List[i - clom.TopIndex];
}
this.SCells.Add(scell);
}
}
/// <summary>
/// 插入标题
/// </summary>
/// <param name="Inner_objlist">标题填充内容List</param>
/// <param name="Style">标题单元格样式</param>
/// <param name="TitleType">标题类型 1列标题 2行标题</param>
/// <param name="FillModel">(0,0)单元格填充模式</param>
public void InsertTitle(IList <object> Inner_objlist, CellStyle Style = null, TitleType TitleType = TitleType.列标题, FillModel FillModel = FillModel.空出第一个单元格)
{
if (FillModel == FillModel.没有标题)
{
return;
}
for (int i = 0; i < Inner_objlist.Count; i++)
{
SCell scell = new SCell
{
CStyle = Style ?? new CellStyle(),
Txt_Obj = Inner_objlist[i]
};
if (TitleType == ExcelFormat.TitleType.列标题)
{
if (FillModel == FillModel.列标题填充)
{
scell.Y = i;
}
else
{
scell.Y = i + 1;
}
this.SCells.Add(scell);
}
else if (TitleType == ExcelFormat.TitleType.行标题)
{
if (FillModel == FillModel.行标题填充)
{
scell.X = i;
}
else
{
scell.X = i + 1;
}
this.SCells.Add(scell);
}
}
}
