Using:
Microsoft Excel
I
heartily recommend Excel. Every file you edit to make a map
is a text file, also, every value in these text files is separate
by a comma. So this means that by using the comma delimited
properties when you open up a text file in excel you will be
able to edit the file you open as you would any sheet you open
with Excel. Especially for making big sweeping changes which
could require ages of typing in number after number, Excel can
accomplish this in moments.
How
to import an entire text file into Microsoft Excel
Click
Open. In the Look in box, locate the drive,
folder, or Internet location that contains the file you want
to open. In the Files of type box, click All Files.
Double-click the file you want to import. Follow the instructions
in the Text Import Wizard to specify how you want to divide
the text into columns. You will want to separate the values
using comma here, as opposed to tab. Use this method If you
want to copy the data into Excel without maintaining a connection
to the original file, its quick, fast and useful.See below for
and easy 1-2-3 in pictures:

click
open and change "Files of Type" to "All Files
(*.*)" Select the file you want.

The
Text Import Wizard will then pop up. Select "Delimited"
then click next

Select
"Comma" and deselect "Tab" then click Finish.
And thats it.
How
to import an entire text file into a refreshable Microsoft Excel
data range.
We
Use this procedure because we will want to refresh the data
in Excel whenever the original text file changes. Working with
resourcesphere files, its always best to just have a look at
the format that excel spews out when converting back to text,
just to be sure.
Click
the cell where you want to put the data from the text file.
To ensure that the external data does not replace existing data,
make sure that the worksheet has no data below or to the right
of the cell you click. On the Data menu, point to Get
External Data, and then click Import Text File. In
the Look in list, locate and double-click the text file
you want to import as an external data range, to see all the
Homeworld files make sure you have Files of type box
switched to All Files . To specify how you want to divide
the text into columns, follow the instructions in the Text Import
Wizard, i.e. for Original Data Type you will be using
Delimited and in the next box under the Delimiters
heading tick Comma (remove the tick from Tab).
Click Finish, and then if you are so inclined click Properties
in the Import Data dialog box to set formatting and layout
options for how the external data range is brought into Microsoft
Excel.
In
the Import Data dialog box, do one of the following: To
return the data to the location you selected in step 1, click
Existing worksheet, and then click OK. To return
the data to a new worksheet, click New worksheet, and
then click OK. Microsoft Excel adds a new worksheet to
your workbook and automatically puts the external data range
in the upper-left corner of the new worksheet.
Notes:
To
refresh the external data range when the original text file
changes, click Refresh Data on the External Data toolbar.
In the Import Text File dialog box, select your text
file, and then click Import.
To
change the settings you made in the Text Import Wizard,
click Edit Text Import on the External Data toolbar.
Select your text file, click Import, and then make the
changes you want in the wizard.
How
to export an entire Microsoft
Excel worksheet into
a text file
Save
a Worksheet as a text file; Select File, Save As
and in the Save as type box select CSV (Comma
delimited (*.csv). Then, you will be able to open this *.csv
file with a text editor (such as Textpad) and just copy the
relevant lines directly into your ResourceSphere_#.missphere
file. Saving in .csv format will save your data in text
exactly as required by Homeworld, its a simple matter of copying
and pasting what you want into your existing resourcesphere
file, or saving the whole shebang making sure you named it correctly,
it will work as long as its named in the Level file.
[Top]
[Primer Main]
[Appendix
B Main]
[Tutorial
Main]
*Use the back button on your browser to return to the page you
came from*
|