Home ::About InfoWorld :: Advertise :: Subscribe :: Contact Us :: Awards
InfoWorldHomeNewsTest CenterOpinionsTechIndex
 SUBSCRIBE  E-MAIL NEWSLETTERS  WEBCASTS  SPECIAL REPORTS  RSS FEEDS
powered by Google  
 


Top 10 hits for "everything old is new again" on..
Google
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.

Help link
 10/3/2005; 9:30:54 AM.

Strategic Developer
wedgeUnsung heroes of open source
wedgeManagement by objects
wedgeThe network is the blog
wedgeThe semantic web, digital identity, and Internet governance
wedgeTales from the data-entry trenches
wedgeWhatever happened to SVG?
wedgeSpeech recognition circa 2004
wedgeCan rich Internet apps be web-friendly?
wedgeIntroduction to MSH
wedgeUnder Gmail's hood
wedgeThe Wiki way
wedgeComputer telephony: why wait?
wedgeMaking old technologies new
wedgeFrom access control to accountability
wedgeDoing the impossible
wedgeThe TiVo Olympics
wedgeCollaborative knowledge gardening
wedgeThe architecture of participation
wedgeA strategic vision for dynamic languages
wedgeTragedy of the network commons
wedgeFederating identity the Shibboleth way
wedgeWeb standards on the move
wedgeThe Google PC
wedgeThin client, rich data
wedgeOptical illusions
wedgeThe artful logger
wedgePush me, pull you
wedgeGoogle's supercomputer
wedgeAttack of the killer accountants
wedgeJack of all trades
wedgeProxy power
wedgeScribbling in the margins
wedgeHuman interface guidelines for the Internet
wedgeMaking email identity work

CxO bloggers
wedgeAdam Bosworth, BEA Google
wedgeChad Dickerson, InfoWorld
wedgeClemens Vasters, newtelligence AG
wedgeDave Winer, UserLand Harvard
wedgeEdwin Khodabakchian, Collaxa
wedgeEugene Belyaev, JetBrains
wedgeGraham Glass, The Mind Electric webMethods
wedgeJamie Lewis, The Burton Group
wedgeJeremy Allaire, Macromedia General Catalyst Partners
wedgeJohn McDowall, Grand Central Communications
wedgeJonathan Schwartz, Sun Microsystems
wedgeJorgen Thelin, Cape Clear Software Microsoft
wedgeKingsley Idehen, OpenLink Software
wedgeMark O'Neill, Vordel
wedgeMike Cannon-Brooks, Atlassian
wedgeOmar Javaid, Wireless Knowledge
wedgePaul Brown, FiveSight
wedgePaul Everitt, Zope Corporation Zope Europe
wedgePhil Libin, CoreStreet Technologies
wedgePhil Windley, State of Utah
wedgeRay Ozzie, Groove
wedgeRoss Mayfield, Socialtext
wedgeSean McGrath, Propylon
wedgeTim Bray, Antarctica Systems Sun
wedgeTim O'Reilly, O'Reilly and Associates

BLOG MENU
 

xpath search: this blog

screencasts

podcasts

blog home

blog index

infoworld home

library lookup

send Jon an email: Click here to send an email to the editor of this weblog.
 

 
 
 
Jon Udell's Weblog

  Friday, September 09, 2005 

An XML spreadsheet parable

Amidst the controversy over XML formats for office documents, it's important not to lose sight of the fundamental benefits that accrue simply from using XML. Michael Tiller has a nice ancedote that drives home the point. Here's the setup: a small engineering firm, Excel expense reports, each must be dispensed on demand to an employee and coded with a unique number. And here's what Michael did:

I took the Excel spreadsheet she gave me (in .xls format) and wrote it out in Microsoft's new Excel XML format. Then I uploaded it to the Zope server and turned that XML into a Page Template. Then, I could apply any TAL transformation I wanted to it.

Very cool.

So, I created a very simple Gadfly database that keeps track of expense report requests so that each one would get a unique ID and then I wrote a tiny Python script to generate the unique ID based on the state information in the database. Once all this was in place, I just added a very simple set of TAL directives to the original template and viola...each request generates a unique Excel document. [Michael Tiller: XML, web services, and business processes]

TAL is the Zope Template Attribute Language. It's used by Zope-based content management systems, like Plone, to enable XML or XHTML documents to function as CMS templates. The output of a transformed template is, of course, normally a web page. Here it's a spreadsheet. Michael notes that downlevel Excel clients can't read it but, when Office 12 makes XML the default format, this downlevel support should appear for pre-Office 2003 versions.

The Plone scenario is, of course, just one of a million different ways to skin this particular cat. And that's a huge win regardless of how the format tussle plays out.

What I like about this tiny example is that it's representative of how spreadsheets are mostly used in the real world -- to do simple things, like add columns in expense reports. Whether or not Microsoft decides to officially support the OpenDocument format, it's hard for me to imagine that transformations between it and Excel's SpreadsheetML -- for all the basic functionality, at least -- won't be trivial and ubiquitous.

Granted, I've internalized the idea of XML transformation to the point where I tend to regard two formats related by a transformation as, effectively, the same thing. But that's precisely the point. It's just data. Exposing it as XML matters more than how exactly we do that.

 




 HOME  NEWS  TEST CENTER  OPINIONS  TECHINDEX   About InfoWorld :: Advertise :: Subscribe :: Contact Us :: Awards :: Events 

Copyright © 2004, Reprints, Permissions, Licensing