cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew C. Oliver" <acoli...@apache.org>
Subject Re: AW: writing excel files with merge and coloured cells
Date Sun, 09 Mar 2003 22:54:11 GMT
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


Mime
View raw message