RE: [xsl] MS Word to Excel using XSLT

["Geert Josten" <geert.josten@xxxxxxxxxxx>]

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: [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@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