search for: rawspectrum

...t this package runs a little slow compared to RODBC. Since I will be processing hundreds to thousands 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 somethi...