It seems that this is a most clear way for
me. Unfortunately, I’m not so familiar with some concepts that you said. Do
you know any document that a little more explain about this way & SpreadsheetML, transformer.
Thanks
Farid
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 07, 2005
6:56 AM
To:
fop-users@xmlgraphics.apache.org
Subject: Re: Excel format
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.
-Lou
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
LOG-NET, Inc.
The Logistics Network Management System
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
230 Half Mile Road
Third Floor
Red Bank, NJ 07701
PH: 732-758-6800
FAX: 732-747-7497
http://www.LOG-NET.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
CONFIDENTIAL & PRIVILEGED
Unless otherwise indicated or if obvious from the nature of the content, the
information contained herein is privileged and confidential information/work
product. The communication is intended for the use of the individual or entity
named above. If the reader of this transmission is not the intended
recipient, you are hereby notified that any dissemination, distribution
or copying of this communication is strictly prohibited. If you have
received this communication in error, please notify the sender immediately by
telephone (732-758-6800) or by electronic mail ([EMAIL PROTECTED]), and
destroy any copies, electronic, paper or otherwise, which you may have of this
communication. Thank you.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"Farid
Adhami" <[EMAIL PROTECTED]> wrote on 12/06/2005 18:56:42:
> I’m trying to use FOP as report engine.
But I have to provide excel
> format for the report.
>
> I
didn’t find any information showing that FOP provides Excel output
> or anyway that could be used for this
purpose.
>
> Thanks
for any help, in advance.
> Farid
>
>
