我为诊所构建了一个患者管理软件,我需要将患者列表从 ASP.net 网格视图导出到 Excel 文件
我的问题是:
有没有办法将gridview导出到excel
我正在使用 vb.net 和 Visual Web Developer 2010
我将高级搜索页面的数据源存储到会话中并重定向到结果页面
这是结果页面的代码
Partial Class Sresults
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
GridView1.DataSource = Session("dsource")
GridView1.DataBind()
End Sub
Protected Sub Backbtn_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Backbtn.Click
Session("dsource") = ""
Response.Redirect("searchme.aspx")
End Sub
Protected Sub Page_PreRenderComplete(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.PreRenderComplete
Response.Write(GridView1.Rows.Count.ToString + " Records")
End Sub
End Class
尝试在按钮上单击以下代码
// Get DataTable that DataGrid is bound to.
var dataTable = (DataTable)dataGrid.DataSource;
// Create new ExcelFile.
var ef = new ExcelFile();
// Add new worksheet to the file.
var ws = ef.Worksheets.Add(dataTable.TableName);
// Insert the data from DataTable to the worksheet starting at cell "A1".
ws.InsertDataTable(dataTable, "A1", true);
// Stream file to browser.
Response.Clear();
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment; filename=Employee.xls");
ef.SaveXls(Response.OutputStream);
Response.End();
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)