菜：两个有关datagrid插入合计行的问题！ 谢谢！！！

Question

//导出到exceltry
{
SpreadsheetClass xlsheet = new SpreadsheetClass();
oleDbConnection1.Open();
OleDbDataReader reader = this.oleDbSelectCommand1.ExecuteReader(); int numbercols = reader.FieldCount; int row=1; while (reader.Read()) 
{
for (int i=0;i<numbercols;i++) 
{
xlsheet.ActiveSheet.Cells[row,i+1] = reader.GetValue(i).ToString();
}
row++;
} reader.Close(); this.oleDbConnection1.Close();
xlsheet.ActiveSheet.Export(Server.MapPath(".")+"\\"+"费用.xls",OWC.SheetExportActionEnum.ssExportActionNone); }
catch
{
lb_Message.Text = "导出失败，请重试！";
}
finally
{
}

Answer 1

http://msdn.microsoft.com/library/en-us/dndive/html/data01102002.asp?frame=true

Answer 2

http://msdn.microsoft.com/library/en-us/dndive/html/data01102002.asp?frame=true好贴子谢谢 underwear(▼)(底褲)