Displaying 1 result from an estimated 1 matches for "editspectrum".
2010 Nov 01
0
RODBC - odbcConnectExcel2007 headers issue
...ands of files, I would like a faster
option. RODBC seems to be it, but I am having trouble telling it not to
take the first row of "data" as a header/column name.
Here is my present command
rawspectrum <- odbcConnectExcel2007("directory path/filename.xlsx", readOnly
= TRUE)
editspectrum <- sqlFetch(rawspectrum,"Sheet1", as.is=TRUE, colnames = FALSE,
rownames = FALSE, nullstring="")
odbcClose(rawspectrum)
If I ran this on the above fake data I would get something like:
Subject , 01 ,F1 ,F2 ,F3
1 wavelength, 400
2 10 , 11 ,23...