You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by "Rapcewicz, Chris" <ra...@measurisk.com> on 2003/03/06 21:28:20 UTC
writing excel files with merge and coloured cells
Hi,
I am currently running Cocoon 2.0.4 on Tomcat 4.1 and I am interested in
creating excel files which have coloured cells and also cells that are
merged. I tried generating an xml from gnumeric and using this, but found
that neither the coloured cells nor the merged cells were present.
Before I start trying to debug, I was wondering if this functionality is
supported?
Thanks,
Chris.
Re: writing excel files with merge and coloured cells
Posted by "Andrew C. Oliver" <ac...@apache.org>.
Yes the colors work. I do not think I ever implemented merged cells at
the serializer level.
-Andy
Rapcewicz, Chris wrote:
> Hi,
>
> I am currently running Cocoon 2.0.4 on Tomcat 4.1 and I am interested
> in creating excel files which have coloured cells and also cells that
> are merged. I tried generating an xml from gnumeric and using this,
> but found that neither the coloured cells nor the merged cells were
> present.
>
> Before I start trying to debug, I was wondering if this functionality
> is supported?
>
> Thanks,
> Chris.
>
>------------------------------------------------------------------------
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
>For additional commands, e-mail: cocoon-users-help@xml.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org
Re: AW: writing excel files with merge and coloured cells
Posted by "Andrew C. Oliver" <ac...@apache.org>.
Thats single threaded btw. See what happens if a few people hit it at once.
Gerald Michalitz wrote:
> I am using the bsf (bean scripting framework) in with I use vb and
> object rexx to create excel and use existing excel files
>
> with this you can use ole objects like excel to work with
>
> a little sample code:
>
> xml-file
>
>
> <?xml version="1.0"?>
>
> <!DOCTYPE page [
>
> <!ELEMENT page (title?, content)>
>
> <!ELEMENT title (#PCDATA)>
>
> <!ELEMENT content (para+, konto)>
>
> <!ELEMENT para (#PCDATA)>
>
> <!ELEMENT account (#PCDATA)>
>
> <!ATTLIST account
>
> number CDATA #REQUIRED
>
>>
>
> ]>
>
> <?xml-stylesheet type="text/xsl""?>
>
> <page>
>
> <title>XSL-Transformation of a XML-file to a HTML-file or to a
> PDF-file</title>
>
> <content>
>
> <para>This is an example:</para>
>
> <account number="270000"/>
>
> </content>
>
> </page>
>
>
>
> xls file
>
>
> <!--The component and its script are in the lxslt namespace and define
> the
>
> implementation of the extension.-->
>
> <lxslt:component prefix="my-ext" functions="something">
>
> <lxslt:script lang="rexx">
>
> <![CDATA[
>
> /* something rexx - [Object] Rexx, ---gm, 2003-03-06, pitten - austria*/
>
> My_Excel = .OLEObject~New("Excel.Application")
>
> infile = "e:\allesmist\dvoexport.xls"
>
> My_Excel~WorkBooks~Open(infile)
>
> row = 1
>
> column = 'B'
>
> number = My_Excel~Cells(row,column)~Value
>
> return "The amount is=" number
>
> My_Excel~WorkBooks~Close
>
> ::requires "OREXXOLE.CLS"
>
> ]]>
>
> </lxslt:script>
>
> </lxslt:component>
>
> <xsl:template match="account">
>
> <xsl:value-of select="my-ext:something(string(@account))"/>
> </xsl:template>
>
> </xsl:stylesheet>
>
>
>
>
>
> with object rexx or vb or js you can do all what excel/word can do
>
>
>
>
>
> gerald
>
>
>
> -----Ursprüngliche Nachricht-----
> *Von:* Rapcewicz, Chris [mailto:rapture@measurisk.com]
> *Gesendet:* Donnerstag, 6. März 2003 21:28
> *An:* 'cocoon-users@xml.apache.org'
> *Betreff:* writing excel files with merge and coloured cells
>
> Hi,
>
> I am currently running Cocoon 2.0.4 on Tomcat 4.1 and I am
> interested in creating excel files which have coloured cells and
> also cells that are merged. I tried generating an xml from
> gnumeric and using this, but found that neither the coloured cells
> nor the merged cells were present.
>
> Before I start trying to debug, I was wondering if this
> functionality is supported?
>
> Thanks,
> Chris.
>
---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org
AW: writing excel files with merge and coloured cells
Posted by Gerald Michalitz <ge...@aon.at>.
writing excel files with merge and coloured cellsI am using the bsf (bean
scripting framework) in with I use vb and object rexx to create excel and
use existing excel files
with this you can use ole objects like excel to work with
a little sample code:
xml-file
<?xml version="1.0"?>
<!DOCTYPE page [
<!ELEMENT page (title?, content)>
<!ELEMENT title (#PCDATA)>
<!ELEMENT content (para+, konto)>
<!ELEMENT para (#PCDATA)>
<!ELEMENT account (#PCDATA)>
<!ATTLIST account
number CDATA #REQUIRED
>
]>
<?xml-stylesheet type="text/xsl""?>
<page>
<title>XSL-Transformation of a XML-file to a HTML-file or to a
PDF-file</title>
<content>
<para>This is an example:</para>
<account number="270000"/>
</content>
</page>
xls file
<!--The component and its script are in the lxslt namespace and define the
implementation of the extension.-->
<lxslt:component prefix="my-ext" functions="something">
<lxslt:script lang="rexx">
<![CDATA[
/* something rexx - [Object] Rexx, ---gm, 2003-03-06, pitten - austria*/
My_Excel = .OLEObject~New("Excel.Application")
infile = "e:\allesmist\dvoexport.xls"
My_Excel~WorkBooks~Open(infile)
row = 1
column = 'B'
number = My_Excel~Cells(row,column)~Value
return "The amount is=" number
My_Excel~WorkBooks~Close
::requires "OREXXOLE.CLS"
]]>
</lxslt:script>
</lxslt:component>
<xsl:template match="account">
<xsl:value-of select="my-ext:something(string(@account))"/> </xsl:template>
</xsl:stylesheet>
with object rexx or vb or js you can do all what excel/word can do
gerald
-----Ursprungliche Nachricht-----
Von: Rapcewicz, Chris [mailto:rapture@measurisk.com]
Gesendet: Donnerstag, 6. Marz 2003 21:28
An: 'cocoon-users@xml.apache.org'
Betreff: writing excel files with merge and coloured cells
Hi,
I am currently running Cocoon 2.0.4 on Tomcat 4.1 and I am interested in
creating excel files which have coloured cells and also cells that are
merged. I tried generating an xml from gnumeric and using this, but found
that neither the coloured cells nor the merged cells were present.
Before I start trying to debug, I was wondering if this functionality is
supported?
Thanks,
Chris.