PCM.daily banner
24-12-2024 00:51
PCM.daily
Users Online
· Guests Online: 39

· Members Online: 1
baseballlover312

· Total Members: 162,217
· Newest Member: Donnellwhake
View Thread
PCM.daily » Pro Cycling Manager 2006-2020 » Pro Cycling Manager 2013
 Print Thread
Exported Results Error
baseballlover312
I've tried to export results, but every time I open up my Fleche results or Liege results I get a "Worksheet Settings" error. I've tried multiple computers with no change. This only applies to those two results, one's I exported before Fleche show no issue at all. It is vital for me to be able to do this going forward.

Here's the error:

XML ERROR in Worksheet Setting
REASON: Bad Value
FILE: C:\Users\"Username"\Documents\Pro Cycling Manager 2013\Users\Pickles312\Export\Exported_results\Liege-Bastogne-Liège_Liège-Liège.xls
GROUP: Worksheet
TAG: Table
ATTRIB: ExpandedRowCount
VALUE: 200


Anybody know what's going wrong and how I can fix it? Any help would be appreciated. Thanks.
RIP Exxon Duke, David Veilleux, Double Feature, and Monster Energy
pcmdaily.com/files/Awards2016/avatar.png
pcmdaily.com/files/Awards2019/funniest.png
pcmdaily.com/images/mg/Awards2020/funniest.png
pcmdaily.com/images/mg/Awards2020/forumthread.png
i.imgur.com/VCXYUyF.png
i.imgur.com/4osUjkI.png
 
Cycleman123
I don't get the same error, so this might not work, but whenever I get an error message on Excel I just ignore it and everything works fine.
i1193.photobucket.com/albums/aa348/the_hoyle86/Graphics/Road%20to%20Le%20Tour_zpsnovshuyf.png

i1193.photobucket.com/albums/aa348/the_hoyle86/Graphics/Oricav2_zpsc6257c80.png
 
Ad Bot
Posted on 24-12-2024 00:51
Bot Agent

Posts: Countless
Joined: 23.11.09

IP: None  
baseballlover312
I can't ignore it, the file doesn't open.
RIP Exxon Duke, David Veilleux, Double Feature, and Monster Energy
pcmdaily.com/files/Awards2016/avatar.png
pcmdaily.com/files/Awards2019/funniest.png
pcmdaily.com/images/mg/Awards2020/funniest.png
pcmdaily.com/images/mg/Awards2020/forumthread.png
i.imgur.com/VCXYUyF.png
i.imgur.com/4osUjkI.png
 
Lachi
As the error says, there is an XML error. Normally this means that one or more characters in the file are not valid.

You could ask google how to open an XLS file with an XML editor. Good XML editors should be able to find and mark all errors, so that you could fix them. But I think it would involve much reading, so I wonder how important these results are for you.
 
baseballlover312
Well I need them for my story I think it is vital that I fix this issue eventually. I'm just not sure what the difference is between the files that were exported Friday as opposed to now.

Suppose I'll look that up eventually, don't have time now. thank you for your help.
RIP Exxon Duke, David Veilleux, Double Feature, and Monster Energy
pcmdaily.com/files/Awards2016/avatar.png
pcmdaily.com/files/Awards2019/funniest.png
pcmdaily.com/images/mg/Awards2020/funniest.png
pcmdaily.com/images/mg/Awards2020/forumthread.png
i.imgur.com/VCXYUyF.png
i.imgur.com/4osUjkI.png
 
547984
According to ExpandedRowCount hits on Google, it might have to do with something about the XML value in ss:ExpandedRowCount (which is 200) does not match the number of riders(rows) that are in the file I guess.

Now I don't have a clue on how to edit a XML Frown
baseballlover312, 06-03-14 : "Nuke Moscow...Don't worry Russia, we've got plenty of love to go around your cities"
Sarah Palin, 08-03-14 (CPAC, on Russian aggression) : "The only thing that stops a bad guy with a nuke is a good guy with a nuke"

i1360.photobucket.com/albums/r657/547984/truth-vi.png

Big thanks to jdog for making this AMAZING userbar!
 
Kentaurus
Try downloading a free spreadsheet program. Either LibreOffice or OpenOffice and see if they work. (Both can handle .xls files)
AZTECA - NBCSN pcmdaily.com/files/Micros16/azt.png
 
DaveTwoBob
I have posted a fix here
https://pcmdaily.com/forum/viewthread....d_id=33126
Hope it works for you.
Manager of Renault Classic [ICL]
Manager of Kraftwerk Man Machine [Man Game]
 
baseballlover312
Thanks so much! I'll be sure to use this whenever the problem happens again! thanks a bunch for your help! Smile
RIP Exxon Duke, David Veilleux, Double Feature, and Monster Energy
pcmdaily.com/files/Awards2016/avatar.png
pcmdaily.com/files/Awards2019/funniest.png
pcmdaily.com/images/mg/Awards2020/funniest.png
pcmdaily.com/images/mg/Awards2020/forumthread.png
i.imgur.com/VCXYUyF.png
i.imgur.com/4osUjkI.png
 
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
My Armada Team
My Armada Team
PCM13: General Screenshots
Fantasy Betting
Current bets:
No bets available.
Best gamblers:
bullet fighti... 18,776 PCM$
bullet df_Trek 17,674 PCM$
bullet Marcovdw 15,845 PCM$
bullet jseadog1 13,852 PCM$
bullet baseba... 10,539 PCM$

bullet Main Fantasy Betting page
bullet Rankings: Top 100
ManGame Betting
Current bets:
No bets available.
Best gamblers:
bullet Ollfardh 21,990 PCM$
bullet df_Trek 15,820 PCM$
bullet Marcovdw 15,300 PCM$
bullet jseadog1 13,800 PCM$
bullet baseball... 7,432 PCM$

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