asp.net - Export Excel from grid not working on Ajax Model PopUp -

-

hi trying export grid data excel not working in ie8.i using ajax modal popup dialog box containing 2 buttons 'ok' , 'close'.on ok click want download excel file.it works fine in mozilla in ie not working.i using below code. please suggest me how that?also when open file first show warning before opening file how handle that?

  response.clear();     response.buffer = true;      string filename = "checkout";      response.charset = "";     response.contenttype = "application/vnd.ms-excel";     response.addheader("content-disposition", "attachment; filename=" + filename + ".adt");      response.write("<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\">");     response.write("<head>");     response.write("<meta http-equiv=\"content-type\" content=\"text/html; charset=utf-8\">");     response.write("<!--[if gte mso 9]><xml>");     response.write("<x:excelworkbook>");     response.write("<x:excelworksheets>");     response.write("<x:excelworksheet>");     response.write("<x:name>sheet1</x:name>");     response.write("<x:worksheetoptions>");     response.write("<x:print>");     response.write("<x:validprinterinfo/>");     response.write("</x:print>");     response.write("</x:worksheetoptions>");     response.write("</x:excelworksheet>");     response.write("</x:excelworksheets>");     response.write("</x:excelworkbook>");     response.write("</xml>");     response.write("<![endif]--> ");     response.write("</head>");      stringwriter sw = new stringwriter();     htmltextwriter hw = new htmltextwriter(sw);     gridview gv = new gridview();     gv.autogeneratecolumns = true;     gv.datasource = dt;     gv.databind();     gv.rendercontrol(hw);      response.output.write(sw.tostring());     response.flush();     response.end();

you warning because tehnically speaking not export excel, send html wrong headers trick browser open content excel.

better use native excel library , generate real excel file on server, example epplus, it's open source , doesn't require excel on server.

here example of ashx handler generates excel file datatable

https://stackoverflow.com/a/9569827/351383


Comments

Post a Comment

Popular posts from this blog

c++ - Creating new partition disk winapi -

-
i'am trying create new partition , mount volume new, thought createfile let me this, code : lpctstr lpfilename=l"\\\\.\\device\\harddisk0\\partition3"; handle handl=createfile( lpfilename, generic_read | generic_write, file_share_read | file_share_write, null, create_always, file_attribute_normal, null ); if (handl==invalid_handle_value) { qdebug()<<"handl invalid"<<" error"<<getlasterror();} bool success = definedosdevice(ddd_raw_target_path,l"i:",l"\\device\\harddisk0\\partition3"); if(!success) qdebug()<<" definedosdevice failed "<<getlasterror(); bflag = getvolumenameforvolumemountpoint( l"i:\\", // input volume mount point or directory /** u in dir
Read more

Android Prevent Bluetooth Pairing Dialog -

-
i'm developing internal application uses bluetooth printing. want bluetooth pairing occur without user input. have managed working trapping android.bluetooth.device.action.pairing_request broadcast. in broadcast receiver call setpin method, , pairing works ok, bluetoothpairingdialog displayed second or two, disappears - see link below. https://github.com/android/platform_packages_apps_settings/blob/master/src/com/android/settings/bluetooth/bluetoothpairingdialog.java since broadcast non-ordered, can't call abortbroadcast() , , wondering if there other way prevent pairing dialog appearing. can hook window manager in way? i haven't been able come way without modifying sdk. if you're oem, it's easy (i'm on 4.3): in packages/apps/settings/androidmanifest.xml, comment intent filter pairing dialog: <activity android:name=".bluetooth.bluetoothpairingdialog" android:label="@string/bluetooth_pairing_request"
Read more

VBA function to include CDATA -

-
i have following function include cdata: function cdatasection() dim objdom domdocument dim objkmlrootelement ikmldomelement dim objkmlelement ikmldomelement dim cdata ikmldomcdatasection set objdom = new domdocument set objkmlrootelement = objdom.createelement("balloonstyle") objdom.appendchild objkmlrootelement set objkmlelement = objdom.createelement("text") objkmlrootelement.appendchild objkmlelement set cdata = objdom.createcdatasection("text") cdata.data = "<![cdata[<b>latitude = $[latitude]</b>?]]>;" end function when run above, getting error "user defined data type not found" function. yes ripster says find library reference. vba window tools>references for list of relevant references see... http://msdn.microsoft.com/en-us/library/windows/desktop/ms763701%28v=vs.85%29.aspx however, if have hard time tracking down reference, replace dim sta
Read more