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
|