R: Cannot Read All Worksheets in Excel
up vote
0
down vote
favorite
See below readxl::readxl_example()
that I am attempting to copy:
path <- readxl::readxl_example("datasets.xls")
lapply(readxl::excel_sheets(path), readxl::read_excel, path=path)
The above obviously works, and I'm essentially trying to recreate for my own work, below:
df2016<- readxl::read_excel("data_2016.xlsx")
lapply(readxl::excel_sheets(df2016), readxl::read_excel, df2016= df2016)
When I run my code, I return the below error:
Error: path
must be a string
r excel readxl
add a comment |
up vote
0
down vote
favorite
See below readxl::readxl_example()
that I am attempting to copy:
path <- readxl::readxl_example("datasets.xls")
lapply(readxl::excel_sheets(path), readxl::read_excel, path=path)
The above obviously works, and I'm essentially trying to recreate for my own work, below:
df2016<- readxl::read_excel("data_2016.xlsx")
lapply(readxl::excel_sheets(df2016), readxl::read_excel, df2016= df2016)
When I run my code, I return the below error:
Error: path
must be a string
r excel readxl
1
readxl::readxl_example
just returns a path to a file provided in thereadxl
package. Replacedf2016
with the path to your excel file.
– Eric
Nov 11 at 2:26
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
See below readxl::readxl_example()
that I am attempting to copy:
path <- readxl::readxl_example("datasets.xls")
lapply(readxl::excel_sheets(path), readxl::read_excel, path=path)
The above obviously works, and I'm essentially trying to recreate for my own work, below:
df2016<- readxl::read_excel("data_2016.xlsx")
lapply(readxl::excel_sheets(df2016), readxl::read_excel, df2016= df2016)
When I run my code, I return the below error:
Error: path
must be a string
r excel readxl
See below readxl::readxl_example()
that I am attempting to copy:
path <- readxl::readxl_example("datasets.xls")
lapply(readxl::excel_sheets(path), readxl::read_excel, path=path)
The above obviously works, and I'm essentially trying to recreate for my own work, below:
df2016<- readxl::read_excel("data_2016.xlsx")
lapply(readxl::excel_sheets(df2016), readxl::read_excel, df2016= df2016)
When I run my code, I return the below error:
Error: path
must be a string
r excel readxl
r excel readxl
asked Nov 11 at 2:02
enriqueStateSpacias
818
818
1
readxl::readxl_example
just returns a path to a file provided in thereadxl
package. Replacedf2016
with the path to your excel file.
– Eric
Nov 11 at 2:26
add a comment |
1
readxl::readxl_example
just returns a path to a file provided in thereadxl
package. Replacedf2016
with the path to your excel file.
– Eric
Nov 11 at 2:26
1
1
readxl::readxl_example
just returns a path to a file provided in the readxl
package. Replace df2016
with the path to your excel file.– Eric
Nov 11 at 2:26
readxl::readxl_example
just returns a path to a file provided in the readxl
package. Replace df2016
with the path to your excel file.– Eric
Nov 11 at 2:26
add a comment |
2 Answers
2
active
oldest
votes
up vote
2
down vote
accepted
Instead of reading the excel, provide the location in the lapply function. For example:
location <- "D:/data_2016.xlsx"
lapply(readxl::excel_sheets(location), readxl::read_excel, path=location)
add a comment |
up vote
0
down vote
To get two different dataframes for 2 sheets. The following code will do the jon.
import pandas as pd
excel_file_sheet1 = pd.read_excel("excel_file.xlsx", sheet_name="Sheet1")
excel_file_sheet2 = pd.read_excel("excel_file.xlsx", sheet_name="Sheet22")
add a comment |
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
2
down vote
accepted
Instead of reading the excel, provide the location in the lapply function. For example:
location <- "D:/data_2016.xlsx"
lapply(readxl::excel_sheets(location), readxl::read_excel, path=location)
add a comment |
up vote
2
down vote
accepted
Instead of reading the excel, provide the location in the lapply function. For example:
location <- "D:/data_2016.xlsx"
lapply(readxl::excel_sheets(location), readxl::read_excel, path=location)
add a comment |
up vote
2
down vote
accepted
up vote
2
down vote
accepted
Instead of reading the excel, provide the location in the lapply function. For example:
location <- "D:/data_2016.xlsx"
lapply(readxl::excel_sheets(location), readxl::read_excel, path=location)
Instead of reading the excel, provide the location in the lapply function. For example:
location <- "D:/data_2016.xlsx"
lapply(readxl::excel_sheets(location), readxl::read_excel, path=location)
answered Nov 11 at 2:30
CIAndrews
1616
1616
add a comment |
add a comment |
up vote
0
down vote
To get two different dataframes for 2 sheets. The following code will do the jon.
import pandas as pd
excel_file_sheet1 = pd.read_excel("excel_file.xlsx", sheet_name="Sheet1")
excel_file_sheet2 = pd.read_excel("excel_file.xlsx", sheet_name="Sheet22")
add a comment |
up vote
0
down vote
To get two different dataframes for 2 sheets. The following code will do the jon.
import pandas as pd
excel_file_sheet1 = pd.read_excel("excel_file.xlsx", sheet_name="Sheet1")
excel_file_sheet2 = pd.read_excel("excel_file.xlsx", sheet_name="Sheet22")
add a comment |
up vote
0
down vote
up vote
0
down vote
To get two different dataframes for 2 sheets. The following code will do the jon.
import pandas as pd
excel_file_sheet1 = pd.read_excel("excel_file.xlsx", sheet_name="Sheet1")
excel_file_sheet2 = pd.read_excel("excel_file.xlsx", sheet_name="Sheet22")
To get two different dataframes for 2 sheets. The following code will do the jon.
import pandas as pd
excel_file_sheet1 = pd.read_excel("excel_file.xlsx", sheet_name="Sheet1")
excel_file_sheet2 = pd.read_excel("excel_file.xlsx", sheet_name="Sheet22")
answered Nov 11 at 2:33
Prometheus
12728
12728
add a comment |
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53245216%2fr-cannot-read-all-worksheets-in-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
readxl::readxl_example
just returns a path to a file provided in thereadxl
package. Replacedf2016
with the path to your excel file.– Eric
Nov 11 at 2:26