Re: writing excel files with merge and coloured cells
In reply to: http://marc.theaimsgroup.com/?l=xml-cocoon-usersm=104725042020751w=2 Although gnumeric xml allows any colour to be specified, excel only has a 56 colour palette. This page shows excel's default palette (some details depend on the version): http://www.mvps.org/dmcritchie/excel/colors.htm If you choose a colour that isn't in the palette I think you get white. All the colours I've tried from this palette have worked except no. 45: #FF9900. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: writing excel files with merge and coloured cells
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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
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]
writing excel files with merge and coloured cells
Title: 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.