Hi Norman,
Can I suggest a couple of modifications. You could use the fieldstore
function instead of converting to and from VMs. Using fieldstore will
run exponentially faster than the VM conversion method.
Also, if you want to keep the output pretty add the newline.
Eg
Equ NEWLINE to
From: David Jordan
Hi Norm
Have you found any tools to help generate the excel
stylesheets other than manual coding.
Have a look at code sample and documentation for NebulaXLite:
remove.pleaseNebula-RnD.com/products/xlite.htm
I wrote NebulaXLite specifically because people keep asking the
Thanks for the suggestion Stuart.
On 8/9/09, Boydell, Stuart stuart.boyd...@spotless.com.au wrote:
Hi Norman,
Can I suggest a couple of modifications. You could use the fieldstore
function instead of converting to and from VMs. Using fieldstore will
run exponentially faster than the VM
Hi Norm
Have you found any tools to help generate the excel stylesheets other than
manual coding.
Regards
David Jordan
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
List u2-users@listserver.u2ug.org
Subject: Re: [U2] xml mapping file question
Hi Norm
Have you found any tools to help generate the excel stylesheets other than
manual coding.
Regards
David Jordan
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
as creating excel docs from U2, sth I found that works well is the
python xlwt library.
-Original Message-
From: David Jordan da...@dacono.com.au
Sent: Saturday, August 08, 2009 6:43 PM
To: U2 Users List u2-users@listserver.u2ug.org
Subject: Re: [U2] xml mapping file question
Hi Norm
with the thread.
As far as creating excel docs from U2, sth I found that works well is the
python xlwt library.
-Original Message-
From: David Jordan da...@dacono.com.au
Sent: Saturday, August 08, 2009 6:43 PM
To: U2 Users List u2-users@listserver.u2ug.org
Subject: Re: [U2] xml
No direct connection, just csv to native xls on my aix server.
-Original Message-
From: Norman Bauer normanba...@gmail.com
Sent: Saturday, August 08, 2009 8:30 PM
To: U2 Users List u2-users@listserver.u2ug.org
Subject: Re: [U2] xml mapping file question
Wow xlwt is schaweet! Thanks
So here is how I did it.
To recap. I wanted to include the xsl-stylesheet in the xml document
that is produced by XMLExecute(). Below is the code that produced the
desired result.
PROGRAM STDCSTXML
$OPTIONS INFORMATION
$INCLUDE UNIVERSE.INCLUDE XML.H
;* CMD is the
Thank you for posting your solution. I mainly do XML from within a program too.
Date: Fri, 7 Aug 2009 13:36:45 -0400
From: normanba...@gmail.com
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] xml mapping file question
So here is how I did it.
To recap. I wanted to include the xsl
Do you mean something like this?
?xml version=1.0 encoding=ISO-8859-1?
?xml-stylesheet type=text/xsl href=simple.xsl?
The above was borrowed (reprinted w/o permission) from
http://www.w3schools.com/XML/xml_xsl.asp
or do you mean attaching a particular style to a particular element,
That is exactly what I mean Jo.
If I were to do:
SORT VOC TOXML XMLMAPPING some_file.map TO some-xml-file
then in some-xml-file I would expect to see
?xml version=1.0 encoding=ISO-8859-1?
?xml-stylesheet type=text/xsl href=simple.xsl?
ROOT
yada yada yada
/ROOT
On Wed, Aug 5, 2009 at
.pdf
I haven't tried it myself yet, sorry.
Date: Wed, 5 Aug 2009 16:15:50 -0400
From: normanba...@gmail.com
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] xml mapping file question
That is exactly what I mean Jo.
If I were to do:
SORT VOC TOXML XMLMAPPING some_file.map
13 matches
Mail list logo