Hi, how can I upload to stata an excel file(from mac) with multiple sheets?
Thanks in advance,
Thanks in advance,
import excel using file.xls, describe forvalues sheet=1/`=r(N_worksheet)' { local sheetname=r(worksheet_`sheet') import excel using file_xls, sheet("`sheetname'") save "file_`sheetname'", replace }
cd directoy_containing_xls_files xls2dta ,allsheets
import excel using file.xls, describe forvalues sheet=1/`=r(N_worksheet)' { local sheetname=r(worksheet_`sheet') import excel using file_xls, sheet("`sheetname'") save "file_`sheetname'", replace clear }
clear cd "G:\revenue\dt\Oct 2011-Dec 2011" import excel "firm_100" foreach sheet in "ANNEX1" "ANNEX3" "ANNEX5" { import excel using "firm_100", sheet("`sheet'"), cellrange(A3:C22) save file_`sheet', replace }
foreach sheet in "ANNEX1" "ANNEX2" "ANNEX3" { import excel "firm_100", sheet(`sheet') cellrange(A3:C22) clear tempfile `sheet' save ``sheet'' }
use `ANNEX1', clear merge 1:1 varlist using `ANNEX2', nogen merge 1:1 varlist using `ANNEX3', nogen
use `ANNEX1', clear append using `ANNEX2' append using `ANNEX3'
use `ANNEX1', clear merge 1:1 varlist using `ANNEX3', nogen merge 1:1 varlist using `ANNEX5', nogen
foreach sheet in "ANNEX1" "ANNEX2" "ANNEX3" { import excel "firm_100", sheet(`sheet') cellrange(A3:C22) clear gen id = _n tempfile `sheet' save ``sheet'' } use `ANNEX1', clear merge 1:1 id using `ANNEX2', nogen merge 1:1 id using `ANNEX3', nogen
foreach k in 1 2 5 { import excel "firm_100", sheet(ANNEX`k') cellrange(A3:C22) firstrow clear if `k'==5 { keep firm var3 } else { keep firm var`k' } tempfile Sheet`k' save `Sheet`k'' } use `Sheet1', clear merge 1:1 firm using `Sheet2', nogen merge 1:1 firm using `Sheet5', nogen
foreach sheet in "sheet 1" "sheet 2" "sheet 3" { import excel "C:\Users\survey_data_02092022.xlsx", sheet(`sheet') firstrow clear tempfile `sheet' save ``sheet'' } use `sheet 1', clear merge 1:1 SURVEY_ID using `sheet 2', nogen merge 1:1 SURVEY_ID using `sheet 3', nogen
Comment