I am using the following code:
Code:
local vars `"price"' `"grdef"' `"grndef"' `"grindp"'
local sheets `"_period1"' `"_period2"'
foreach variable in `"`vars'"' {
local capvar = upper("`variable'")
}
foreach sheet in `"`sheets'"' {
import excel using "Data/`capvar'`sheet'.xlsx", firstrow case(lower) clear
}
Any suggestions?
0 Response to Importing multiple excel files
Post a Comment