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(_dot_)byomokesh(_at_)gmail(_dot_)com]
Sent: vrijdag 28 maart 2008 6:54
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: [xsl] 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(_at_)aol(_dot_)com
E-Mail 2: DennisLRaab(_at_)comcast(_dot_)net
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
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail:
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--