Microsoft XML - Is XML what I need to do....

Author

Is XML what I need to do....

Dave F

2003-12-23, 2:29 pm

....this:

Hi

I'm trying to download some info off a web page into an excel worksheet.
I'm using web query at the moment but that has to display the info (table)
in the worksheet.
I don't need it to do that, I just need to extract the bit that I want.

The first line of the source code is:
<HTML xmlns:fo="http://www.w3.org/1999/XSL/Format">

So I guess it's XML based.

Is XML the way to go?

If so, can you point me in thje right direction?

TIA

Dave F.

Neil Smith

2003-12-23, 8:29 pm

It's impossible to tell from your description without a supporting
URL.

However the xmlns:fo namespace is usually used with xsl formatting
objects, with the ultimate aim of displaying a pdf document. I'm
surprised to see it as part of an HTML declaration.

Cheers - Neil.

On Tue, 23 Dec 2003 18:02:26 -0000, "Dave F"
<david.fox@burohappold.com> wrote:

quote:

>...this:
>
>Hi
>
>I'm trying to download some info off a web page into an excel worksheet.
>I'm using web query at the moment but that has to display the info (table)
>in the worksheet.
>I don't need it to do that, I just need to extract the bit that I want.
>
>The first line of the source code is:
><HTML xmlns:fo="http://www.w3.org/1999/XSL/Format">
>
>So I guess it's XML based.
>
>Is XML the way to go?
>
>If so, can you point me in thje right direction?
>
>TIA
>
>Dave F.
>
>

========================================================
CaptionKit http://www.captionkit.com : Produce subtitled
internet media, transcripts and searchable video. Supports
Real Player, Quicktime and Windows Media Player.

VideoChat with friends online, get Freshly Toasted every
day at http://www.fresh-toast.net : NetMeeting solutions
for a connected world.

Robert Rossney

2003-12-24, 1:29 am

"Neil Smith" <neil@nospam.com> wrote in message
news:3fe8d866.1228636@news.blueyonder.co.uk...
: It's impossible to tell from your description without a supporting
: URL.
:
: However the xmlns:fo namespace is usually used with xsl formatting
: objects, with the ultimate aim of displaying a pdf document. I'm
: surprised to see it as part of an HTML declaration.

If the HTML was generated from an XSLT transform, the transformation process
could have left the namespace declaration in there. XMLSpy, for instance,
puts the xsl-fo namespace into new transforms by default, and if you forget
to snip it out it can end up in the result document.

So the presence of an xsl-fo namespace declaration in an HTML page tells you
pretty much nothing.

Bob Rossney
rbr@well.com