AW: writing excel files with merge and coloured cells

[Gerald Michalitz]

Title: writing excel files with merge and coloured cells

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:[EMAIL PROTECTED]
Gesendet: Donnerstag, 6. März 2003 21:28
An: '[EMAIL PROTECTED]'
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.