View unanswered posts | View active topics It is currently Sat Sep 23, 2023 5:09 am



Reply to topic  [ 1 post ] 
 Exporting to Excel 
Author Message
Chief Warrant Officer

Joined: Sun Mar 06, 2011 12:22 am
Posts: 183
Unread post 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
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 1 post ] 

Who is online

Users browsing this forum: No registered users and 2 guests


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

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware.