Edukira salto egin | Salto egin nabigazioara

Tresna pertsonalak

Eibarko peoria, San Blasa baino hobia
Hemen zaude: Hasiera / Blogak / Ingelesen hilerria / The English Cemetery / Creating Excel files from Zope, and preserving formulas

Creating Excel files from Zope, and preserving formulas

Luistxo Fernandez 2005/09/16 18:05

Some days ago, Jon Udell, a well-known tech guru, posted an article about Excel spreadsheets that might be generated dynamically with Zope. His point was that the next generation of MS Office products, with XML capabilities, will be a great advance as it will be possible to generate spreadsheets or other documents, generating XML output out of web applications.

Well, my coleague engineers at CodeSyntax (mainly Gari and Jatsu) opened their eyes... Of course Udell is right, but spreadsheet generation can be achieved (in the case of Excel) even without XML, since Excel deals with HTML tables to directly convert them as spreadsheets. You don't need to wait for that new Office version. We already do it a long time ago with Zope, learned from here, and use this in several projects,

You just need to export from Excel to HTML, and then upload it to Zope as ZPT or DTML and insert the required ZPT or DTML sentences.

So, Gari pointed this to Jon Udell, and, well, the guru was intrigued, particularly if this method did preserve formulas in the Excel files generated... The answer is yes. Here, a little demo to demonstrate it.

I post this at my blog 'cause these friends of mine don't blog in English. Gari and Jatsu were also excited that a tech-guru exchanges info with them, just around the same time that he interviews Bill Gates.

Iruzkina gehitu

Erantzuna formulario hau betez utzi dezakezu. Formatua testu arruntarena da. Web eta e-posta helbideak automatikoki klikagarri agertuko dira.

Galdera: Zenbat dira hogei ken bi? (idatzi zenbakiz)

Luistxo works in CodeSyntax, tweets as @Luistxo and tries to manage the automated newssite Niagarank. This Cemetery is part of a distributed multilingual blog (?!). These are the Basque and Spanish versions:

Ingelesen hilerria

El cementerio de los ingleses


Subscribe to the Cemetery: RSS entries / RSS comments | By email.

My cultural consumption in English: 2012/13 | Television | Movies | Books

Creative Commons by-sa