如何导出c＃datagridview到Excel [英] How to export c# datagridview into Excel
本文介绍了如何导出c＃datagridview到Excel的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
在我的应用程序中，需要将datagridview导出到Excel中。
In my application, there is requirement to export datagridview into Excel.
我正在使用以下源代码。我想要关于以下问题的专家建议。
I am using the following source code. I wanted expert advice on following questions.
-
我的代码是否正确？因为我没有在所选路径上保存任何文件。
Is my code is correct or not? because i am not getting any file saved at the selected path.
从网格导出数据时是否存在性能问题，因为可能会有多少数据网格可用？
Is there any performance issue while exporting data from grid, because there could be as many as data available in grid?
private void btnSaveResult_Click(object sender, EventArgs e)
{
try
{
if (this.saveFileDialog.ShowDialog() == DialogResult.OK)
{
saveFileDialog.Filter = "Execl files (*.xls)|*.xls";
saveFileDialog.FilterIndex = 0;
saveFileDialog.RestoreDirectory = true;
saveFileDialog.CreatePrompt = true;
saveFileDialog.Title = "Export Excel File To";
Microsoft.Office.Interop.Excel.ApplicationClass ExcelApp = new Microsoft.Office.Interop.Excel.ApplicationClass();
ExcelApp.Application.Workbooks.Add(Type.Missing);
ExcelApp.Columns.ColumnWidth = 30;
for (int i = 0; i < grdResult.Rows.Count; i++)
{
DataGridViewRow row = grdResult.Rows[i];
for (int j = 0; j < row.Cells.Count; j++)
{
ExcelApp.Cells[i + 1, j + 1] = row.Cells[j].ToString();
}
}
ExcelApp.ActiveWorkbook.Saved = true;
ExcelApp.Quit();
MessageBox.Show("The Save button was clicked or the Enter key was pressed" + "\nThe file would have been saved as " + this.saveFileDialog.FileName);
}
else MessageBox.Show("The Cancel button was clicked or Esc was pressed");
}
catch (Exception ex)
{
MessageBox.Show("Cancelled Save Operation");
this.Close();
}
}
推荐答案
尝试以下课程
using System;
using System.Data;
using System.Configuration;
using System.IO;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
/// <summary>
/// Summary description for GridViewExportUtil
/// </summary>
public class GridViewExportUtil
{
public GridViewExportUtil()
{
//
// TODO: Add constructor logic here
//
}
public static void ExportGridView(string fileName, GridView gv, Label header, Label date)
{
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", fileName));
HttpContext.Current.Response.ContentType = "application/ms-excel";
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
gv.AllowPaging = false;
// Create a table to contain the grid
Table table = new Table();
// include the gridline settings
table.GridLines = gv.GridLines;
gv.Style["font-family"] = "Tahoma";
// add the header row to the table
if (gv.HeaderRow != null)
{
GridViewExportUtil.PrepareControlForExport(gv.HeaderRow);
gv.HeaderRow.BackColor = System.Drawing.Color.Lavender;
gv.HeaderRow.ForeColor = System.Drawing.Color.Green;
table.Rows.Add(gv.HeaderRow);
}
// add each of the data rows to the table
foreach (GridViewRow row in gv.Rows)
{
GridViewExportUtil.PrepareControlForExport(row);
table.Rows.Add(row);
}
// add the footer row to the table
if (gv.FooterRow != null)
{
GridViewExportUtil.PrepareControlForExport(gv.FooterRow);
table.Rows.Add(gv.FooterRow);
}
htw.WriteLine("<br>");
// htw.WriteLine(" ");
if (header.Text != null)
{
header.Font.Size = 15;
header.Font.Bold = true;
header.ForeColor = System.Drawing.Color.Blue;
header.RenderControl(htw);
}
htw.WriteLine("</p>");
// render the table into the htmlwriter
table.RenderControl(htw);
htw.WriteLine("<br>");
htw.WriteLine("Report taken on :", System.Drawing.FontStyle.Bold);
if (date.Text != null)
{
date.ForeColor = System.Drawing.Color.Blue;
date.RenderControl(htw);
}
// render the htmlwriter into the response
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();
}
}
}
/// <summary>
/// Replace any of the contained controls with literals
/// </summary>
/// <param name="control"></param>
private static void PrepareControlForExport(Control control)
{
for (int i = 0; i < control.Controls.Count; i++)
{
Control current = control.Controls[i];
if (current is LinkButton)
{
control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as LinkButton).Text));
}
else if (current is ImageButton)
{
control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as ImageButton).AlternateText));
}
else if (current is HyperLink)
{
control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as HyperLink).Text));
}
else if (current is DropDownList)
{
control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as DropDownList).SelectedItem.Text));
}
else if (current is CheckBox)
{
control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as CheckBox).Checked ? "True" : "False"));
}
else if (current is Label)
{
control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as Label).Text));
}
if (current.HasControls())
{
GridViewExportUtil.PrepareControlForExport(current);
}
}
}
}
使用它如下
protected void Button1_Click(object sender, EventArgs e)
{
Label1.Visible = true;
Label2.Visible = true;
Label1.Text = "Login Information Data";
Label2.Text = Convert.ToString(System.DateTime.Now);
if (GridView1.Visible == true)
{
// GridViewExportUtil.Export("StateReport.xls", GridView1);
GridViewExportUtil.ExportGridView("LoginInformation.xls", GridView1, Label1, Label2);
}
}
如果您不想删除标签他们根据您的需要进行更改。
Remove labels if you do not want them.. make changes as per your need.
这篇关于如何导出c＃datagridview到Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
