|
Register •
FAQ
• Search • Login
|
|
Page 1 of 1
|
[ 1 post ] |
|
Author |
Message |
Grey Gamer
Chief Warrant Officer
Joined: Sun Mar 06, 2011 12:22 am Posts: 183
|
 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!
_________________ Photons away!
|
Tue Mar 27, 2012 7:48 am |
|
 |
|
|
Page 1 of 1
|
[ 1 post ] |
|
Who is online |
Users browsing this forum: No registered users and 1 guest |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum
|
|