[Seaside] Generate Excel documents from Seaside (Pharo)

Vaidotas Didžbalis vaidasd at gmail.com
Sat Feb 1 20:36:09 UTC 2014

Create Gnumeric file and ask the converter to convert to excel afterwards.

On Sat, Feb 1, 2014 at 10:30 AM, Johan Brichau <johan at inceptive.be> wrote:

> Hi there,
> 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.
> We also had the best results generating spreadsheetML (which is the
> solution Tobias proposes).
> 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]
> 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.
> cheers,
> Johan
> [1]
> http://office.microsoft.com/en-us/excel-help/get-and-analyze-data-from-the-web-in-excel-HA001054848.aspx
> [2]
> http://blog.plataformatec.com.br/2009/09/exporting-data-to-csv-and-excel-in-your-rails-app/
> [3]
> http://stackoverflow.com/questions/6588068/which-encoding-opens-csv-files-correctly-with-excel-on-both-mac-and-windows
> On 31.01.2014, at 16:10, Esteban A. Maringolo <emaringolo at gmail.com>
> wrote:
> 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).
> I wonder if somebody already implemented the feature to generate an Excel
> file programatically?
> I'm using CSV files, but the customer prefers Excel (it can be XLSX).
> Any thoughts? Command line converters? (linux)
> _______________________________________________
> seaside mailing list
> seaside at lists.squeakfoundation.org
> http://lists.squeakfoundation.org/cgi-bin/mailman/listinfo/seaside
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/seaside/attachments/20140201/520adad9/attachment.htm

More information about the seaside mailing list