Exporting Maps from WinOLS to Excel

Post your topic here if there is no suitable forum...

Return to Other

Exporting Maps from WinOLS to Excel

Postby rlees85 » Fri Sep 21, 2012 11:44 am

Is there any easy way to do this? I am wasting a lot of time manually entering maps into excel to calculate stuff.

When I try cutting and pasting it doesnt work, if I try to cut and paste one line at a time (from the map in text-mode) it just pastes everything in hexadecimal.

Is there a way of exporting entire maps into CSV or another format Excel will read?

Cheers!

rlees85
Gold
 
Posts: 158
Joined: Fri Apr 27, 2012 5:32 pm
Location: Macclesfield / Hinckley UK

Re: Exporting Maps from WinOLS to Excel

Postby ecuedit » Fri Sep 21, 2012 12:27 pm

Hi,
copy the map from WinOLS to notepad and than from notepad to Excel.

User avatar
ecuedit
CARPRO
 
Posts: 2221
Joined: Fri Feb 24, 2012 10:10 pm
Location: European Union

Re: Exporting Maps from WinOLS to Excel

Postby rlees85 » Fri Sep 21, 2012 12:37 pm

Thanks... although when I do this for some reason it pastes everything in notepad in hex :?

rlees85
Gold
 
Posts: 158
Joined: Fri Apr 27, 2012 5:32 pm
Location: Macclesfield / Hinckley UK

Re: Exporting Maps from WinOLS to Excel

Postby ecuedit » Fri Sep 21, 2012 1:32 pm

Be sure you open the map, look you are in decimal view.
Step on first data from left to top, press CTRL+A, then CTRL+C, be sure you have opened notepad before,
press CTRL+V to notepad and you have to get decimal values.
You do not have permissions to view the files yet. You have to be registered and you have to make at least 3 quality / unique posts.

User avatar
ecuedit
CARPRO
 
Posts: 2221
Joined: Fri Feb 24, 2012 10:10 pm
Location: European Union

Re: Exporting Maps from WinOLS to Excel

Postby rlees85 » Fri Sep 21, 2012 1:43 pm

Cheers... I'll give it another go later. What version of WinOLS are you using by the way?

rlees85
Gold
 
Posts: 158
Joined: Fri Apr 27, 2012 5:32 pm
Location: Macclesfield / Hinckley UK

Re: Exporting Maps from WinOLS to Excel

Postby Relic » Fri Sep 21, 2012 4:09 pm

EDIT > COPY ADVANCED > COPY MAP ;)
...paste away 8-)

Relic
Diamond
 
Posts: 410
Joined: Mon Aug 06, 2012 3:18 pm
Location: England

Re: Exporting Maps from WinOLS to Excel

Postby rlees85 » Fri Sep 21, 2012 8:44 pm

Yep, works a treat... cheers both! :D

Worth noting that virtual PC doesnt like passing large pieces of text to the 'host' PC by the clipboard... so have to paste into notepad within the Virtual PC and then into Excel

rlees85
Gold
 
Posts: 158
Joined: Fri Apr 27, 2012 5:32 pm
Location: Macclesfield / Hinckley UK

Re: Exporting Maps from WinOLS to Excel

Postby chainey44 » Sun Mar 17, 2013 2:21 pm

Works just great for me

chainey44
New user
 
Posts: 4
Joined: Wed Dec 12, 2012 12:11 am
Location: London

Re: Exporting Maps from WinOLS to Excel

Postby tazan88 » Thu Mar 21, 2013 8:42 am

Copy cells in winols.
and paste new document in excel.

tazan88
New user
 
Posts: 9
Joined: Wed Feb 06, 2013 1:47 pm
Location: S.Korea

Re: Exporting Maps from WinOLS to Excel

Postby kingarthas » Fri Apr 29, 2016 3:26 am

Relic wrote:EDIT > COPY ADVANCED > COPY MAP ;)
...paste away 8-)



Thanks

kingarthas
New user
 
Posts: 23
Joined: Mon Nov 12, 2012 3:00 am
Location: Bulgaria


Return to Other

Who is online

Users browsing this forum: No registered users and 2 guests