Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
How to export the web grid data in excel in formatted manner
Madhav Sharma
Nov 24 2017 6:07 AM
149
Reply
How to export the web grid data in excel with formatted manner
After importing excel data is not coming in formatted manner
WebGrid grid =
new
WebGrid(model.TicketReportDataModel, rowsPerPage: model.PageSize, canPage:
true
);
string
gridData = grid.GetHtml(
columns: grid.Columns(
grid.Column(columnName:
"ticketNo"
, header:
"Ticket No"
, canSort:
false
),
grid.Column(columnName:
"Summary"
, header:
"Title"
, canSort:
false
),
grid.Column(columnName:
"Contact_Name"
, header:
"Contact"
, canSort:
false
),
grid.Column(columnName:
"SR_Status"
, header:
"Status"
, canSort:
false
),
grid.Column(columnName:
"Site_Name"
, header:
"Site Name"
, canSort:
false
),
grid.Column(columnName:
"SR_Type_Description"
, header:
"Type"
, canSort:
false
),
grid.Column(columnName:
"Company"
, header:
"Company"
, canSort:
false
),
grid.Column(columnName:
"Board"
, header:
"Board"
, canSort:
false
),
grid.Column(columnName:
"Discussion"
, header:
"Discussion"
, canSort:
false
),
grid.Column(columnName:
"Resolution"
, header:
"Resolution"
, canSort:
false
),
grid.Column(columnName:
"SubType_Description"
, header:
"SubType"
, canSort:
false
),
grid.Column(columnName:
"Date_Entered"
, header:
"Date Entered"
, canSort:
false
))).ToString();
//ExcelPackage pk = new ExcelPackage();
Response.ClearContent();
Response.AddHeader(
"content-disposition"
,
"attachment; filename=TicketList.xls"
);
//Response.ContentType = "applicatiom/vnd.ms-excel";
Response.ContentType =
"application/octet-stream"
;
Response.Write(gridData);
Response.End();
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
How to capitalize first character after dot (.) and
Upload file using jquery ajax asp.net c# MVC , sql server db