RE: : XML -> MS Word??
A little late but I'm sure this will end it anyway. Everything you need to know is the schemas microsoft is using (for Word, Excel, etc.) Go to http://msdn.microfost.com/library then navigate as follows on the left tree structure: > Office Solutions Development >> Microsoft Office >>> Microsoft Office 2000 >>>> Microsoft Office HTML and XML Reference Even if it is outside of the scope of FOP, still it is a kind "market" competitor. I always have the same "deliver-me-in-excel" request, specially from upper management. -Original Message- From: Bart Locanthi [mailto:[EMAIL PROTECTED] Sent: Monday, March 04, 2002 10:37 AM To: [EMAIL PROTECTED] Subject: Re: : XML -> MS Word?? exactly how ghastly are you talking here? is the format [snort] published anywhere? Michiel Verhoef wrote: > To top all: it is even quite simple. > For a project we had to produce MS Excel files fromXML, using XSLT. > As we didn't have a clue about Microsoft formats etc we figured: why > not produce this ghastly MS-HTML and see what that does for us?
RE: : XML -> MS Word??
It would be. However, we had to present the data that we presented in an HTML table in an instant in Excel and this was the easiest way to make sure that the customer did not have to perform any action in Excel to view the data (so no imports/formatting necessary). Apart from that, the whole thing was meant as an extra feature in an HTML reporting system. But I agree: this is totally off topic for this list. $ -Original Message- $ From: Nicola Ken Barozzi [mailto:[EMAIL PROTECTED] $ Sent: maandag 4 maart 2002 18:47 $ To: [EMAIL PROTECTED] $ Subject: Re: : XML -> MS Word?? $ $ $ From: "Carlos Araya" <[EMAIL PROTECTED]> $ $ > Michiel: $ > $ > Wouldn't it be easier to translate the xml to a CSV (comma separated $ value) $ > file, import that into Excel and then finish up the $ formating? I wouldn't $ > even bother trying the MS_HTML option $ $ See http://jakarta.apache.org/poi/ . $ Pure java classes that write to Office formats. $ Excel reader-writer is tried and tested. $ $ -- $ Nicola Ken Barozzi [EMAIL PROTECTED] $ - verba volant, scripta manent - $(discussions get forgotten, just code remains) $ - $
Re: : XML -> MS Word??
Man, this is totally off of the FOP subject but, Yes, you can create a pivot table (almost - You create an outline) in text with XSL. You have to understand how excel auto-converts properly sub-totalled rows to an outline and then to a pivot table. Walk through it a couple of times in Excel to see what';s going on 1. Figure out the output line by line 2. Figure out the fields that will be subtotalled 3. Create subtotal lines using formulas. [ =sum(b1:b5) ] 4. Excel will import the formulas, then you push the buttons to turn it automatically into an outline. Then turn the outline into a pivot table. Chuck Paussa Savino, Matt C wrote: Do you know if this can be used to create a spreadsheet with a pivot table? I read the How To page but didn't see anything about it. thx, Matt Savino -Original Message- From: Nicola Ken Barozzi [mailto:[EMAIL PROTECTED] Sent: Monday, March 04, 2002 9:47 AM To: [EMAIL PROTECTED] Subject: Re: : XML -> MS Word?? From: "Carlos Araya" <[EMAIL PROTECTED]> Michiel: Wouldn't it be easier to translate the xml to a CSV (comma separated value) file, import that into Excel and then finish up the formating? I wouldn't even bother trying the MS_HTML option See http://jakarta.apache.org/poi/ . Pure java classes that write to Office formats. Excel reader-writer is tried and tested. -- Nicola Ken Barozzi [EMAIL PROTECTED] - verba volant, scripta manent - (discussions get forgotten, just code remains) -
RE: : XML -> MS Word??
Thanks, saved me a few hours+ of research! Matt Savino Senior Systems Analyst Quest Diagnostics Clinical Trials > -Original Message- > From: Nicola Ken Barozzi [mailto:[EMAIL PROTECTED] > Sent: Monday, March 04, 2002 10:18 AM > To: [EMAIL PROTECTED] > Subject: Re: : XML -> MS Word?? > > > From: "Savino, Matt C" <[EMAIL PROTECTED]> > > > Nope you don't know, or nope it can't? > > ;-) Nope, it can't. > > -- > Nicola Ken Barozzi [EMAIL PROTECTED] > - verba volant, scripta manent - >(discussions get forgotten, just code remains) > - > >
Re: : XML -> MS Word??
From: "Savino, Matt C" <[EMAIL PROTECTED]> > Nope you don't know, or nope it can't? ;-) Nope, it can't. -- Nicola Ken Barozzi [EMAIL PROTECTED] - verba volant, scripta manent - (discussions get forgotten, just code remains) -
Re: : XML -> MS Word??
i agree - all *i* want to know about from this is what sort of xml i can output that M$ word will buy. Carlos Araya wrote: Michiel: Wouldn't it be easier to translate the xml to a CSV (comma separated value) file, import that into Excel and then finish up the formating? I wouldn't even bother trying the MS_HTML option Carlos On 03/04/02 8:36, "Bart Locanthi" <[EMAIL PROTECTED]> wrote: exactly how ghastly are you talking here? is the format [snort] published anywhere? Michiel Verhoef wrote: To top all: it is even quite simple. For a project we had to produce MS Excel files fromXML, using XSLT. As we didn't have a clue about Microsoft formats etc we figured: why not produce this ghastly MS-HTML and see what that does for us?
RE: : XML -> MS Word??
Nope you don't know, or nope it can't? Matt Savino > -Original Message- > From: Nicola Ken Barozzi [mailto:[EMAIL PROTECTED] > Sent: Monday, March 04, 2002 10:06 AM > To: [EMAIL PROTECTED] > Subject: Re: : XML -> MS Word?? > > > From: "Savino, Matt C" <[EMAIL PROTECTED]> > > > Do you know if this can be used to create a spreadsheet with a pivot > table? > > Nope. > > -- > Nicola Ken Barozzi [EMAIL PROTECTED] > - verba volant, scripta manent - >(discussions get forgotten, just code remains) > - > >
Re: : XML -> MS Word??
From: "Savino, Matt C" <[EMAIL PROTECTED]> > Do you know if this can be used to create a spreadsheet with a pivot table? Nope. -- Nicola Ken Barozzi [EMAIL PROTECTED] - verba volant, scripta manent - (discussions get forgotten, just code remains) -
RE: : XML -> MS Word??
Do you know if this can be used to create a spreadsheet with a pivot table? I read the How To page but didn't see anything about it. thx, Matt Savino > -Original Message- > From: Nicola Ken Barozzi [mailto:[EMAIL PROTECTED] > Sent: Monday, March 04, 2002 9:47 AM > To: [EMAIL PROTECTED] > Subject: Re: : XML -> MS Word?? > > > From: "Carlos Araya" <[EMAIL PROTECTED]> > > > Michiel: > > > > Wouldn't it be easier to translate the xml to a CSV (comma separated > value) > > file, import that into Excel and then finish up the > formating? I wouldn't > > even bother trying the MS_HTML option > > See http://jakarta.apache.org/poi/ . > Pure java classes that write to Office formats. > Excel reader-writer is tried and tested. > > -- > Nicola Ken Barozzi [EMAIL PROTECTED] > - verba volant, scripta manent - >(discussions get forgotten, just code remains) > - > >
Re: : XML -> MS Word??
From: "Carlos Araya" <[EMAIL PROTECTED]> > Michiel: > > Wouldn't it be easier to translate the xml to a CSV (comma separated value) > file, import that into Excel and then finish up the formating? I wouldn't > even bother trying the MS_HTML option See http://jakarta.apache.org/poi/ . Pure java classes that write to Office formats. Excel reader-writer is tried and tested. -- Nicola Ken Barozzi [EMAIL PROTECTED] - verba volant, scripta manent - (discussions get forgotten, just code remains) -
Re: : XML -> MS Word??
Michiel: Wouldn't it be easier to translate the xml to a CSV (comma separated value) file, import that into Excel and then finish up the formating? I wouldn't even bother trying the MS_HTML option Carlos On 03/04/02 8:36, "Bart Locanthi" <[EMAIL PROTECTED]> wrote: > exactly how ghastly are you talking here? > > is the format [snort] published anywhere? > > Michiel Verhoef wrote: >> To top all: it is even quite simple. >> For a project we had to produce MS Excel files fromXML, using XSLT. >> As we didn't have a clue about Microsoft formats etc we figured: why >> not produce this ghastly MS-HTML and see what that does for us? > -- Carlos E. Araya ---+ WebCT Administrator/Trainer P | California Virtual Campus - | C/O De Anza College G | 21250 Stevens Creek Blvd ---+ Cupertino, CA 95014 email [EMAIL PROTECTED] web http://www.cvc1.org/ (work) http://www.silverwolf-net.net (personal) phone 408 257 0420 (work) PGP Fingerprint:E629 5DFD 7EAE 4995 E9D7 3D2F 5A9F 0CE7 DFE7 1756 We cannot put off living until we are ready. The most salient characteristic of life is its coerciveness: it is always urgent, 'here and now' without any possible postponement. Life is fired at us point blank. Jose Ortega Y Gasset
Re: : XML -> MS Word??
exactly how ghastly are you talking here? is the format [snort] published anywhere? Michiel Verhoef wrote: To top all: it is even quite simple. For a project we had to produce MS Excel files fromXML, using XSLT. As we didn't have a clue about Microsoft formats etc we figured: why not produce this ghastly MS-HTML and see what that does for us?
RE: : XML -> MS Word??
To top all: it is even quite simple. For a project we had to produce MS Excel files fromXML, using XSLT. As we didn't have a clue about Microsoft formats etc we figured: why not produce this ghastly MS-HTML and see what that does for us? If you simply save an existing Word document as HTML you get a header you can use with XSLT and then it is simply a matter of transforming your document to HTML. You'll need a couple of namespaces but they're in the saved header too. Works like a charm and even allows a lot of stuff in Excel and Word. Not sure whether it wil beat RTF feature wise but you can do a lot without having to wade through RTF specs :-) HTH, Michiel $ -Original Message- $ From: Stephen Clarke [mailto:[EMAIL PROTECTED] $ Sent: vrijdag 1 maart 2002 20:52 $ To: fop $ Subject: OT:: XML -> MS Word?? $ $ $ Hi all, $ $ OK. So much for pdf. Does anyone know if there is any way of $ turning an XML $ into MS Word format? I don't think word is scriptable, is it? $ VBScript, $ perhaps? $ $ Just wondering. $ $ Sorry. The very thought is rather distastefull , isn't it. $ But who knows. $ $ See. Just for fun I did my resume in pdf using fop. But now $ everybody keeps $ asking me for the same thing in MS Word format. Argh. Very $ annoying. So I $ want to be able to change my XML and have it reflected $ automatically in both $ word and pdf. $ $ This could be a contender for the most twisted idea of all time. $ -- $ Best $ SC. $
RE: : XML -> MS Word??
Hi All, I dont know if word is scriptable or not but if you need a format that is the MS word compatible try this http://www.jfor.org/ it converts XML documents conforming to the XSL-FO specification to RTF format. Chill, Ankur -Original Message- From: Stephen Clarke [mailto:[EMAIL PROTECTED] Sent: Friday, March 01, 2002 2:52 PM To: fop Subject: OT:: XML -> MS Word?? Hi all, OK. So much for pdf. Does anyone know if there is any way of turning an XML into MS Word format? I don't think word is scriptable, is it? VBScript, perhaps? Just wondering. Sorry. The very thought is rather distastefull , isn't it. But who knows. See. Just for fun I did my resume in pdf using fop. But now everybody keeps asking me for the same thing in MS Word format. Argh. Very annoying. So I want to be able to change my XML and have it reflected automatically in both word and pdf. This could be a contender for the most twisted idea of all time. -- Best SC.