Thanks a lot !! Derek...!!! I will work on this and see if I can get a small
program running.
Derek Hohls wrote:
>
> Siddhu
>
> OK - I downloaded and installed the app on my machine.
>
> The area you need to look at is around line 240 in the sitemap.
>
> If you change to:
>
> <!-- Serialize into format suitable for Excel
> <map:serialize type="excel-serializer"/>-->
>
> <!-- DEBUG: Convert into character stream-->
> <map:serialize type="xml"/>
>
> Then you will what the XML looks like before the serializer
> gets hold of it and creates the XLS (this will be Java code located
> in the directory ....WEB-INF\classes\com\clsw\cocoon).
>
> Basically, it consists of a header element:
> <rpt:template-path>[path]/template.xls</rpt:template-path>
> to tell it where to find the template as well as lots of:
>
> <rpt:add type="java.lang.Double" col="2" row="5">14.59</rpt:add>
> cell entry values.
>
> All of this info is generated from the database in these steps here:
>
> <map:match pattern="report/*.xls">
> <map:generate type="request"/>
> <map:transform type="xslt" src="render-logic.xsl">
> <map:parameter name="label" value="{1}"/>
> </map:transform>
> <map:transform type="xinclude"/>
> <map:transform type="xslt" src="render-logic.xsl"/>
> <map:transform type="sql">
> <map:parameter name="dburl" value="jdbc:mysql://localhost/test"
> />
> </map:transform>
> <map:transform type="xslt" src="render-logic2.xsl">
> <map:parameter name="label" value="{1}"/>
> <map:parameter name="absolute-path"
> value="D:/tomcat/webapps/cocoon-reports"/>
> </map:transform>
>
> and you can omit *all* these stages if you have an existing XML file.
>
> Use something more like:
>
> <map:match pattern="report/*.xls">
> <map:generate src="myDirectory/myData.xml"/>
> <map:transform type="xslt" src="myXML2reportXML.xsl">
>
> You will need to write the XSL to transform from the XML layout you
> have
> into the format needed (as I discussed above).
>
> If you do not know how to write XSL, you will really need to spend time
>
> doing that before you can work with Cocoon - there is an XSLT mailing
> list
> that can help if you get stuck with syntax.
>
> Derek
>
>>>> fast-flux <[EMAIL PROTECTED]> 2007/07/19 11:00 AM >>>
>
>
> Hi Derek,
>
> Thanks for the reply... I went through an article over web
> (http://www.xml.com/lpt/a/1096). Here I see that folks have used
> cocoon-report.war where we provide a schema.xml and Excel template.
> There
> are couple of XSL files (render-logic.xsl, render-logic1.xsl) which
> does
> pull the data from a MySQL database and populate the predefined excel
> template.
>
> I am looking for the same but instead have database as the source I
> needed
> an XML. I am trying to simulate the same functionality which is
> mentioned in
> the article, but I am not able to figure out how the predefined Excel
> template is getting populated.
>
> Any pointers towards this?
>
>
> Thanks,
> Siddhu.
>
>
> Derek Hohls wrote:
>>
>> Siddhu
>>
>> Your use of the word "template" is confusing; XSL files are not
>> templates and, AFAIK, you cannot open and write to an existing
>> Excel file (if that is actually what you are trying to do) using
>> Cocoon
>> as it stands. Perhaps someone else on the list knows how to do
> this?
>>
>>>>> fast-flux <[EMAIL PROTECTED]> 2007/07/19 09:07 AM >>>
>>
>>
>> Hi,
>>
>> I have tried the examples that you guys ask me to try. The problem
> here
>> is,
>> all these explain creating a new XLS sheet and not use existing XLS
>> sheet as
>> a template and generate a response.
>>
>> I am trying to use a existing template and use some kind of mapping
>> from the
>> XML field names to the columns in the template and generate the
> entire
>> xls
>> out.
>>
>> Is there any way to do this?
>>
>> Thanks,
>> Siddhu
>>
>>
>> Derek Hohls wrote:
>>>
>>> Siddhu
>>>
>>> Its not clear what you do know or don't know how to do.
>>>
>>> As a beginner in Cocoon I always found it helpful to look at the
>>> samples shipped with Cocoon and adapt them to aid learning.
>>>
>>> For example, look at the "XLS" example in the "Hello World" group:
>>> http://localhost:8080/cocoon/samples/hello-world/
>>> or under
>>> [path-to-cocoon]\build\webapp\samples\blocks\poi
>>> AND
>>> [path-to-cocoon]\build\webapp\samples\hello-world
>>>
>>> No SQL, just plain XSLT and the POI serializer.
>>>
>>>>>> fast-flux <[EMAIL PROTECTED]> 2007/07/19 08:39:18 AM >>>
>>>
>>>
>>> Hi All,
>>>
>>> I am just beginner in cocoon. I have the following requirements:
>>>
>>> 1. I have input XML file
>>> <Cars>
>>> <Car>
>>> <name>
>>> Ferrari
>>> </name>
>>> <type>
>>> Water
>>> </type>
>>> </Car>
>>> <Car>
>>> <name>
>>> Mercedes
>>> </name>
>>> <type>
>>> Air
>>> </ type>
>>> </Car>
>>> </Cars>
>>>
>>>
>>> 2. I have a Excel template Which already has headers (Car Name &
>
>>> Car
>>> Type)
>>>
>>>
>>> Task for me is to use the XML as a source generater & serilize the
>>> output using the predefined template.
>>>
>>> I would appreciate if you could share any working example of such
>>> type.
>>>
>>> I visited XML.com article ( http://www.xml.com/lpt/a/1096 ) and
> they
>>> have
>>> no examples where we can take the input feed from XML and generate
>> on
>>> a
>>> Template. All example includes SQL and due to some freak problem, I
>> am
>>> still struggling to get the SQL part running.
>>>
>>> Thanks in advance,
>>> -Siddhu
>>> --
>>> View this message in context:
>>>
>>
> http://www.nabble.com/XML-to-Excel-template-examples-Required.-tf4108469.html#a11683207
>
>>
>>>
>>> Sent from the Cocoon - Users mailing list archive at Nabble.com.
>>>
>>>
>>>
>>
> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>>> For additional commands, e-mail: [EMAIL PROTECTED]
>>>
>>>
>>>
>>> --
>>> This message is subject to the CSIR's copyright, terms and
> conditions
>> and
>>> e-mail legal notice. Views expressed herein do not necessarily
>> represent
>>> the
>>> views of the CSIR.
>>>
>>> CSIR E-mail Legal Notice
>>> http://mail.csir.co.za/CSIR_eMail_Legal_Notice.html
>>>
>>> CSIR Copyright, Terms and Conditions
>>> http://mail.csir.co.za/CSIR_Copyright.html
>>>
>>> For electronic copies of the CSIR Copyright, Terms and Conditions
> and
>> the
>>> CSIR
>>> Legal Notice send a blank message with REQUEST LEGAL in the subject
>> line
>>> to
>>> [EMAIL PROTECTED]
>>>
>>>
>>> This message has been scanned for viruses and dangerous content by
>>> MailScanner,
>>> and is believed to be clean.
>>>
>>>
>>>
>>
> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>>> For additional commands, e-mail: [EMAIL PROTECTED]
>>>
>>>
>>>
>>
>> --
>> View this message in context:
>>
> http://www.nabble.com/XML-to-Excel-template-examples-Required.-tf4108469.html#a11683455
>
>>
>> Sent from the Cocoon - Users mailing list archive at Nabble.com.
>>
>>
>>
> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>>
>>
>>
>> --
>> This message is subject to the CSIR's copyright, terms and conditions
> and
>> e-mail legal notice. Views expressed herein do not necessarily
> represent
>> the
>> views of the CSIR.
>>
>> CSIR E-mail Legal Notice
>> http://mail.csir.co.za/CSIR_eMail_Legal_Notice.html
>>
>> CSIR Copyright, Terms and Conditions
>> http://mail.csir.co.za/CSIR_Copyright.html
>>
>> For electronic copies of the CSIR Copyright, Terms and Conditions and
> the
>> CSIR
>> Legal Notice send a blank message with REQUEST LEGAL in the subject
> line
>> to
>> [EMAIL PROTECTED]
>>
>>
>> This message has been scanned for viruses and dangerous content by
>> MailScanner,
>> and is believed to be clean.
>>
>>
>>
> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [EMAIL PROTECTED]
>> For additional commands, e-mail: [EMAIL PROTECTED]
>>
>>
>>
>
> --
> View this message in context:
> http://www.nabble.com/XML-to-Excel-template-examples-Required.-tf4108469.html#a11684855
>
> Sent from the Cocoon - Users mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
> --
> This message is subject to the CSIR's copyright, terms and conditions and
> e-mail legal notice. Views expressed herein do not necessarily represent
> the
> views of the CSIR.
>
> CSIR E-mail Legal Notice
> http://mail.csir.co.za/CSIR_eMail_Legal_Notice.html
>
> CSIR Copyright, Terms and Conditions
> http://mail.csir.co.za/CSIR_Copyright.html
>
> For electronic copies of the CSIR Copyright, Terms and Conditions and the
> CSIR
> Legal Notice send a blank message with REQUEST LEGAL in the subject line
> to
> [EMAIL PROTECTED]
>
>
> This message has been scanned for viruses and dangerous content by
> MailScanner,
> and is believed to be clean.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
--
View this message in context:
http://www.nabble.com/XML-to-Excel-template-examples-Required.-tf4108469.html#a11686835
Sent from the Cocoon - Users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
