Re: [R] Multiple Data Import Excel

2022-01-04 Thread Jeff Newmiller
Reading Excel files isn't a feature of base R (the topic here... read the Posting Guide linked below) but the readxl contributed package can help with that. The read_xlsx function has arguments to skip rows, limit the number of rows read in, or specify regions to import such as B2:B2. Read the h

Re: [R] Multiple Data Import Excel

2022-01-04 Thread PIKAL Petr
t; To: r-help@r-project.org > Subject: [R] Multiple Data Import Excel > > Hello, > I have 2100 Excel files (.xlsx) that I need to read and combine into 1 file. > I am perplexed because the first 6 lines are header information and the 8th > line are the columns that are needed with th

[R] Multiple Data Import Excel

2022-01-03 Thread Bradley Heins via R-help
Hello, I have 2100 Excel files (.xlsx) that I need to read and combine into 1 file. I am perplexed because the first 6 lines are header information and the 8th line are the columns that are needed with the data in columns. I need to save the first last (IceTag ID) because that number becomes the I