Re: AW: writing excel files with merge and coloured cells
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 titleXSL-Transformation of a XML-file to a HTML-file or to a PDF-file/title content paraThis is an example:/para account number=27/ /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. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
AW: writing excel files with merge and coloured cells
Title: writing excel files with merge and coloured cells
I am
using the bsf (bean scripting framework) in withI 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)
!ATTLISTaccount
number CDATA
#REQUIRED
]
?xml-stylesheet type="text/xsl""?
page
titleXSL-Transformation of a
XML-file to a HTML-file or to a PDF-file/title
content
paraThis is an example:/para
account number="27"/
/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
-Ursprngliche Nachricht-Von: Rapcewicz, Chris
[mailto:[EMAIL PROTECTED]Gesendet: Donnerstag, 6. Mrz 2003
21:28An: '[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.
