|
POPTOOLS is an add-in for Excel made by Greg Hood. It can be downloaded from:
http://www.cse.csiro.au/poptools/
After downloading the set-up file, double-click (but firstly close Excel) the setup file in the windows explorer. Follow the installation procedure, which will finish by starting Excel, loading in the add-in into Excel and a spreadsheet with explanation.
In Excel an extra menu appears: "PopTools". The add-in contains a lot of interesting stuff meant for Ecology but also very useful for simulation and statistics.
A new function is the possibility to transfer a range of Excel data into a data-frame for R. The transfer is done via the Clipboard.
In Excel: start the R dataframe by:
The range of data should be legal for R and not contain any characters which give trouble to R.
(No blank, no underscore in a header, however a point is allowed)
Fill in the form with named columns and give the dataframe a name. This data.frame name will be used in R. Click "Go".
Names should be legal as names in R.
The copy to clipboard is confirmed. Next step is to collect the data into R; by Edit/Paste and you will get a data.frame with the name as given in the previous step.
Now OxygenData is available as a dataframe for R.
| Up |
28 October 2003 by Guido Wyseure