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?