tag:blogger.com,1999:blog-32696142.post953305445474060887..comments2024-02-19T01:02:59.086-06:00Comments on ASP.Net, C#, SQL, JQuery, Sharepoint: Export datagrid to Excel in asp.net (Revised)Unknownnoreply@blogger.comBlogger19125tag:blogger.com,1999:blog-32696142.post-46322963990545010752014-05-12T23:56:14.778-05:002014-05-12T23:56:14.778-05:00Well this is a good example of exporting grid view...Well this is a good example of exporting grid view data to Excel. but If I have more than 20 columns in a grid fewer are visible but rest are hide. and want to export all data then what should I do, this problem I am facing actually this is my requirement/my Application Requirement, so do you have any solution for that....I want to export 20 columns gridview data to Excel file.... with 500 Anonymoushttps://www.blogger.com/profile/10227961428814556727noreply@blogger.comtag:blogger.com,1999:blog-32696142.post-10415431734963741732013-09-04T12:50:21.619-05:002013-09-04T12:50:21.619-05:00It says return table does not exist in the context...It says return table does not exist in the context. How do I resolve this issue?<br /><br />Also, when I export to excel, it does not populate table data. It only lists the table header. Any clue?Sheekha Khetanhttps://www.blogger.com/profile/17367936985471020013noreply@blogger.comtag:blogger.com,1999:blog-32696142.post-23913519881589096092011-11-23T03:45:36.219-06:002011-11-23T03:45:36.219-06:00Hi
Thanks for your post. Like the same what they...Hi<br /><br /> Thanks for your post. Like the same what they discussed above ,after exporting the buttons are not fire. Can you help me on this issue.Rajeshhttps://www.blogger.com/profile/02514765779345154552noreply@blogger.comtag:blogger.com,1999:blog-32696142.post-77724996865538248602011-08-30T00:07:11.991-05:002011-08-30T00:07:11.991-05:00Hi,
Its useful code,but
after Exporting it is sh...Hi,<br /><br />Its useful code,but<br /><br />after Exporting it is showing Excel Sheet is not in Correct Format.Jagadeesh Arasoorhttps://www.blogger.com/profile/10944033463279270754noreply@blogger.comtag:blogger.com,1999:blog-32696142.post-78162044365567787472011-07-07T19:10:55.840-05:002011-07-07T19:10:55.840-05:00Great article, thanks for sharing. Also have a loo...Great article, thanks for sharing. Also have a look at this post, it shows some nice features of excel 2007 based reports:-<br /><br /><a href="http://zeeshanumardotnet.blogspot.com/2011/06/creating-reports-in-excel-2007-using.html" rel="nofollow">Export to Excel</a>Zeeshan Umarhttps://www.blogger.com/profile/01125467646308887769noreply@blogger.comtag:blogger.com,1999:blog-32696142.post-44539269277108874082011-03-02T12:35:13.227-06:002011-03-02T12:35:13.227-06:00thanks for providing such nice posts of coding wit...thanks for providing such nice posts of coding with good explanations. But one thing I really need is that i want to deploy my own web site in my local iis 5.1 or 6.0. since i'm some what good to design my own asp.net website but don't know the deploymeny. I beleive you could help me in acheiving this.One request is that plaese give me a good step by step procedure will do good.For Your VENKATESHhttps://www.blogger.com/profile/02740269037167592862noreply@blogger.comtag:blogger.com,1999:blog-32696142.post-76700542505296870022010-10-17T02:18:30.293-05:002010-10-17T02:18:30.293-05:00@Sarbjeet
It Return DataTable consisting data. ...@Sarbjeet <br /><br />It Return DataTable consisting data. Here i have asume that this function would return DataTable.DotNetGutshttps://www.blogger.com/profile/12732063013510099746noreply@blogger.comtag:blogger.com,1999:blog-32696142.post-40529178145278665042010-10-16T22:28:29.897-05:002010-10-16T22:28:29.897-05:00where is the ReturnTable()where is the ReturnTable()R.S.Bainshttps://www.blogger.com/profile/12341691851948652496noreply@blogger.comtag:blogger.com,1999:blog-32696142.post-78595545567175876792010-04-19T03:47:21.212-05:002010-04-19T03:47:21.212-05:00hi wassim,
I have same error, have you solved this...hi wassim,<br />I have same error, have you solved this issue?<br /><br />thanks and regardsyangibamhttps://www.blogger.com/profile/12738807956031992770noreply@blogger.comtag:blogger.com,1999:blog-32696142.post-27228573142338067392009-11-03T05:04:12.245-06:002009-11-03T05:04:12.245-06:00Hi, thank you for code it was very useful for me a...Hi, thank you for code it was very useful for me and saved a lot of time, however when I try to open the generated file, I get a windows message: “the file your are trying to open…….xls is in different format than specified by the file extension verify that the file is not corrupted and is from trusted source befor opening the file, do you want to open the file now ?“<br />Any ideas why this wassimhttps://www.blogger.com/profile/11498855652444841034noreply@blogger.comtag:blogger.com,1999:blog-32696142.post-31185090335233492552009-05-08T13:28:00.000-05:002009-05-08T13:28:00.000-05:00@Prerita,
You are right, ReturnTable is actual da...@Prerita,<br /><br />You are right, ReturnTable is actual dataset which might be DATATABLE, this is your actual data.DotNetGutshttps://www.blogger.com/profile/12732063013510099746noreply@blogger.comtag:blogger.com,1999:blog-32696142.post-84914245572325556192009-05-08T09:15:00.000-05:002009-05-08T09:15:00.000-05:00Hi, In my case it says, ReturnTable() does not exi...Hi, In my case it says, ReturnTable() does not exist in the current context?Unknownhttps://www.blogger.com/profile/10058068221876114142noreply@blogger.comtag:blogger.com,1999:blog-32696142.post-62871575968139325562009-04-27T15:38:00.000-05:002009-04-27T15:38:00.000-05:00I have the same issue, when debugging it seems no ...I have the same issue, when debugging it seems no code is executed after the Response.End()Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-32696142.post-32730982732192654172009-03-16T16:19:00.000-05:002009-03-16T16:19:00.000-05:00Amit-I am having the same issue. After I export t...Amit-<BR/><BR/>I am having the same issue. After I export to excel none of my button work. If I debug a post-back in not happening when I click. Did you ever resolve this issue and if so how?Danhttps://www.blogger.com/profile/00305812825461544381noreply@blogger.comtag:blogger.com,1999:blog-32696142.post-22850196517713195532009-01-29T06:18:00.000-06:002009-01-29T06:18:00.000-06:00Hi Amit,Export button is independent of code you m...Hi Amit,<BR/><BR/>Export button is independent of code you might be executing, so such a behavior is unexpected. Have you tried debugging? I am 100% sure that it cannot be because of this code. Do reply me if you found the root cause of problem.DotNetGutshttps://www.blogger.com/profile/12732063013510099746noreply@blogger.comtag:blogger.com,1999:blog-32696142.post-16331699113573004502009-01-28T22:50:00.000-06:002009-01-28T22:50:00.000-06:00Hi,This code works fine for exporting but after ex...Hi,<BR/><BR/>This code works fine for exporting but after exporting the grid to excel events on page are not firing.<BR/><BR/>I have a button for generating report within some scope.On clicking this button,datagrid gets filled with report and on clicking Export the filled datagrid is exported to excel.<BR/><BR/>But once export is done,this generate button stops firing.<BR/><BR/>Any ideas why thisAmithttps://www.blogger.com/profile/00313711361025485220noreply@blogger.comtag:blogger.com,1999:blog-32696142.post-67492001349149181982009-01-06T09:37:00.000-06:002009-01-06T09:37:00.000-06:00This is great - works well - I searched for ages t...This is great - works well - I searched for ages trying to find this solution...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-32696142.post-73572305016182621142008-12-08T03:39:00.000-06:002008-12-08T03:39:00.000-06:00thanks it is working perfectly in my asp.net appli...thanks <BR/>it is working perfectly in my asp.net application<BR/>thanks a lotSharadhttps://www.blogger.com/profile/13270756732861826715noreply@blogger.comtag:blogger.com,1999:blog-32696142.post-22814990436344067702008-06-13T07:24:00.000-05:002008-06-13T07:24:00.000-05:00Hi,Well this code works perfectly, however you sho...Hi,<BR/>Well this code works perfectly, however you should note that the file created is not a "real" XLS (BIFF) file.<BR/><BR/>If you want to work with "real" Excel files (XLS, XLSX or CSV) you could try some third party components (http://www.gemboxsoftware.com/GBSpreadsheet.htm).<BR/><BR/>Also if you want to build import/export to XLSX (Excel 2007) files yourself, look at this article:<BR/>Unknownhttps://www.blogger.com/profile/00829436672770906383noreply@blogger.com