[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: MS Word to Excel using XSLT
Dear Byomokesh Sahoo, Presuming you mean you have a MS Word (XML) document of which you want the contents to be converted automatically to an MS Excel (XML) sheet by means of an XSLT stylesheet, perhaps even executed from withing MS Word. The latter will require MS Word 2003 Professional edition, which supplies you with the option to 'apply an XSLT transform' upon save. But it could be done outside of MS Office just as well, using some command-line tool to transform the WordML to ExcelML. About the complexity of the XSLT you will need: I don't think you will need a very complex XSLT, but it mainly depends on how you want your information arranged in Excel. If it is merely an XSLT version of 'copy and paste', it might be sufficient to create an empty ExcelML file and use that as a literal result template, inserting values from the WordML in the proper locations and nothing more. Could it be however that you actually want to gather information from multiple Word documents into a single Excel file, then things could get much more complicated, depending on whether this is a one-time or a re-occuring job for instance. Kind regards, Geert > Drs. G.P.H. Josten Consultant Daidalos BV Source of Innovation Hoekeindsehof 1-4 2665 JZ Bleiswijk Tel.: +31 (0) 10 850 1200 Fax: +31 (0) 10 850 1199 www.daidalos.nl KvK 27164984 De informatie - verzonden in of met dit emailbericht - is afkomstig van Daidalos BV en is uitsluitend bestemd voor de geadresseerde. Indien u dit bericht onbedoeld hebt ontvangen, verzoeken wij u het te verwijderen. Aan dit bericht kunnen geen rechten worden ontleend. > From: Byomokesh Sahoo [mailto:sahoo.byomokesh@xxxxxxxxx] > Sent: vrijdag 28 maart 2008 6:54 > To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx > Subject: MS Word to Excel using XSLT > > Dear All, > > I have one doubt. I want MS Word file to convert MS Excel (like > database) files using XSLT. Is it possible ? If yes, How > > I am using Word/Excel 2003. > > My Word File > ------------------- > > Option 1: > Name: Mr. Dennis L. Raab > Greeting to use: Dennis > Cuurent Work Info: > Title: Chief Financial Officer > Company: Insurance.com > Address: Street; 29001 Solon Road > City: Solon > State: OH > Zip: 44139 > Phone: (440) 715-0061 > Home Info: > Address: Street; 17560 Lakesedge Trail, > City: Chagrin Falls > State: OH > Zip: 44023 > Phone: (440) 543-7719 > Cell Phone #: (312) 804-0450 > E-Mail 1: dennislraab@xxxxxxx > E-Mail 2: DennisLRaab@xxxxxxxxxxx > Status: alumni > Chapter: Cleveland > Sub-Group: Insurance > Entry date: 03/03/03 > Work History 1: Insurance.com > Work History 2: CNA Financial > Work History 3: Electric (US, London, Ontario > Work History 5: > Work History 6: > Work History 7: > Work History 8: > > Would anyone suggest me. > > Thanks > Byomokesh Sahoo > > Om Trayambakam Yajaamahe Sugandhim Pushtivardhanam > Urvaarukamiva Bandhanan Mrytor Muksheeya Mamritaat
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|