[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: MS Word to Excel using XSLT

Subject: Re: MS Word to Excel using XSLT
From: "Vyacheslav Sedov" <vyacheslav.sedov@xxxxxxxxx>
Date: Fri, 28 Mar 2008 14:20:18 +0300
Re:  MS Word to Excel using XSLT
hi all,

to my mind it not good idea to learn complex buggy outdated
proprietary format (even two) - i suggest "feature-proof" way :)

you can use Sun`s ODF Plugin for Microsoft Office
http://www.sun.com/software/star/odf_plugin/index.jsp then save files
as ODT (or just use OpenOffice open Word 2003 files & save as ODT -
this can be automated), then perform two simple transformations
instead one complex - (1) extract data to custom XML file (2) make new
document from extracted data in OpenOffice Calc format
(http://openoffice.org) then if you really need MS Office 2003 format
- you can save it from OpenOffice as MS Excell 2003 document (can be
automated too)

for archive handling i usually use 7-zip comand line (http://www.7-zip.org/)

sure i can help if you want

with best wishes,
Slav

p.s. if to be truly - i don`t understand why you trying to extract
data from one not proper format and put into another not proper format
for data handling (even OpenOffice format not proper too) - maybe
better to put extracted data to eXist database and then generate any
format that you need (or anyone else) on the fly?

On Fri, Mar 28, 2008 at 1:45 PM, Michael Kay <mike@xxxxxxxxxxxx> wrote:
> >
>  > I have one doubt. I want MS Word  file to convert MS Excel (like
>  > database) files using XSLT. Is it possible ? If yes, How
>  >
>
>  It is possible to export XML from Word, and it is possible to import XML
>  into Excel, and of course it is possible to convert the first XML into the
>  second using XSLT. So yes, it is possible.
>
>  However, these XML formats are quite complex and not particularly
>  XSLT-friendly, so although it is possible, it is not at all easy. Of course
>  the details depend on (a) what particular transformation you want to
>  perform, and (b) how general you want to make it (that is, how large a class
>  of Word documents you want to recognize).
>
>  It's going to be quite a bit easier, I suspect, if you use XSLT 2.0 rather
>  than 1.0, because of the facilities for grouping and regular expression
>  matching.
>
>  Michael Kay
>  http://www.saxonica.com/

Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.