On 12/7/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > We currently do this in our production system using SpreadsheetML and HTML. > We use SpreadsheetML for newer versions of Excel and HTML with some > proprietary MS XML for Excel for Win2K or lower. > > The process is as follows: > > 1. Generate your XML data file and parse it using the parser of your choice > (i.e. Xerces). > 2. Use a transformer and a stylesheet you create to convert your XML into > one of the aforementioned spreadsheet formats. We use Xalan for this part. > The stylesheet was pretty simple to put together. > > FOP is not needed for this. I put the entire thing together in about two > days so it isn't a big deal. However, there are some "gotchas" between the > two formats that will drive you crazy so be careful.
Would one of those "gotchas" be that the Excel XML format skips empty cells? -- Craig McDaniel --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
