Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re: Problems with Microsft's new Office 'XML'

by graq (Curate)
on Oct 10, 2005 at 08:37 UTC ( [id://498738]=note: print w/replies, xml ) Need Help??


in reply to Problems with Microsft's new Office 'XML'

Just a quick followup to 'close' the question.

The main problem with the new Excel XML is that it is still a binary. I haven't managed to read the XML binary with Spreadsheet::ParseExcel, but have worked around this by getting the client to supply a 'normal' Excel binary and then reading that.

If anyone does manage to combine xml parsing with Excel binary, please do msg me :)

Replies are listed 'Best First'.
Re^2: Problems with Microsft's new Office 'XML'
by pajout (Curate) on Oct 10, 2005 at 15:26 UTC
    I have no experience with M$ tools for transforming from xls to XML, but, if your requirement is not too general, you can write VBA macro which transforms and prints xls into _your_ form of xml file. And parsing will be easy on the next step... I hate the wheel reinvention, but I suppose that M$ XML could be similar to <some>binary_code</some>...
      The file (fetching and) processing takes place on a Solaris box; I'm not aware of any way of running VB script without using a Windows OS.

      As a total aside, I am beginning to dislike this problem, as it looks like I'm going to have to use SOAP to fetch the file now (and in some awful flat WSDL format) which is causing completely different problems - but I am betting that other clients will wish to supply (non binary-xml) Excel, so the current parsing solutuion is of use. Look out for my next question in SoPW!

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://498738]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others taking refuge in the Monastery: (6)
As of 2024-03-29 01:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found