Read *.xlsx data file into R
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. You?re essentially being rewarded for a lack of preparation, so when you find yourself in a situation where you must prepare, you can?t do it. You don?t 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