发帖
雷达卡
Larwence 发表于 2014-8-18 16:13
为什么我改写成这样，想转换excel格式的文件，却只能转化成一条记录，帮我看看谢谢！
cd E:wind2007\hez ...
- cd "d:\temp\"
- dir datae*.xlsx
- local filelist: dir . files "datae*.xlsx"
- foreach file of local filelist {
- import excel using `file', firstrow clear
- saveold `file'.dta,replace
- }
- dir datae*
- . cd "d:\temp\"
- d:\temp
- . dir datae*.xlsx
- 10.9k 2/16/14 13:27 datae1.xlsx
- 10.9k 2/16/14 13:27 datae2.xlsx
- 10.9k 2/16/14 13:27 datae3.xlsx
- 10.9k 2/16/14 13:27 datae4.xlsx
- .
- . local filelist: dir . files "datae*.xlsx"
- . foreach file of local filelist {
- 2. import excel using `file', firstrow clear
- 3. saveold `file'.dta,replace
- 4. }
- file datae1.xlsx.dta saved
- file datae2.xlsx.dta saved
- file datae3.xlsx.dta saved
- file datae4.xlsx.dta saved
- .
- . dir datae*
- 10.9k 2/16/14 13:27 datae1.xlsx
- 0.6k 8/19/14 9:27 datae1.xlsx.dta
- 10.9k 2/16/14 13:27 datae2.xlsx
- 0.6k 8/19/14 9:27 datae2.xlsx.dta
- 10.9k 2/16/14 13:27 datae3.xlsx
- 0.6k 8/19/14 9:27 datae3.xlsx.dta
- 10.9k 2/16/14 13:27 datae4.xlsx
- 0.6k 8/19/14 9:27 datae4.xlsx.dta
显身卡
京公网安备 11010802022788号
