What can I do with this file?

[Pete_UK]

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-comffice:excel"
xmlns="urn:schemas-microsoft-comfficeffice" xmlns:s="urn:schemas-
microsoft-comffice:spreadsheet">
<oocumentProperties>
<o:Author>Bill Production System</o:Author>
<o:Created>2008-02-08T10:51:38</o:Created>
<o:LastSaved>2007-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

 

[Tyro]

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

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-comffice:excel"
xmlns="urn:schemas-microsoft-comfficeffice" xmlns:s="urn:schemas-
microsoft-comffice:spreadsheet">
<oocumentProperties>
<o:Author>Bill Production System</o:Author>
<o:Created>2008-02-08T10:51:38</o:Created>
<o:LastSaved>2007-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

 

[Pete_UK]

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

 

[JP]

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

--JP

 

[Pete_UK]

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

 

[Tyro]

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

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

 

[Pete_UK]

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

 

[Tyro]

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

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

 

[Pete_UK]

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

 

[David Biddulph]

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

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

 

[Pete_UK]

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

Thanks,

Pete

 

[Gord Dibben]

You need at least 2003 version to deal with XML


Gord

 

[Pete_UK]

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

Pete

 

[iliace]

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?

 

[Pete_UK]

Yes, have tried that, but no luck.

Pete

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?



- Show quoted text -

 

[Roger Govier]

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?

 

[Pete_UK]

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