What can I do with this file?
 

I've been sent an .xls file from a supplier, but when I open it in XL
2000 this is what I see:

<?xml version='1.0'?
<?mso-application progid='Excel.Sheet'?
<s:Workbook xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:s="urn:schemas-
microsoft-com:office:spreadsheet"
<o:DocumentProperties
<o:AuthorBill Production System</o:Author
<o:Created2008-02-08T10:51:38</o:Created
<o:LastSaved2007-02-01T13:14:36</o:LastSaved

This is just the first few rows - it goes on for 23,000+, and all
these entries are in column A.

The supplier has had a new billing system installed.

Can I do anything with this file?

Pete

What can I do with this file?
 

Looks like it's part of an Excel 2007 file. Excel 2007 creates XML files and
stores them as compressed files. You can rename an Excel 2007 .xlsx file as
..zip and open the file with WinZip or any unzipper and look at the files
inside in a text editor.

Tyro

"Pete_UK" wrote in message
...
I've been sent an .xls file from a supplier, but when I open it in XL
2000 this is what I see:

<?xml version='1.0'?
<?mso-application progid='Excel.Sheet'?
<s:Workbook xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:s="urn:schemas-
microsoft-com:office:spreadsheet"
<o:DocumentProperties
<o:AuthorBill Production System</o:Author
<o:Created2008-02-08T10:51:38</o:Created
<o:LastSaved2007-02-01T13:14:36</o:LastSaved

This is just the first few rows - it goes on for 23,000+, and all
these entries are in column A.

The supplier has had a new billing system installed.

Can I do anything with this file?

Pete

What can I do with this file?
 

Thanks for the suggestion, Tyro, but unfortunately it didn't work -
maybe because it was an .xls file and not .xlsx. I downloaded the
XL2007 viewer/converter last week to try that, but no joy there
either.

