Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris

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

by pajout (Curate)
on Oct 10, 2005 at 15:26 UTC ( #498845=note: print w/replies, xml ) Need Help??

in reply to Re: Problems with Microsft's new Office 'XML'
in thread Problems with Microsft's new Office 'XML'

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>...
  • Comment on Re^2: Problems with Microsft's new Office 'XML'

Replies are listed 'Best First'.
Re^3: Problems with Microsft's new Office 'XML'
by graq (Curate) on Oct 10, 2005 at 22:56 UTC
    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?

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

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (3)
As of 2023-03-22 22:01 GMT
Find Nodes?
    Voting Booth?
    Which type of climate do you prefer to live in?

    Results (60 votes). Check out past polls.