@{ Layout = null; var db = Database.Open("Northwind"); var sql = "SELECT CustomerID, CompanyName, ContactName, Address, City, Country, Phone FROM Customers"; var data = db.Query(sql); var grid = new WebGrid(data, canPage: false, canSort: false); Response.AddHeader("Content-disposition", "attachment; filename=report.xls"); Response.ContentType = "application/octet-stream"; } @grid.GetHtml( columns: grid.Columns( grid.Column("CustomerID", "ID"), grid.Column("CompanyName", "Company Name"), grid.Column("ContactName", "Contact Name"), grid.Column("Address"), grid.Column("City"), grid.Column("Country"), grid.Column("Phone") ) )
Wednesday, January 2, 2013
Exporting The Razor WebGrid To Excel
http://www.mikesdotnetting.com/Article/204/Exporting-The-Razor-WebGrid-To-Excel
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment