tag:blogger.com,1999:blog-12419046.post114553940374351593..comments2023-09-09T06:35:12.217-07:00Comments on Lakshmi's Tech Doodles: ASP.NET : Export to Excel/Word from Nested GridViewsLakshmihttp://www.blogger.com/profile/05033914754047255171noreply@blogger.comBlogger30125tag:blogger.com,1999:blog-12419046.post-72943319705150092302013-05-14T22:41:01.031-07:002013-05-14T22:41:01.031-07:00This is a very very Helpful Article...This is a very very Helpful Article...S.K.Guptahttps://www.blogger.com/profile/16953141873118898205noreply@blogger.comtag:blogger.com,1999:blog-12419046.post-8108253273311955132013-05-14T22:40:16.987-07:002013-05-14T22:40:16.987-07:00It's a very very good article...It's a very very good article...S.K.Guptahttps://www.blogger.com/profile/16953141873118898205noreply@blogger.comtag:blogger.com,1999:blog-12419046.post-18182419981802175282011-11-30T02:27:16.297-08:002011-11-30T02:27:16.297-08:00Many Thanks for posting this article Lakshmi !
It ...Many Thanks for posting this article Lakshmi !<br />It worked as expected for me.Udayhttps://www.blogger.com/profile/07370783431114848725noreply@blogger.comtag:blogger.com,1999:blog-12419046.post-1071483581193241642010-07-09T07:39:33.404-07:002010-07-09T07:39:33.404-07:00Hi.
It work fine.
I have problem when i click in O...Hi.<br />It work fine.<br />I have problem when i click in OPEN (when i have 3 option : OPEM|SAVE|CANCEL)<br />whe system need user and password, finally open excel with page content.<br />Any have same problem???<br />Please i need help.Marco Diazhttps://www.blogger.com/profile/12375669788875502691noreply@blogger.comtag:blogger.com,1999:blog-12419046.post-64376263737210704982010-04-09T05:03:06.978-07:002010-04-09T05:03:06.978-07:00nice article exactly the same for which i was look...nice article exactly the same for which i was lookingUnknownhttps://www.blogger.com/profile/01292717304500506779noreply@blogger.comtag:blogger.com,1999:blog-12419046.post-58006777291697766702010-01-26T05:38:35.220-08:002010-01-26T05:38:35.220-08:00nice post! how we make colors and font formatting?...nice post! how we make colors and font formatting?Abhijit Aitwadehttps://www.blogger.com/profile/16731885123677799217noreply@blogger.comtag:blogger.com,1999:blog-12419046.post-53263988706282302372009-07-22T04:09:18.108-07:002009-07-22T04:09:18.108-07:00HI laxmi
very nice article. but i want to export ...HI laxmi<br /><br />very nice article. but i want to export more than one html pages to single word file. how can i do this,<br /><br />thanks in advanceUnknownhttps://www.blogger.com/profile/04235781504230240730noreply@blogger.comtag:blogger.com,1999:blog-12419046.post-41565508523358372312009-07-22T04:07:40.862-07:002009-07-22T04:07:40.862-07:00hello.. it is very nice article.
but i want more ...hello.. it is very nice article.<br /><br />but i want more than on2e html page to export into single word file..<br /><br />give me solution.<br /><br />Thank in advanceUnknownhttps://www.blogger.com/profile/04235781504230240730noreply@blogger.comtag:blogger.com,1999:blog-12419046.post-19584333027181641592009-07-21T03:11:28.702-07:002009-07-21T03:11:28.702-07:00Hi Lakshmi,
Very Nice Article,BUt I had a problem ...Hi Lakshmi,<br />Very Nice Article,BUt I had a problem here.I want to export data in different worksheet,i mean from one dataset if there are 100 rows ten for each customer then there should be 10 worksheets.I want to avoid use of COM or third party components. <br />Can you please help me out?testsethttps://www.blogger.com/profile/12937562595861862060noreply@blogger.comtag:blogger.com,1999:blog-12419046.post-75080283184864417072009-06-07T23:57:46.289-07:002009-06-07T23:57:46.289-07:00I have used the same sample with all the steps tha...I have used the same sample with all the steps that u have mentioned above. but im getting a excel sheet with empty rows. Can u pls help me out?Unknownhttps://www.blogger.com/profile/09854820613253296125noreply@blogger.comtag:blogger.com,1999:blog-12419046.post-90900858270617609632009-06-07T23:28:44.945-07:002009-06-07T23:28:44.945-07:00Hi Lakshmi,
I tried the same sample with the steps...Hi Lakshmi,<br />I tried the same sample with the steps that you have mentioned, I got a filename.xls file with empty rows. Can you please help me out?<br /><br />Thanks,<br />RajiUnknownhttps://www.blogger.com/profile/09854820613253296125noreply@blogger.comtag:blogger.com,1999:blog-12419046.post-56014346072658610582009-03-18T00:55:00.000-07:002009-03-18T00:55:00.000-07:00Hi,I want to export all the web page data to word ...Hi,<BR/>I want to export all the web page data to word document. This web page also containing chart.<BR/><BR/>Could you please suggest me how to export these charts to the word.<BR/><BR/>Thanks...<BR/>PankajUnknownhttps://www.blogger.com/profile/08327388224655651977noreply@blogger.comtag:blogger.com,1999:blog-12419046.post-48579054890704397492009-03-05T09:28:00.000-08:002009-03-05T09:28:00.000-08:00in the page_load eventin the page_load eventVincyhttps://www.blogger.com/profile/08791659693990145823noreply@blogger.comtag:blogger.com,1999:blog-12419046.post-49523729542004201212009-03-04T02:58:00.000-08:002009-03-04T02:58:00.000-08:00Thank you for this great articalsput i am facing a...Thank you for this great articals<BR/>put i am facing a problem where to put this <BR/>btnExport.Attributes.Add("OnClick", "getInnerHtml();");<BR/>i tried to put it in btnExport.click but still i get an emmpty hidden field<BR/>please help meMOFhttps://www.blogger.com/profile/09771537921519630885noreply@blogger.comtag:blogger.com,1999:blog-12419046.post-63644622498947383532008-12-08T15:52:00.000-08:002008-12-08T15:52:00.000-08:00Maximum rows are depending on the version of excel...Maximum rows are depending on the version of excel you are using. Meaning it really does not care at the Server. Its all happening at the client when the request is made, the server exports and and sends the file to client. But if the client has excell 2003 or earlier then they are limited to 65536 rows (remember this limitation is from excel) but if the client has excel 2007 then its million (http://blogs.msdn.com/excel/archive/2005/09/26/474258.aspx). <BR/><BR/>for the image if it is showing up on the web then it should show on the export as well unless you mess up the path as you export it. Check back your export code and see whether its using the right path for it.<BR/><BR/>Hope, this helpsVincyhttps://www.blogger.com/profile/08791659693990145823noreply@blogger.comtag:blogger.com,1999:blog-12419046.post-75740796205431610762008-12-02T02:06:00.000-08:002008-12-02T02:06:00.000-08:00Hi,Can you tell me how much maximum rows i can exp...Hi,<BR/>Can you tell me how much maximum rows i can export and also<BR/>there is image in my grid.<BR/>But it is not showing in Exported excel sheet?<BR/>PlEASE HELP MEDotNetTechhttps://www.blogger.com/profile/01991073264232660315noreply@blogger.comtag:blogger.com,1999:blog-12419046.post-33685294391780551242008-11-20T06:27:00.000-08:002008-11-20T06:27:00.000-08:00You neither need licence nor office installed on t...You neither need licence nor office installed on the server because its not using any of the office component to generate export. However, the user must have either Office or Excel/Word viewer in his/her machine in order to view the exported file.<BR/><BR/>Hope, this helps. :)Vincyhttps://www.blogger.com/profile/08791659693990145823noreply@blogger.comtag:blogger.com,1999:blog-12419046.post-8305197283235337002008-11-18T14:04:00.000-08:002008-11-18T14:04:00.000-08:00Hi, very useful article. Does any one knows if I n...Hi, very useful article. Does any one knows if I need an MS-Office license installed in my server to be able to export to doc?. I know there is no technical need for it, I just wanna know if I need a license since I will be running a commercial application on my server.<BR/><BR/>RegardsAlex Househttps://www.blogger.com/profile/11098886925476559735noreply@blogger.comtag:blogger.com,1999:blog-12419046.post-42041193233099449002008-08-21T12:56:00.000-07:002008-08-21T12:56:00.000-07:00Madhuri,if your excel sheet is empty that means JS...Madhuri,<BR/><BR/>if your excel sheet is empty that means JS function is not able to find the DIV object properly. keep in mind that if you use runat='server' tag at the div and hidden text box declaration then the compiler is changing id while compiling. In my case what I did is, for the JS func i added two arguments and on the page load I passed both div and hidden text box as he parameter as shown below:<BR/><BR/>Here is the JS function:<BR/>function getInnerHtml(oDiv, oHdn) {<BR/>oHdn.value = oDiv.innerHTML;<BR/>}<BR/><BR/>and on the pageload like this:<BR/>btnExpPage.Attributes.Add("OnClick", string.Format("getInnerHtml({0},{1});",divExp.ClientID, hdnExp.ClientID));<BR/><BR/>Hope, this helps if it doesn't then ping me at vd133@att.com.Vincyhttps://www.blogger.com/profile/08791659693990145823noreply@blogger.comtag:blogger.com,1999:blog-12419046.post-12641439451177627022008-06-25T10:00:00.000-07:002008-06-25T10:00:00.000-07:00Hi Lakshmi,This code doesnt seem to work for me. I...Hi Lakshmi,<BR/>This code doesnt seem to work for me. <BR/><BR/>Its populating a empty excel sheet. Can you please help?<BR/><BR/>Regrds,<BR/>MadhuriShttps://www.blogger.com/profile/18048537625522089460noreply@blogger.comtag:blogger.com,1999:blog-12419046.post-62643714312278461332008-06-24T12:58:00.000-07:002008-06-24T12:58:00.000-07:00I dont see any data in theg excel sheet , exactly ...I dont see any data in theg excel sheet , exactly implemented in teh way specified and also added validaterequest= false .<BR/>Please help me...<BR/>Your help will be very much appreciatedShttps://www.blogger.com/profile/18048537625522089460noreply@blogger.comtag:blogger.com,1999:blog-12419046.post-69630585826880332522008-05-07T06:08:00.000-07:002008-05-07T06:08:00.000-07:00Sams, you need to add this line of code ExportToEx...Sams, you need to add this line of code <I>ExportToExcel1.Attributes.Add("OnClick", "getInnerHtml()");</I> before you call <I>ExportToExcel1_click()</I> event. If you add it in the click event procedure itself, of course it won't work. Put it in the Page_Load() and try again.Milicahttps://www.blogger.com/profile/12546441364824363863noreply@blogger.comtag:blogger.com,1999:blog-12419046.post-53869290561528804082008-03-24T18:56:00.000-07:002008-03-24T18:56:00.000-07:00hihow export to word with the my template (some li...hi<BR/>how export to word with the my template (some line string, table).<BR/>I haven't idea to do it<BR/>thanksUnknownhttps://www.blogger.com/profile/07678586647743254109noreply@blogger.comtag:blogger.com,1999:blog-12419046.post-67496928174283063512008-03-18T22:06:00.000-07:002008-03-18T22:06:00.000-07:00Hi, I am an entry level .net programmer. I used Ex...Hi, I am an entry level .net programmer. I used ExportToExcel1.Attributes.Add("OnClick", "getInnerHtml()"); in .cs file on ExportToExcel1_click() event. But the js function is not executing.Can any body please help me.I pasted js function (getInnerHtml())in .aspxsamshttps://www.blogger.com/profile/07165500354548327868noreply@blogger.comtag:blogger.com,1999:blog-12419046.post-64814273860673727642008-01-24T19:38:00.000-08:002008-01-24T19:38:00.000-08:00Nice article works fine when set set ValidateRe...Nice article works fine when set <BR/>set ValidateRequest="false" at page attributealexhttps://www.blogger.com/profile/05288452566762093210noreply@blogger.com