stata导出变量名和变量标签到excel

* 设置Excel文件路径和工作表
putexcel set "variables_and_labels.xlsx", replace

* 写入列标题
putexcel A1 = "Variable Name" B1 = "Variable Label", bold

* 遍历所有变量，将变量名和标签写入Excel
local rownum 2
foreach var in $science_all {
    local label : variable label `var'
    putexcel A`rownum' = "`var'" B`rownum' = "`label'"
    local ++rownum
}

* 保存Excel文件
putexcel save