52

image Publish a Spreadsheet SYLK File

Running systems-monitoring processes and needing to generate reports means that at some stage you might have to produce an Excel spreadsheet. Excel worksheet files are a completely opaque binary format. We need a textual version.

Now, we could do that with XML, but there are alternatives to the obvious solutions. Older technology solutions might deliver what you need with less complexity and a smaller performance impact on your servers. There is an old format left over from the days when Microsoft shipped a spreadsheet called Multiplan. Fortunately, Excel can still read and write these old-style SYLK files. They ...

Get Developing Quality Metadata now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.