public bool SaveExcel(GridView paramGridView) { if (paramGridView.Rows.Count == 0) { return false; } //创建Excel对象 Microsoft.Office.Interop.Excel.Application myExcel = new Microsoft.Office.Interop.Excel.Application(); myExcel.Application.Workbooks.Add(true); myExcel.Visible = true; //生成字段名称列名 for (int i = 0; i < paramGridView.Columns.Count; i++) { //第二行第二列开始录入 myExcel.Cells[2, i + 2] = paramGridView.Columns[i].HeaderText; } //填充数据 for (int i = 0; i < paramGridView.Rows.Count; i++) { for (int j = 0; j < paramGridView.Columns.Count; j++) { if (paramGridView.Rows[i].Cells[j].Text != null) { myExcel.Cells[i + 3, j + 2] = "'" + paramGridView.Rows[i].Cells[j].Text.ToString(); } } } return true; } protected void btnPrint_Click(object sender, EventArgs e) { SaveExcel(grdvMessage); }