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