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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.