<div dir="ltr">Create Gnumeric file and ask the converter to convert to excel afterwards.<div class="gmail_extra"><br><br><div class="gmail_quote">On Sat, Feb 1, 2014 at 10:30 AM, Johan Brichau <span dir="ltr"><<a href="mailto:johan@inceptive.be" target="_blank">johan@inceptive.be</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word">Hi there,<div><br></div><div>Another option is to serve a plain html table from your web app and use Excel webqueries [1] to pull in the data from Excell. You can serve a (static) excel file with the webquery embedded and have it pull in the data rather than trying to generate an excel yourself.</div>
<div><br></div><div>We also had the best results generating spreadsheetML (which is the solution Tobias proposes).</div><div><br></div><div>If you serve csv, be aware that excell does not treat this very well on all platforms. We tried all that a couple of years ago and finally found that only a CSV in UTF16 format which uses tabs as separator (not commas) is read by excell on all platforms [2,3]</div>
<div><br></div><div>Also, the trick to just put the extension ‘xls’ to a csv file only works if the mime type was defined on the client computer. It does not work everywhere and can break at any time.</div><div><br></div>
<div>cheers,</div><div>Johan</div><div><br></div><div>[1] <a href="http://office.microsoft.com/en-us/excel-help/get-and-analyze-data-from-the-web-in-excel-HA001054848.aspx" target="_blank">http://office.microsoft.com/en-us/excel-help/get-and-analyze-data-from-the-web-in-excel-HA001054848.aspx</a></div>
<div>[2] <a href="http://blog.plataformatec.com.br/2009/09/exporting-data-to-csv-and-excel-in-your-rails-app/" target="_blank">http://blog.plataformatec.com.br/2009/09/exporting-data-to-csv-and-excel-in-your-rails-app/</a></div>
<div>[3] <a href="http://stackoverflow.com/questions/6588068/which-encoding-opens-csv-files-correctly-with-excel-on-both-mac-and-windows" target="_blank">http://stackoverflow.com/questions/6588068/which-encoding-opens-csv-files-correctly-with-excel-on-both-mac-and-windows</a></div>
<div><div><br><div><blockquote type="cite"><div style="font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<blockquote type="cite">On <a href="tel:31.01.2014" value="+37031012014" target="_blank">31.01.2014</a>, at 16:10, Esteban A. Maringolo <<a href="mailto:emaringolo@gmail.com" target="_blank">emaringolo@gmail.com</a>> wrote:<br>
<br><blockquote type="cite">I need to download the contents of a html table generated with Seaside as a file (actually the whole contents if the table is paginated).<br><br>I wonder if somebody already implemented the feature to generate an Excel file programatically?<br>
<br>I'm using CSV files, but the customer prefers Excel (it can be XLSX).<br><br>Any thoughts? Command line converters? (linux)<br></blockquote></blockquote></div></blockquote></div><br></div></div></div><br>_______________________________________________<br>
seaside mailing list<br>
<a href="mailto:seaside@lists.squeakfoundation.org" target="_blank">seaside@lists.squeakfoundation.org</a><br>
<a href="http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside" target="_blank">http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside</a><br>
<br></blockquote></div><br></div></div>