How to read excel from folder without specify excel name?

General
1

Hi,
Is there a way to read excel into R directly from folder without having to add the excel name?
I'm using the readxl library and I have only 1 file in the folder, but the file's name changes monthly.

Thanks!

2

List all the xlsx files :

my_xlsx_filename <-list.files(path=".",pattern="\\.xlsx$")

Created on 2021-08-04 by the reprex package (v2.0.0)
1 Like
3

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.