Re: AW: writing excel files with merge and coloured cells

Andrew C. Oliver Sun, 09 Mar 2003 14:52:57 -0800

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



<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.


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: AW: writing excel files with merge and coloured cells

Reply via email to