javascript - Export html to Excel : when try to open file it gives prompt like file is corrupted -

-

i exporting html table excel using javascript code on browser. done when try open file in microsoft excel gives prompt :

"excel cannot open file 'filename.xlsx' because file format file extension not valid. verify file has not been corrupted , file extension matches format of file.do want open file now?"

if press yes works fine , data gets displayed in excel.

i want remove prompt.

my javascript code 

function fnexcelreport() { var tab_text="<table border='2px'><tr bgcolor='#87afc6'>"; var textrange; var j=0; tab = document.getelementbyid('headertable'); // id of table  for(j = 0 ; j < tab.rows.length ; j++)  {          tab_text=tab_text+tab.rows[j].innerhtml+"</tr>";     //tab_text=tab_text+"</tr>"; }  tab_text=tab_text+"</table>"; tab_text= tab_text.replace(/<a[^>]*>|<\/a>/g, "");//remove if u want links in table tab_text= tab_text.replace(/<img[^>]*>/gi,""); // remove if u want images in table tab_text= tab_text.replace(/<input[^>]*>|<\/input>/gi, ""); // reomves input params  var ua = window.navigator.useragent; var msie = ua.indexof("msie ");   if (msie > 0 || !!navigator.useragent.match(/trident.*rv\:11\./))      // if internet explorer {     txtarea1.document.open("txt/html","replace");     txtarea1.document.write(tab_text);     txtarea1.document.close();     txtarea1.focus();      sa=txtarea1.document.execcommand("saveas",true,"data.xls"); }    else{}                  var = document.createelement('a');     a.href = 'data:application/vnd.ms-excel,' +  encodeuricomponent(tab_text);     a.download = 'rxe_data' + '.xls';     a.click(); }

in end seems isn't possible bypass alert. if convert html code excel data open in excel, implemented server side code generate pure excel , return client instead of html data.


Comments

Post a Comment

Popular posts from this blog

qt - Using float or double for own QML classes -

-
i've created components , helper methods using c++ , qt used in qml gui. of methods calculate gui elements (size, transformations, scene graph items creation). target arm 32 bit using opengl / eglfs render output. opengl using float , qml using real (defined double ). what should use in c++ do not lose precision? if use qreal ( double ) shouldn't lose precision. if git grep float in qtbase.git , can find out bit more: dist/changes-5.2.0-**************************************************************************** dist/changes-5.2.0-* important behavior changes * dist/changes-5.2.0-**************************************************************************** dist/changes-5.2.0- dist/changes-5.2.0- - qt compiled qreal typedef'ed double on dist/changes-5.2.0: platforms. qreal float on arm chipsets before. guarantees more dist/changes-5.2.0- consistent behavior between platforms qt supports, binary dist/chan...
Read more

Create Outlook appointment via C# .Net -

-
i need create outlook appointment using microsoft.office.interop.outlook , while can work locally on own workstation , works if run web application via server's browser, not work when connect server externally. hence, think might permission issue. i changed application pool identity " localsystem " don't access denied error. unfortunately, doesn't work. the app behaves if appointment created, appointment doesn't appear in outlook. here include file on top of aspx.cs page using outlook = microsoft.office.interop.outlook; here code using pop appointment. outlook.application apptapp = new outlook.application(); outlook.appointmentitem appt = apptapp.createitem(outlook.olitemtype.olappointmentitem) outlook.appointmentitem; appt.subject = txtfirstname.text + " " + txtlastname.text; appt.body = txtcomment.text; appt.alldayevent = false; appt.start = datetime.parse(txtreminderdate.text + " 8:00 am"); appt.end = datetime.p...
Read more

ios - Swift Array Resetting Itself -

-
i have 2 arrays: pointhistory , datehistory . have nstimer , , when timer runs out, action called. in action appending int pointhistory , , current date string datehistory . here timer action: func timeraction() { let steppervalue = int(stepper.value) employee.numberofpoints = steppervalue networking.saveemployee(employee, completion: { (error) -> void in if error != nil { let alert = uialertcontroller(title: "error", message: "there error updating \(self.employee.name)'s points", preferredstyle: .alert) let alertaction = uialertaction(title: "ok", style: .cancel, handler: nil) alert.addaction(alertaction) self.presentviewcontroller(alert, animated: true, completion: nil) } }) var dateformatter = nsdateformatter() dateformatter.dateformat = "mm-dd-yyyy" dateformatter.timezone = nstimezone.localtimezone() var date = nsdate() var ...
Read more