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

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! <a href="http://www.graq.co.uk">Graq</a>	[reply]

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

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!

[reply]

In Section Seekers of Perl Wisdom