Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • dtable excel export error

    With the following, I'm able to export a dtable as a .docx without problem.

    Code:
    dtable i.rec_female i.rec_agegroup i.rec_bodypart i.rec_disp i.rec_transport, ///
      by(rec_selfharmgun, missing nototals) ///
      svy ///
      sample(, statistic(frequency percent)) ///
      factor(, statistics(fvrawfrequency fvpercent)) ///
      halign(center) ///
      export(tables/table01.docx, replace)
    However, changing the export command to
    Code:
    export(tables/table01.xlsx, replace)
    or
    Code:
    export(tables/table01.xls, replace)
    both fail with an error: "file handle not found".

    Any ideas on how to get the table to export to an excel file?

  • #2
    I'm having trouble reproducing this behavior. Could you post an example with that the reproduces this error?

    Comment


    • #3
      Apologies - I went to reproduce the error today and it seems to have resolved itself. I'm not sure what changed! (Maybe a computer restart fixed it?)

      Comment

      Working...
      X