View Single Post
  #5  
Old August 14th, 2006, 09:25 PM
geoschmo's Avatar

geoschmo geoschmo is offline
National Security Advisor
 
Join Date: Jan 2001
Location: Ohio
Posts: 8,450
Thanks: 0
Thanked 4 Times in 1 Post
geoschmo is on a distinguished road
Default Re: How do you Generate Data Files w/ Excel?

I've done it before, it's not that hard. You can save the excel spreadsheet as a tab-delineated text file (Excel does this by default when saving as a text file), then open the text file using word or some other file editor and do a find/replace and replace all the Tab characters with spaces. You can do the same thing saving it as a .csv file and replace the commas with spaces, but some of the descriptions might have commas in them. There is no place in any SE4 data file where a Tab character belongs.

It won't look exactly like a Se4 data file, but Se4 ignores spaces for the most part and just looks for the := to know where the values begin. If yo uplay with it some you can add spaces in the appropriate places and make it line up like a regular SE4 data file
__________________
I used to be somebody but now I am somebody else
Who I'll be tomorrow is anybody's guess
Reply With Quote