Reading an excel file
Don't! Well, I know that being a wiseguy is not helpful, but this "advice" is actually not entirely unhelpful. Search on "input Excel file" or similar on rseek.org to bring up many links, including the readxl package, tutorials, the R data import/export manual, etc. However, excel files are notoriously "unstructured," and you would probably be better off converting your data in tabular form to a .csv or .txt file and reading in from there (using read.table, read.csv, etc.) . The linked references (and advice from others with more experience) should be consulted for details. Cheers, Bert Bert Gunter "The trouble with having an open mind is that people keep coming along and sticking things into it." -- Opus (aka Berkeley Breathed in his "Bloom County" comic strip ) On Thu, Jan 10, 2019 at 1:40 PM Bernard Comcast <
mcgarvey.bernard at comcast.net> wrote:
What is the best way to read in data of any type from an Excel 2016 .xlsx file? Thanks Bernard Sent from my iPhone so please excuse the spelling!"
______________________________________________ R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.