I have just recently been struggling with this myself. It seems a lot depends on how the xlsx file was structured by its creator. As you know, Excel does many things behind the scenes "for your convenience."
I had some success with the openxlsx package. --Chris Christopher W. Ryan, MD, MS cryanatbinghamtondotedu Medical Director, Broome County Health Department https://www.linkedin.com/in/ryancw Early success is a terrible teacher. Youre essentially being rewarded for a lack of preparation, so when you find yourself in a situation where you must prepare, you cant do it. You dont know how. --Chris Hadfield, An Astronaut's Guide to Life on Earth Steven Stoline wrote: > Dear All: > > I am having trouble reading an *.xlsx data file into R. > > I tried to install the packages XLSX and readx1, but still did not work. > > Any helps will be appreciated. > > with many thanks > sreve > _______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-sig-teaching
