fs *.xls
foreach file in `r(files)' {
import excel using '`file'', describe
forvalues s = 1/`r(N_worksheet)' {
import excel using '`file'', ///
sheet(`r(worksheet_`s')') ///
cellrange(`r(range_`s')') ///
firstrow clear
save newstata`s'.dta, replace
}
clear
forvalues s = 1/`r(N_worksheet)' {
append usingnewstata`s'.dta
}
save '`file'_all.dta',replace
}
但是运行结果说invalid 'trd_dalyr.xls'
r(198);
请教各位大神,这是文件名的问题吗