Re: Excel format

[Louis . Masters]

Craig:

I did not run into this issue.  However, I am running some tests now to make sure it wan not overlooked.

-Lou


Craig McDaniel <[EMAIL PROTECTED]> wrote on 12/07/2005 08:47:28:

> 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]
>