> That is what I have been providing for them. It makes no difference > whether the file is banana.txt or banana.csv, it will be opened > properly by Excel.
As much as I dislike dealing with XML in general, the XML suggestion is probably the best one so far. That would let you generate both data and formatting in one pass, and it should Just Work for J Random Luser. Create the sheet the way you want it to look once in Excel, and then Save, open with a text editor, and chop out the data bits. Also would work beautifully for OpenOffice; the structure should be pretty similar. I wish someone would port Xerces to CMS. Then we'd have a standard XML library to work with, and writing a pipe stage to generate stuff would be easy. -- db
