read_xl question

Colleagues,

?I have a workbook which has 3 worksheets

I need to extract data from two specific cells from one ofthose worksheets.

?

I can use read_excel to do this for one file.

data<-read_excel("C:/Desktop/Excel_raw_data/0020-49785 8768.xls",

????????????????????sheet="Flow Data",range=("b9:c10"))

?

How can I do this for all my Excel files in the directory?

?

I can get the list of Excel files using: files =list.files(pattern="*.xls")

But I?m not sure where to go from here.

Some guidance would be appreciated.

?

All the best

?Thomas Subia

Thomas Subia