ruby on rails - Railscasts Episode #362 - Exporting to Excel: How to avoid the warning message given by Excel 2010 when opening the file? -

-

when using example app ryan bates' railscasts episode #362 exporting excel (https://github.com/railscasts/362-exporting-csv-and-excel), i've noticed excel 2010 (which on windows) gives me warning message when opening .xls file i've downloaded using "download excel" link.

the warning reads:

"the file trying open ... in different format specified file extension. verify file not corrupted , trusted source before opening file. want open file now?"

i can open file fine when click 'yes.' , don't warning message when using excel 2011 (on mac). i'd able provide excel file won't prompt warning when user downloads such file site.

note: i've tried replacing references in app .xls .xlsx, excel can't open file @ all. complains: "excel cannot open file. file format or file extension not valid. verify file has not been corrupted , file extension matches format of file."

i aware of gems such axlsx (https://github.com/randym/axlsx), hoping use railscasts method , make quick fix eliminate warning message excel 2010.

thank help!

the xls file generated railscasts application xml file in old excel 2003 xml format.

recent versions of excel have feature called extension hardening generate warning when file format doesn't match file extension:

the alert new security feature in excel 2007 called extension hardening, ensures file content being opened matches extension type specified in shell command attempting open file. because mime types listed above associated .xls extension, file must in xls (biff8) file format open without warning prompt.

in order avoid warning have generate excel file in format matches file extension. editing registry suggested workaround in above link isn't workable in practice. changing extension xml might work.

as alternatives writeexcel xls, write_xlsx xlsx , axlsx (that mention above) options.


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