How can I export both variable label and variable name to excel from stata

[Abdul Habib Yousufzai]

Hi everyone,
I would like to export both variable label and variable name with data to excel from stata but I cannot, could you please kindly help me?

[William Lisowski]

The following example may start you in a useful direction.

sysuse auto, clear
export excel make price using cars.xlsx, replace sheet("auto") cell(a1) firstrow(varlabels)
export excel make price using cars.xlsx, sheet("auto", modify) cell(a2) firstrow(variables)

[Abdul Habib Yousufzai]

Dear William Lisowski,
Thank you so much for your great help.