Anyone else with any ideas on what I can do to open this file
normally? (I have requested the supplier to sort it out, but they
don't seem too interested or capable of doing so).

Pete

On Mar 5, 5:30Â*pm, "Tyro" wrote:
Looks like it's part of an Excel 2007 file. Excel 2007 creates XML files and
stores them as compressed files. You can rename an Excel 2007 .xlsx file as
.zip and open the file with WinZip or any unzipper and look at the files
inside in a text editor.

Tyro

"Pete_UK" wrote in message

...
I've been sent an .xls file from a supplier, but when I open it in XL
2000 this is what I see:

<?xml version='1.0'?
<?mso-application progid='Excel.Sheet'?
<s:Workbook xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:s="urn:schemas-
microsoft-com:office:spreadsheet"
Â* <o:DocumentProperties
Â* Â* <o:AuthorBill Production System</o:Author
Â* Â* <o:Created2008-02-08T10:51:38</o:Created
Â* Â* <o:LastSaved2007-02-01T13:14:36</o:LastSaved

This is just the first few rows - it goes on for 23,000+, and all
these entries are in column A.

The supplier has had a new billing system installed.

Can I do anything with this file?

Pete

What can I do with this file?
 

Can you rename the file to .xml and try to import?

--JP

On Mar 5, 2:30*pm, Pete_UK wrote:
Thanks for the suggestion, Tyro, but unfortunately it didn't work -
maybe because it was an .xls file and not .xlsx. I downloaded the
XL2007 viewer/converter last week to try that, but no joy there
either.

Anyone else with any ideas on what I can do to open this file
normally? (I have requested the supplier to sort it out, but they
don't seem too interested or capable of doing so).

Pete

What can I do with this file?
 

I renamed it to .xml but File | Open just saw it as a text file and
took me into the Text Import Wizard. I think it was later versions of
XL that could import xml files directly, but thanks for the
suggestion.

Any other ideas?

Pete

On Mar 5, 7:35*pm, JP wrote:
Can you rename the file to .xml and try to import?

--JP

On Mar 5, 2:30*pm, Pete_UK wrote:



Thanks for the suggestion, Tyro, but unfortunately it didn't work -
maybe because it was an .xls file and not .xlsx. I downloaded the
XL2007 viewer/converter last week to try that, but no joy there
either.

Anyone else with any ideas on what I can do to open this file
normally? (I have requested the supplier to sort it out, but they
don't seem too interested or capable of doing so).

Pete- Hide quoted text -

- Show quoted text -

What can I do with this file?
 

Excel 2007 can import/export XML files on the Developer Tab of the ribbon.
It can also save files as XML Data or Excel 2003 XML. I just saved a
workbook in Excel 2003 XML format, closed it and opened it in XML format
with no problem. Perhaps you could open your file in Excel 2003/2007 in XML
format and save it in xls format.

Tyro

"Pete_UK" wrote in message
...
I renamed it to .xml but File | Open just saw it as a text file and
took me into the Text Import Wizard. I think it was later versions of
XL that could import xml files directly, but thanks for the
suggestion.

Any other ideas?

Pete

On Mar 5, 7:35 pm, JP wrote:
Can you rename the file to .xml and try to import?

--JP

On Mar 5, 2:30 pm, Pete_UK wrote:



Thanks for the suggestion, Tyro, but unfortunately it didn't work -
maybe because it was an .xls file and not .xlsx. I downloaded the
XL2007 viewer/converter last week to try that, but no joy there
either.

Anyone else with any ideas on what I can do to open this file
normally? (I have requested the supplier to sort it out, but they
don't seem too interested or capable of doing so).

Pete- Hide quoted text -

- Show quoted text -

What can I do with this file?
 

Yes, but I have Excel 2000 !!

It hardly seems worth the trouble and expense of upgrading for the
sake of one file.

Thanks for your contributions.

Pete

On Mar 5, 9:45*pm, "Tyro" wrote:
Excel 2007 can import/export XML files on the Developer Tab of the ribbon.
It can also save files as XML Data or Excel 2003 XML. I just saved a
workbook in Excel 2003 XML format, closed it and opened it in XML format
with no problem. Perhaps you could open your file in Excel 2003/2007 in XML
format and save it in xls format.

Tyro

"Pete_UK" wrote in message

...
I renamed it to .xml but File | Open just saw it as a text file and
took me into the Text Import Wizard. I think it was later versions of
XL that could import xml files directly, but thanks for the
suggestion.

Any other ideas?

Pete

On Mar 5, 7:35 pm, JP wrote:



Can you rename the file to .xml and try to import?

--JP

On Mar 5, 2:30 pm, Pete_UK wrote:

Thanks for the suggestion, Tyro, but unfortunately it didn't work -
maybe because it was an .xls file and not .xlsx. I downloaded the
XL2007 viewer/converter last week to try that, but no joy there
either.

Anyone else with any ideas on what I can do to open this file
normally? (I have requested the supplier to sort it out, but they
don't seem too interested or capable of doing so).

Pete- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

What can I do with this file?
 

Well, if you could upload your file to savefile.com, I could d/l it and see
if I can convert it from xml to xls

Tyro

"Pete_UK" wrote in message
...
Yes, but I have Excel 2000 !!

It hardly seems worth the trouble and expense of upgrading for the
sake of one file.

Thanks for your contributions.

Pete

On Mar 5, 9:45 pm, "Tyro" wrote:
Excel 2007 can import/export XML files on the Developer Tab of the ribbon.
It can also save files as XML Data or Excel 2003 XML. I just saved a
workbook in Excel 2003 XML format, closed it and opened it in XML format
with no problem. Perhaps you could open your file in Excel 2003/2007 in
XML
format and save it in xls format.

Tyro

"Pete_UK" wrote in message

...
I renamed it to .xml but File | Open just saw it as a text file and
took me into the Text Import Wizard. I think it was later versions of
XL that could import xml files directly, but thanks for the
suggestion.

Any other ideas?

Pete

On Mar 5, 7:35 pm, JP wrote:



Can you rename the file to .xml and try to import?

--JP

On Mar 5, 2:30 pm, Pete_UK wrote:

Thanks for the suggestion, Tyro, but unfortunately it didn't work -
maybe because it was an .xls file and not .xlsx. I downloaded the
XL2007 viewer/converter last week to try that, but no joy there
either.

Anyone else with any ideas on what I can do to open this file
normally? (I have requested the supplier to sort it out, but they
don't seem too interested or capable of doing so).

Pete- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

What can I do with this file?
 

Thanks for the offer, Tyro, but I don't think my client would be very
happy about that. I've just remembered that my daughter has XL2003 on
her machine, so I'll go and visit her tomorrow and see if I can get
any joy there.

Cheers,

Pete

On Mar 5, 11:24*pm, "Tyro" wrote:
Well, if you could upload your file to savefile.com, I could d/l it and see
if I can convert it from xml to xls

Tyro

"Pete_UK" wrote in message

...
Yes, but I have Excel 2000 !!

It hardly seems worth the trouble and expense of upgrading for the
sake of one file.

Thanks for your contributions.

Pete

On Mar 5, 9:45 pm, "Tyro" wrote:



Excel 2007 can import/export XML files on the Developer Tab of the ribbon.

What can I do with this file?
 

Don't forget that in Excel 2003 the XML support comes only with Office
Professional (or Excel stand-alone), not with the lower editions of Office.
--
David Biddulph

"Pete_UK" wrote in message
...
Thanks for the offer, Tyro, but I don't think my client would be very
happy about that. I've just remembered that my daughter has XL2003 on
her machine, so I'll go and visit her tomorrow and see if I can get
any joy there.

Cheers,

Pete

On Mar 5, 11:24 pm, "Tyro" wrote:
Well, if you could upload your file to savefile.com, I could d/l it and
see
if I can convert it from xml to xls

Tyro

"Pete_UK" wrote in message

...
Yes, but I have Excel 2000 !!

It hardly seems worth the trouble and expense of upgrading for the
sake of one file.

Thanks for your contributions.

Pete

On Mar 5, 9:45 pm, "Tyro" wrote:



Excel 2007 can import/export XML files on the Developer Tab of the
ribbon.
It can also save files as XML Data or Excel 2003 XML. I just saved a
workbook in Excel 2003 XML format, closed it and opened it in XML format
with no problem. Perhaps you could open your file in Excel 2003/2007 in
XML
format and save it in xls format.

Tyro

"Pete_UK" wrote in message

...
I renamed it to .xml but File | Open just saw it as a text file and
took me into the Text Import Wizard. I think it was later versions of
XL that could import xml files directly, but thanks for the
suggestion.

Any other ideas?

Pete

On Mar 5, 7:35 pm, JP wrote:

Can you rename the file to .xml and try to import?

--JP

On Mar 5, 2:30 pm, Pete_UK wrote:

Thanks for the suggestion, Tyro, but unfortunately it didn't work -
maybe because it was an .xls file and not .xlsx. I downloaded the
XL2007 viewer/converter last week to try that, but no joy there
either.

Anyone else with any ideas on what I can do to open this file
normally? (I have requested the supplier to sort it out, but they
don't seem too interested or capable of doing so).

Pete- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

What can I do with this file?
 

I didn't know that, David, so something else to consider ...

Thanks,

Pete

On Mar 5, 11:36*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Don't forget that in Excel 2003 the XML support comes only with Office
Professional (or Excel stand-alone), not with the lower editions of Office..
--
David Biddulph

"Pete_UK" wrote in message

...
Thanks for the offer, Tyro, but I don't think my client would be very
happy about that. I've just remembered that my daughter has XL2003 on
her machine, so I'll go and visit her tomorrow and see if I can get
any joy there.

Cheers,

Pete

On Mar 5, 11:24 pm, "Tyro" wrote:



Well, if you could upload your file to savefile.com, I could d/l it and
see
if I can convert it from xml to xls

Tyro

"Pete_UK" wrote in message

...
Yes, but I have Excel 2000 !!

It hardly seems worth the trouble and expense of upgrading for the
sake of one file.

Thanks for your contributions.

Pete

On Mar 5, 9:45 pm, "Tyro" wrote:

Excel 2007 can import/export XML files on the Developer Tab of the
ribbon.
It can also save files as XML Data or Excel 2003 XML. I just saved a
workbook in Excel 2003 XML format, closed it and opened it in XML format
with no problem. Perhaps you could open your file in Excel 2003/2007 in
XML
format and save it in xls format.

Tyro

"Pete_UK" wrote in message

....
I renamed it to .xml but File | Open just saw it as a text file and
took me into the Text Import Wizard. I think it was later versions of
XL that could import xml files directly, but thanks for the
suggestion.

Any other ideas?

Pete

On Mar 5, 7:35 pm, JP wrote:

Can you rename the file to .xml and try to import?

--JP

On Mar 5, 2:30 pm, Pete_UK wrote:

Thanks for the suggestion, Tyro, but unfortunately it didn't work -
maybe because it was an .xls file and not .xlsx. I downloaded the
XL2007 viewer/converter last week to try that, but no joy there
either.

Anyone else with any ideas on what I can do to open this file
normally? (I have requested the supplier to sort it out, but they
don't seem too interested or capable of doing so).

Pete- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

What can I do with this file?
 

You need at least 2003 version to deal with XML


Gord

On Wed, 5 Mar 2008 12:56:59 -0800 (PST), Pete_UK wrote:

I renamed it to .xml but File | Open just saw it as a text file and
took me into the Text Import Wizard. I think it was later versions of
XL that could import xml files directly, but thanks for the
suggestion.

Any other ideas?

Pete

On Mar 5, 7:35*pm, JP wrote:
Can you rename the file to .xml and try to import?

--JP

On Mar 5, 2:30*pm, Pete_UK wrote:



Thanks for the suggestion, Tyro, but unfortunately it didn't work -
maybe because it was an .xls file and not .xlsx. I downloaded the
XL2007 viewer/converter last week to try that, but no joy there
either.

Anyone else with any ideas on what I can do to open this file
normally? (I have requested the supplier to sort it out, but they
don't seem too interested or capable of doing so).

Pete- Hide quoted text -

- Show quoted text -

What can I do with this file?
 

Yeah, so it seems ... (this bloody supplier !!)

Pete

On Mar 6, 12:16*am, Gord Dibben <gorddibbATshawDOTca wrote:
You need at least 2003 version to deal with XML

Gord



On Wed, 5 Mar 2008 12:56:59 -0800 (PST), Pete_UK wrote:
I renamed it to .xml but File | Open just saw it as a text file and
took me into the Text Import Wizard. I think it was later versions of
XL that could import xml files directly, but thanks for the
suggestion.

Any other ideas?

Pete

On Mar 5, 7:35*pm, JP wrote:
Can you rename the file to .xml and try to import?

--JP

On Mar 5, 2:30*pm, Pete_UK wrote:

Thanks for the suggestion, Tyro, but unfortunately it didn't work -
maybe because it was an .xls file and not .xlsx. I downloaded the
XL2007 viewer/converter last week to try that, but no joy there
either.

Anyone else with any ideas on what I can do to open this file
normally? (I have requested the supplier to sort it out, but they
don't seem too interested or capable of doing so).

Pete- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

What can I do with this file?
 

That XML doesn't look like a part of any 2007 .xlm I've ever seen.
I'm guessing it's some kind of table data saved as XML (especially
with the size you indicated). But you won't be able to open in with
Excel 2000. Have you tried renaming it .xml and opening it with a
browser?


On Mar 5, 7:24*pm, Pete_UK wrote:
Yeah, so it seems ... (this bloody supplier !!)

Pete

On Mar 6, 12:16*am, Gord Dibben <gorddibbATshawDOTca wrote:

You need at least 2003 version to deal with XML

Gord

On Wed, 5 Mar 2008 12:56:59 -0800 (PST), Pete_UK wrote:
I renamed it to .xml but File | Open just saw it as a text file and
took me into the Text Import Wizard. I think it was later versions of
XL that could import xml files directly, but thanks for the
suggestion.

Any other ideas?

Pete

On Mar 5, 7:35*pm, JP wrote:
Can you rename the file to .xml and try to import?

--JP

On Mar 5, 2:30*pm, Pete_UK wrote:

Thanks for the suggestion, Tyro, but unfortunately it didn't work -
maybe because it was an .xls file and not .xlsx. I downloaded the
XL2007 viewer/converter last week to try that, but no joy there
either.

Anyone else with any ideas on what I can do to open this file
normally? (I have requested the supplier to sort it out, but they
don't seem too interested or capable of doing so).

Pete- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

What can I do with this file?
 

Yes, have tried that, but no luck.

Pete

On Mar 6, 4:03*am, iliace wrote:
That XML doesn't look like a part of any 2007 .xlm I've ever seen.
I'm guessing it's some kind of table data saved as XML (especially
with the size you indicated). *But you won't be able to open in with
Excel 2000. *Have you tried renaming it .xml and opening it with a
browser?

On Mar 5, 7:24*pm, Pete_UK wrote:



Yeah, so it seems ... (this bloody supplier !!)

Pete

On Mar 6, 12:16*am, Gord Dibben <gorddibbATshawDOTca wrote:

You need at least 2003 version to deal with XML

Gord

On Wed, 5 Mar 2008 12:56:59 -0800 (PST), Pete_UK wrote:
I renamed it to .xml but File | Open just saw it as a text file and
took me into the Text Import Wizard. I think it was later versions of
XL that could import xml files directly, but thanks for the
suggestion.

Any other ideas?

Pete

On Mar 5, 7:35*pm, JP wrote:
Can you rename the file to .xml and try to import?

--JP

On Mar 5, 2:30*pm, Pete_UK wrote:

Thanks for the suggestion, Tyro, but unfortunately it didn't work -
maybe because it was an .xls file and not .xlsx. I downloaded the
XL2007 viewer/converter last week to try that, but no joy there
either.

Anyone else with any ideas on what I can do to open this file
normally? (I have requested the supplier to sort it out, but they
don't seem too interested or capable of doing so).

Pete- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

What can I do with this file?
 

Hi Pete

What happens if you try opening the file with Internet Explorer?
Does it render like an Excel file?
If so, can you copy and paste values to your copy of XL2000?

--
Regards
Roger Govier

"Pete_UK" wrote in message
...
Yes, have tried that, but no luck.

Pete

On Mar 6, 4:03 am, iliace wrote:
That XML doesn't look like a part of any 2007 .xlm I've ever seen.
I'm guessing it's some kind of table data saved as XML (especially
with the size you indicated). But you won't be able to open in with
Excel 2000. Have you tried renaming it .xml and opening it with a
browser?

On Mar 5, 7:24 pm, Pete_UK wrote:



Yeah, so it seems ... (this bloody supplier !!)

Pete

On Mar 6, 12:16 am, Gord Dibben <gorddibbATshawDOTca wrote:

You need at least 2003 version to deal with XML

Gord

On Wed, 5 Mar 2008 12:56:59 -0800 (PST), Pete_UK
wrote:
I renamed it to .xml but File | Open just saw it as a text file and
took me into the Text Import Wizard. I think it was later versions
of
XL that could import xml files directly, but thanks for the
suggestion.

Any other ideas?

Pete

On Mar 5, 7:35 pm, JP wrote:
Can you rename the file to .xml and try to import?

--JP

On Mar 5, 2:30 pm, Pete_UK wrote:

Thanks for the suggestion, Tyro, but unfortunately it didn't
work -
maybe because it was an .xls file and not .xlsx. I downloaded
the
XL2007 viewer/converter last week to try that, but no joy there
either.

Anyone else with any ideas on what I can do to open this file
normally? (I have requested the supplier to sort it out, but
they
don't seem too interested or capable of doing so).

Pete- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

What can I do with this file?
 

That's what I was hoping would happen when I tried it, Roger, but it
just brought it in as multi-coloured text - great if I wanted (and
knew how) to edit it, but no further forward for getting it into
Excel.

Thanks for the suggestion.

Pete

On Mar 6, 9:38*am, "Roger Govier" <roger@technology4unospamdotcodotuk
wrote:
Hi Pete

What happens if you try opening the file with Internet Explorer?
Does it render like an Excel file?
If so, can you copy and paste values to your copy of XL2000?

--
Regards
Roger Govier

"Pete_UK" wrote in message

...



Yes, have tried that, but no luck.

Pete

On Mar 6, 4:03 am, iliace wrote:
That XML doesn't look like a part of any 2007 .xlm I've ever seen.
I'm guessing it's some kind of table data saved as XML (especially
with the size you indicated). But you won't be able to open in with
Excel 2000. Have you tried renaming it .xml and opening it with a
browser?

On Mar 5, 7:24 pm, Pete_UK wrote:

Yeah, so it seems ... (this bloody supplier !!)

Pete

On Mar 6, 12:16 am, Gord Dibben <gorddibbATshawDOTca wrote:

You need at least 2003 version to deal with XML

Gord

On Wed, 5 Mar 2008 12:56:59 -0800 (PST), Pete_UK
wrote:
I renamed it to .xml but File | Open just saw it as a text file and
took me into the Text Import Wizard. I think it was later versions
of
XL that could import xml files directly, but thanks for the
suggestion.

Any other ideas?

Pete

On Mar 5, 7:35 pm, JP wrote:
Can you rename the file to .xml and try to import?

--JP

On Mar 5, 2:30 pm, Pete_UK wrote:

Thanks for the suggestion, Tyro, but unfortunately it didn't
work -
maybe because it was an .xls file and not .xlsx. I downloaded
the
XL2007 viewer/converter last week to try that, but no joy there
either.

Anyone else with any ideas on what I can do to open this file
normally? (I have requested the supplier to sort it out, but
they
don't seem too interested or capable of doing so).

Pete- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -