Specify Sheet name when exporting to Excel with asdocx in Stata

[Robert Graham]

#17681

I continue to use ASDOCX and it is a useful add-on. There are two minor things:
I have tried using the font() option and it never seems to work when exporting to Excel. I always end up with Garamond. Here is the latest example:

asdocx tab A7_OrgStruct2 if A7_OrgState == "`state'", ///
font(Arial) title(Frequency of Organization Types) save(`state'.xlsx) replace

Any suggestions?
It would be helpful if I could specify the sheet name on output from ASDOCX. For an example, here is the putexcel command from Stata:

putexcel set `state'.xlsx, sheet(Services) modify

Is there a way to do this through ASDOCX?

[Attaullah Shah]

#17684

I have fixed the issue with fonts and sheet name. Please note that you can specify sheet name using the option `sheet()’. See the following example:

asdocx_update

sysuse auto

asdocx sum, save(a.xlsx) replace sheet(Sheet 3) font(Arial)

[Author]

Posts