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
asked Nov 11 at 2:02
enriqueStateSpacias
818
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
asked Nov 11 at 2:02
enriqueStateSpacias
818
1
readxl::readxl_examplejust returns a path to a file provided in thereadxlpackage. Replacedf2016with 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
asked Nov 11 at 2:02
enriqueStateSpacias
818
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
asked Nov 11 at 2:02
enriqueStateSpacias
818
asked Nov 11 at 2:02
enriqueStateSpacias
818
asked Nov 11 at 2:02
enriqueStateSpacias
818
asked Nov 11 at 2:02
enriqueStateSpacias
818
818
1
readxl::readxl_examplejust returns a path to a file provided in thereadxlpackage. Replacedf2016with the path to your excel file.
– Eric
Nov 11 at 2:26
add a comment |
1
readxl::readxl_examplejust returns a path to a file provided in thereadxlpackage. Replacedf2016with 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)
answered Nov 11 at 2:30
CIAndrews
1616
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")
answered Nov 11 at 2:33
Prometheus
12728
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)
answered Nov 11 at 2:30
CIAndrews
1616
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)
answered Nov 11 at 2:30
CIAndrews
1616
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)
answered Nov 11 at 2:30
CIAndrews
1616
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
answered Nov 11 at 2:30
CIAndrews
1616
answered Nov 11 at 2:30
CIAndrews
1616
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")
answered Nov 11 at 2:33
Prometheus
12728
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")
answered Nov 11 at 2:33
Prometheus
12728
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")
answered Nov 11 at 2:33
Prometheus
12728
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
answered Nov 11 at 2:33
Prometheus
12728
answered Nov 11 at 2:33
Prometheus
12728
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_examplejust returns a path to a file provided in thereadxlpackage. Replacedf2016with the path to your excel file.– Eric
Nov 11 at 2:26