Message-ID: <1653570142.498507.1548264892168@mail.yahoo.com>
Date: 2019-01-23T17:34:52Z
From: Thomas Subia
Subject: 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
[[alternative HTML version deleted]]