Displaying 2 results from an estimated 2 matches for "excelversionmajor".
2007 Oct 23
0
Problem with R(D) Com and R within Excel
Dear R Users,
I am having trouble using R from within Excel. I've installed R(D) Com
Client and then try to open up the first sample sheet.
As Excel executes auto_open, it stops at function "ExcelVersionMajor"
and complaines that a certain type library is missing:
missing rcom 1.0 type library
It appears to be looking for this in the wrong directory:
C:\Progra~2\R\R-24~11\library\rcom\libs\rcom_srv.tlb
I am currently using R2.6.0 which is located in Program Files\R\R-2.6.0
The library it is...
2007 Aug 28
7
Excel
A common process when data is obtained in an Excel spreadsheet is to save
the spreadsheet as a .csv file then read it into R. Experienced users
might have learned to be wary of dates (as I have) but possibly have not
experienced what just happened to me. I thought I might just share it with
r-help as a cautionary tale.
I received an Excel file giving patient details. Each patient had an ID