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*

 
 

© Dylov 2000. Written by Dylov. Original Page Designs by Dylov & Panther.