Search this site
Embedded Files
Skip to main content
Skip to navigation
TIPS on Latex, Matlab and R
Home of tricks
Latex
Affiliations
Counters
Margine notes
Report - format
Table tricks
Time on title page
LaTeXiT
Matlab
'Scharffiert' i.e. hatched between functions
3d plots
do something to every cell in cell array
line count in text file
mixing strings and numbers in array
one liners
pick lines in text file
terminate conditional or for-loop
R
Boxplot & stripchart
Excel data import - 'gdata' package
overlapping histograms (ggplot2)
Sorting data matrix
geom_vertical
subversion & eclipse
TIPS on Latex, Matlab and R
Excel data import - 'gdata' package
Install PERL on your computer then use the
read.xls
function in the
gdata
package (PERL in called by
gdata
functions).
Use the
read.xls
function in the
gdata
package to access the data in the Excel file.
run
library(gdata).
(WINDOWS ) run
stuff = read.xls("C:\\Projects\\blah.xls")
(MAC/LINUX) run
stuff = read.xls('/Users/NN/your_excel_file.xls')
Based on:
http://lane.stanford.edu/howto/index.html?id=3672
(accessed on 8 May 2011)
Google Sites
Report abuse
Page details
Page updated
Google Sites
Report abuse