internet explorer 8 - Exporting HTML table to Excel, file created but encoded HTML inside Excel sheet -

-

i exporting html table excel file. using other browsers:

window.open('data:application/vnd.ms-excel,<meta http-equiv="content-type" content="text/plain; charset=utf-8"/>' + encodeuricomponent(tblhtml));

but ie8, have done following make export work:

  1. jquery post send table html markup string

  2. javascript doing post request:

    if (($.browser.msie && parseint($.browser.version) <= 8)) {     $.ajax({         url: '/exportdatatoexcel',         data: {             'tbltoexport': tblhtml//encodeuricomponent(tblhtml)             , 'tblid': id         },         type: 'post',         async: false,         success: function (html) {             //nothing         },         error: function (jqxhr, textstatus, errorthrown) {             if (jqxhr.readystate != 0) {                 alert('error occurred');             }         }     });      window.open("/exportdatatoexcelfilesavedialog", 'popup', 'width=500,height=300'); }

  3. action handles post request , window.open request (for opening file save dialog):

    [httppost] [validateinput(false)] public actionresult exportdatatoexcel(formcollection form) {     string tbltoexport = form["tbltoexport"], tblid = form["tblid"];      session["exporttbl"] = tbltoexport;      contentresult content = new contentresult();     return content; } [validateinput(false)] public actionresult exportdatatoexcelfilesavedialog() {     response.contenttype = "application/vnd.ms-excel";      response.addheader("content-disposition", "attachment;filename=download.xls");     response.contentencoding = system.text.encoding.utf8;      object tbltoexport = session["exporttbl"];     return partialview("_exporttoexcelforie8", tbltoexport.tostring());  }

now, when file save dialog opens can able save excel file excel file content is:

%0d%0a%3ctable+dir%3dltr+id%3dtblcompanalysis+class%3d%22clear+table+company-analysis-general%22+cellspacing%3d0+cellpadding%3d0+width%3d%22100%25%22%3e%3ctbody%3e%0d%0a%3ctr+class%3d%22labh+sort%22%3e%0d%0a%3ctd%3ecompany%3c%2ftd%3e%0d%0a%3ctd%3emarket+sector%3c%2ftd%3e%0d%0a%3ctd%3eargaam+sector+%3c%2ftd%3e%0d%0a%3ctd+class%3dcity%3ecity%3c%2ftd%3e%0d%0a%3ctd+class%3dtel%3ephone%3c%2ftd%3e%0d%0a%3ctd+class%3dtel%3efax%3c%2ftd%3e%0d%0a%3ctd%3eemail%3c%2ftd%3e%0d%0a%3ctd%3ewebsite%3c%2ftd%3e%3c%2ftr%3e%0d%0a%3ctr%3e%0d%0a%3ctd%3e%3c


Comments

Post a Comment

Popular posts from this blog

java - WrongTypeOfReturnValue exception thrown when unit testing using mockito -

-
my test list<person> mylist; @test public void testisvalidperson() { mylist = new arraylist<person>(); mylist.add(new person("tom")); when(persondao.get(person)).thenreturn(mylist); when((persondao.get(person)).isempty()).thenreturn(false);//------exception thrown boolean result = service.isvalid("tom"); assertfalse(result); } method tested: public boolean isvalid(string person){ persondao = new persondao(); person personobj = new person(person); return (persondao.get(person).isempty())?false : true; } exception thrown: org.mockito.exceptions.misusing.wrongtypeofreturnvalue: boolean cannot returned get() get() should return list *** if you're unsure why you're getting above error read on. due nature of syntax above problem might occur because: 1. exception *might* occur in wrongly written multi-threaded tests. please refer mockito faq on limitations of concurrency testing. 2. sp
Read more

php - Magento - Deleted Base url key -

-
i working on cleaning url: http://mydomain.com/shop/shop/deals i going through settings in configuration tab in admin panel on magento , change secure , unsecure base urls remove first base url "shop" web page read: http://mydomain.com/shop/deals so changed unsecure base urls mydomain.com/shop mydomain.com , secure 12.345.67.89/shop 12.345.67.89. wrong thing do. i cannot reload page or admin console. how access these files through ftp , change correctly there?? when make changes in admin panel changes made in database not in file. have make changes in database. 1.go database , select core_config_data table under table find web/unsecure/base_url , web/secure/base_url . make changes here. don't forget clear cache in var/cache folder
Read more

android - How to disable Button if EditText is empty ? -

-
i have edittext , button in application. when button clicked,the text entered in edittext added listview. i want disable button if edittext empty.how ? this code button click imagebutton imb=(imagebutton)findviewbyid(r.id.btn_send); imb.setonclicklistener(new onclicklistener() { @override public void onclick(view arg0) { edittext et = (edittext)findviewbyid(r.id.edittext1); string str = et.gettext().tostring(); web1.add(str); toast.maketext(shoutsingleprogram.this, "you entered...."+str, toast.length_short).show(); adapter1.notifydatasetchanged(); et.settext(""); } }); } how can ? edittext1.addtextchangedlistener(new textwatcher() { @override public void ontextchanged(charsequence s, int start, int before, in
Read more