Exporting Maps from WinOLS to Excel

by **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!

by **ecuedit** » Fri Sep 21, 2012 12:27 pm

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

by **rlees85** » Fri Sep 21, 2012 12:37 pm

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

by **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.

by **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?

by **Relic** » Fri Sep 21, 2012 4:09 pm

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

by **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