protected void Button4_Click(object sender, EventArgs e)
{
CExcelBase Tp_ExcelObj = new CExcelBase();
CExcelBE be = new CExcelBE(1, 1, "100000000", "A1", "B1", "GRAY", true, 12, "", null);
Tp_ExcelObj.InsertData(be);
}
public void InsertData(CExcelBE be)
{
worksheet.Cells[be.Row, be.Col] = be.Text;
workSheet_range = worksheet.get_Range(be.StartCell, be.EndCell);
workSheet_range.Interior.Color = GetColorValue(be.InteriorColor);
workSheet_range.MergeCells = be.IsMerge;
workSheet_range.Borders.Color = System.Drawing.Color.Black.ToArgb();
workSheet_range.ColumnWidth = be.Size;
workSheet_range.Font.Color = string.IsNullOrEmpty(be.FontColor) ?
System.Drawing.Color.White.ToArgb() : System.Drawing.Color.Black.ToArgb();
workSheet_range.NumberFormat = be.Formart;
}
