[R-SIG-Finance] Importing from Excel
Brian G. Peterson
brian at braverock.com
Mon Feb 4 20:36:38 CET 2008
MAB wrote:
> Eventually the easiest seems to be to make sure each column in the spreadsheet
> starts with a numeric, and replace it once the object is in R.
>
> There is probably a better way.
I tend to export to CSV files, and read.table or read.csv those into R.
That seems to be the cleanest way, and is well-supported in R.
One note is that if you have both row and column names, you need to
remove the first column from your header row in the CSV, or R gets confused.
Regards,
- Brian
More information about the R-SIG-Finance
mailing list