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:
[code]asdocx tab A7_OrgStruct2 if A7_OrgState == “`state'”, ///
font(Arial) title(Frequency of Organization Types) save(`state’.xlsx) replace[/code]

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:
[code]putexcel set `state’.xlsx, sheet(Services) modify[/code]

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:
[code]asdocx_update

sysuse auto

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

[/code]

[Author]

Posts