Displaying 1 result from an estimated 1 matches for "myspread".
Did you mean:
misread
2003 Oct 22
2
Excel to R
...rd form of a one row header followed by
rows of data, one record per row EXCEPT that there are a few
rows of comments before the header. The number of rows of comments
varies. For Excel files of this form without comments I have had
success with:
require(RODBC)
z <- odbcConnectExcel("C:/myspread.xls")
z.df <- sqlFetch(z,"Sheet1")
close(z)
but the comments interfere with this.
I don't want to manually delete the rows but want the entire
process from Excel file to R to be automatic.
I can accomplish this with a free utility, Baird's dataload that
I found on th...