Importing data from spreadsheets by WCanoImp
- Open the file C:\Canoco\Samples\dune_env.xls in the Microsoft Excel program. You may use instead any other spreadsheet package that is able to read Excel 3 formats. If you do not have any spreadsheet software, proceed to Specifying the ordination and use the file C:\Canoco\Samples\duneenv.dta, where the file C:\Canoco\Samples\duneenv2.dta is referred.
- In your spreadsheet, select the whole data rectangle, including the first row (containing names of variables) and the first column (containing names of the samples) and copy the data to Windows Clipboard (using the Edit/Copy menu command in Microsoft Excel, for example).
- Locate the WCanoImp item in the Canoco for Windows submenu in the Start / Programs menu (snapshot).
Locating the WCanoImp module
- After selecting the WCanoImp item the program is started. In this demo we chose to save the data in Condensed format. (Condensed format can save file space if the data contain many zero values, as is common in species data.) Therefore, check the corresponding option, as illustrated in the snapshot below and then click the Save button.
Importing data from Excel using WcanoImp
- A file selection box appears. Navigate to the C:\Canoco\Samples directory and type into the file name field the name: duneenv2.dta - do not type duneenv.dta, because that file already exists and would be overwritten (if you would confirm this). Click the Save button now.
- Next a small box appears where you can enter a short line of text (up to 80 characters) identifying the data file. The default text (saying that the file was produced by WCanoImp) is highlighted, so you can replace it directly by typing your own text.
- Click the OK button. A box appears saying that your file was successfully created. After clicking the OK button again, you are back in the WCanoImp window. Click the Exit button this time.
|