| www.ClassicTW.com https://mail.black-squirrel.com/ |
|
| Exporting to Excel https://mail.black-squirrel.com/viewtopic.php?f=15&t=33126 |
Page 1 of 1 |
| Author: | Grey Gamer [ Tue Mar 27, 2012 7:48 am ] |
| Post subject: | Exporting to Excel |
Hey guys! I hope that you are well. I imagine that there are already public scripts, but I wanted to view my planet list in Excel with each planet's data on one line. I copied my planet list to Notepad and wrote this totally awesome script to combine the lines: setVar $read_file zAllPlanets.txt setVar $write_file zSpreadsheet.doc # load planet list if ($read_file <> "") fileExists $exists $read_file if ($exists) delete zSpreadsheet.txt setVar $i 1 while ($planet2 <> EOF) read $read_file $planet1 $i add $i 1 read $read_file $planet2 $i add $i 1 setVar $planet3 $planet1 & " " & $planet2 echo "*" $planet3 "*" write $write_file $planet3 end end end halt I use Word to search and replace so that it is readable in Excel. I believe that I can figure out how to do all of that with my script, but first I need to figure out why it sometimes stops early. I would appreciate any help you guys could give me! |
|
| Page 1 of 1 | All times are UTC - 5 hours |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|