PCM.daily banner
24-11-2024 09:33
PCM.daily
Users Online
· Guests Online: 65

· Members Online: 1
quique2593

· Total Members: 161,799
· Newest Member: InstaPro_APK
View Thread
PCM.daily » Pro Cycling Manager 2006-2020 » Pro Cycling Manager 2010
 Print Thread
Exported Results
Martin_TB
I cannot view the exported results. The .xls file is not working in OpenOffice, and I don't have MS Office or MS Works.

When I try to open the file, OOO3 opens a pop up asking which Character set to use (I spotted it's UTF-8), and which separators etc.

I cann't work out which options to set, and always end up with 6K+ lines all in one column wide:

ie
Spoiler

<?xml version="1.0" encoding="UTF-8"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:o="urn:schemas-microsoft-com:office:office"
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:html="https://www.w3.org/TR/REC-html40">
 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <LastAuthor>Cycling Manager 4</LastAuthor>
  <Created>2003-05-05T17:15:02Z</Created>
  <LastSaved>2003-05-05T17:15:02Z</LastSaved>
  <Version>1.0</Version>
 </DocumentProperties>
 <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
  <DownloadComponents/>
  <LocationOfComponents HRef="file:///C:\"/>
 </OfficeDocumentSettings>
 <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  <WindowHeight>5490</WindowHeight>
  <WindowWidth>9660</WindowWidth>
  <WindowTopX>0</WindowTopX>
  <WindowTopY>0</WindowTopY>
  <ActiveSheet>0</ActiveSheet>
  <ProtectStructure>False</ProtectStructure>
  <ProtectWindows>False</ProtectWindows>
 </ExcelWorkbook>
 <Styles>
  <Style ss:ID="Default" ss:Name="Normal">
   <Alignment ss:Vertical="Bottom"/>
   <Borders>
    <Border ss:Position="Left" ss:LineStyle="Continuous" />
    <Border ss:Position="Right" ss:LineStyle="Continuous" />
    <Border ss:Position="Top" ss:LineStyle="Continuous" />
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" />
   </Borders>
   <Font/>
   <NumberFormat/>
   <Protection/>
  </Style>
  <Style ss:ID="s21">
   <Borders>
    <Border ss:Position="Left" ss:LineStyle="Continuous" />
    <Border ss:Position="Right" ss:LineStyle="Continuous" />
    <Border ss:Position="Top" ss:LineStyle="Continuous" />
    <Border ss:Position="Bottom" ss:LineStyle="Continuous" />
   </Borders>
   <Interior/>



It's looks more like an .xml file, but I can't open it with Firefox, and I don't have an HMTL editor installed on this PC.

Can anyone help please?

Thanks
 
mb2612
Is it a classic or a stage?
i439.photobucket.com/albums/qq112/Gustavovskiy/microjerseys/PT/std_zpsb6c2f350.png[url=www.pcmdaily.com/forum/viewthread.php?thread_id=33182]Team Santander Media Thread[/url]i439.photobucket.com/albums/qq112/Gustavovskiy/microjerseys/PT/std_zpsb6c2f350.png

Please assume I am joking unless otherwise stated
 
Martin_TB
It's a stage, does that make a difference?

I'm playing a new custom team on the continental circuit.
The file is called G.P. Costa degli Etruschi_San Vicenzo - Donoratico.xls and the info under the file name says: Microsoft Excel 97-2003 Worksheet

I have another file called Tour Méditerranéen_La Ciotat - Toulon (Mt. Faron).xls and I can't open that either.

Not saved any more as I didn't see the point if I can't view them
Edited by Martin_TB on 13-01-2011 13:22
 
CrueTrue
Microsoft has a free Excel viewer tool available: https://www.microsoft.com/downloads/en...laylang=en
 
http://www.pcmdaily.com
Martin_TB
I'll DL that and give it a whirl - Thanks CrueTrue.

I'm disappointed though, as OOO has opened all the accounts files from the office before, and is supposed to be MS compatible.

Edit:

Got the viewer - right clicked the file and said to open in viewer.

new pop up "Mircosoft Excel Viewer cannot open files of this type"

I've attached both files to see if anyone else can view them
Martin_TB attached the following file:
exported_results.rar [13.44kB / 132 Downloads]

Edited by Martin_TB on 13-01-2011 13:30
 
CrueTrue
Arh, try this one then: https://www.microsoft.com/downloads/en...laylang=en
 
http://www.pcmdaily.com
Martin_TB
Thanks,

Well that opens it at least, but then I'm stuck. Sad

Rows and rows and rows of HTML, no style sheet associated with it etc. etc.

It's a bloody mess to be honest! Why oh why did they create such a daft thing. A bog standard .xls file without all the .xml would have been fine, or even a .txt file!

Frustrated of London, signing off....


Edit:

here's what I'm looking at
Spoiler
img510.imageshack.us/img510/1970/messy.jpg


Line 10, Location of components - I think that needs editing!

Can anyone else view the exported results I attached above?
Edited by Martin_TB on 13-01-2011 14:24
 
CrueTrue
Well, for everyone with MS Office, it's possible to easily view the files as they are supposed to look.

I'm not very familiar with Open Office, making it a bit difficult to help properly.

Your best shot is to download a few xml viewers, hoping that one of them can show the files properly (= not in the 'coded' format, as you see above).
 
http://www.pcmdaily.com
Martin_TB
If you can all view the files with the standard MS Office (which costs over £100 for student edition and Over £200 for home office), then why can't I view it with the MS Excell Viewer?


Odd.

BTW - I just tried to DL the trial version of MS Office student (try free for 60 days), It wants all my CC details, so that's not happening!


I have OpenOffice for the same reason that most do, It's free and works 99% of the time. It's only some old files it has issues with. In this case, it's the location of the worksheet file is blank, and the stylesheet is defined as
schemas-microsoft-com:office:office

I wonder if it opens with MS Works?

Thinking whether I should try and find an old copy of MS Office 2003 for a dodgy DL just for this!
Edited by Martin_TB on 13-01-2011 14:58
 
Martin_TB
Working now.

Thanks for all the feedback.
 
baia
What have you done,has i have the same problem as you..
i1312.photobucket.com/albums/t525/baia3/FDJprofileban_zps42833c10.jpg
 
Ad Bot
Posted on 24-11-2024 09:33
Bot Agent

Posts: Countless
Joined: 23.11.09

IP: None  
Martin_TB
I got old of an old copy of MS Office 2003, and installed only the Excell part of the package.

I have no idea why the Excell view open it.
 
Martin_TB
OOOH!!

here's how to do it in OpenOffice.

Rename the file from *.xls to *.xml

That changes it from an MS workbook to a XML doc which OpenOffice can read!

Whoop whoop!

Uninstalling my dodgy copy of MS Office right now!

Banana
 
baia
Thanks...but i did like you said,changed to xml but when changed it warned that file would loose all writing,i opened and it was empty.Its weird because i can open the exported results from pcm10.
i1312.photobucket.com/albums/t525/baia3/FDJprofileban_zps42833c10.jpg
 
Martin_TB
That's very odd - worked fro me.

What version of OpenOffice do you have? Mine is 3.1

You could try this, copy the *.xls file, past it somewhere else and rename it *.ods

ie you have a file called Tour of Oman_Nizwa – Samail.xls, you copy paste it to another folder (so you don't destroy the original), and you rename it Tour of Oman_Nizwa – Samail.ods and OO calc should open that easily.

I attached one I did that with, so you can see if your OO can read it

edit

Sorry, I had to rename it again to Tour_of_Oman_Nizwa–Samail.ods as the attachment won't work if there are spaces in the file name. Attached now.

edit 2

Grrr, *.ods not allowed in files types, zipped it with Winrar.

3rd time lucky

Edit
Stilll no joy, renamed it again!
Martin_TB attached the following file:
pcmtest.rar [6.86kB / 375 Downloads]

Edited by Martin_TB on 14-01-2011 14:54
 
baia
Thanks Martin..will try it now...

PS-this one worked...thanks for your help. Wink
Edited by baia on 14-01-2011 15:02
i1312.photobucket.com/albums/t525/baia3/FDJprofileban_zps42833c10.jpg
 
Martin_TB
Brilliant.

Glad to be of help Smile
 
diasdagoberto
Thank you!
Been downloading about 10 different xl viewers now, without sucess, and all I needed to do was to rename the file, great news.
Edited by diasdagoberto on 07-03-2011 12:24
Saeco 2010
https://pcmdaily.com/forum/viewthread.php?thread_id=15773
 
Jump to Forum:
Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Latest content
Screenshots
Danish Fan
Danish Fan
PCM09: Funny Screenshots
Fantasy Betting
Current bets:
No bets available.
Best gamblers:
bullet fighti... 18,376 PCM$
bullet df_Trek 17,374 PCM$
bullet Marcovdw 15,345 PCM$
bullet jseadog1 13,552 PCM$
bullet baseba... 10,439 PCM$

bullet Main Fantasy Betting page
bullet Rankings: Top 100
ManGame Betting
Current bets:
No bets available.
Best gamblers:
bullet Ollfardh 21,890 PCM$
bullet df_Trek 15,520 PCM$
bullet Marcovdw 14,800 PCM$
bullet jseadog1 13,500 PCM$
bullet baseball... 7,332 PCM$

bullet Main MG Betting page
bullet Get weekly MG PCM$
bullet Rankings: Top 100
Render time: 0.39 seconds