asdocx: Export from Stata to Word, Excel, LaTeX & HTML Forums asdocx Forum Specify Sheet name when exporting to Excel with asdocx in Stata

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • Robert Graham
    Post count: 1

    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
    Post count: 70

    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:

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

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.