[R] read_xl question

[Thomas Subia]

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

	[[alternative HTML version deleted]]