我用streamwriter对象,将reader中的内容,写入到了一个excel文档,代码大概如下如下。请问如何为该文档再添加一些文本注释,即引用excel的某些单元格,给他们添加内容
StreamWriter w = new StreamWriter(Server.MapPath("test3.xls"), false,Encoding.UTF32);
for (int i = 0; i < Reader.FieldCount; ++i)
{
w.Write(Reader.GetName(i));
w.Write('\t');
}
----------
w.Flush();
w.Close();
Reader.Close();
StreamWriter w = new StreamWriter(Server.MapPath("test3.xls"), false,Encoding.UTF32);
for (int i = 0; i < Reader.FieldCount; ++i)
{
w.Write(Reader.GetName(i));
w.Write('\t');
}
----------
w.Flush();
w.Close();
Reader.Close();
Excel.ApplicationClass excel = new Excel.ApplicationClass();
excel.Application.Workbooks.Add(true);
excel.get_Range (excel.Cells[1,1],excel.Cells[1,30]).MergeCells = true ;
excel.get_Range(excel.Cells[1, 1], excel.Cells[1, 30]).HorizontalAlignment =Excel.XlVAlign .xlVAlignCenter ;
excel.get_Range(excel.Cells[1, 1], excel.Cells[1, 30]).Font.Size = "22";
excel.get_Range(excel.Cells[2, 1], excel.Cells[2, 30]).MergeCells = true;//单元格合并
excel.Cells[1, 1] = "这里写要在单元格中显示的文本";
da = new SqlDataAdapter("selectdata", conn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.Fill(ds, "selectdatatable");
int rowcount = ds.Tables["selectdatatable"].Rows.Count;
int colcount = ds.Tables["selectdatatable"].Columns.Count;
for (int i = 1; i <= colcount; i++)
excel.Cells[3, i] = ds.Tables["selectdatatable"].Columns[i-1].ColumnName;
for (int i = 1; i <= rowcount; i++)
{
for (int j = 1; j <= colcount; j++)
{
excel.Cells[i + 3, j] = ds.Tables[0].Rows[i - 1].ItemArray.GetValue(j-1);
} }
excel.Visible = true;