Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, is already up and running.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: RE: How do I import a macro-enabled Excel worksheet into Stata 12?

From   "Radwin, David" <>
To   <>
Subject   st: RE: How do I import a macro-enabled Excel worksheet into Stata 12?
Date   Fri, 28 Jun 2013 17:19:22 -0400


The manual specifically mentions only .XLS and .XLSX files:

    import excel loads an Excel file, also known as a workbook, into
Stata.  import
    excel filename, describe lists available sheets and ranges of an
Excel file.
    export excel saves data in memory to an Excel file.  Excel 1997/2003
(.xls) files
    and Excel 2007/2010 (.xlsx) files can be imported, exported, and
described using
    import excel, export excel, and import excel, describe.

So it appears Stata does not support importing .XLSM files. I tried it
in Stata 12.1 for Windows just to see and it didn't work for me, either.

David Radwin
Senior Research Associate
Education Studies Division
RTI International
2150 Shattuck Ave., Suite 800
Berkeley, CA 94704
Phone: 510-665-8274

> -----Original Message-----
> From: [mailto:owner-
>] On Behalf Of John Bensin
> Sent: Friday, June 28, 2013 1:25 PM
> To:
> Subject: st: How do I import a macro-enabled Excel worksheet into
> 12?
> I have an Excel 2010 worksheet that's saved as a macro-enabled
> worksheet (.xlsm). When I attempt to import it into Stata 12 with this
> command:
> import excel "finances.xlsm", sheet("Budget") firstrow clear
> it returns an r(603) error of "file finances.xlsm could not be
> loaded". The documentation describes the error with:
> "This file, although found, failed to open properly.  This
> error is unlikely to occur.  You will have to review your
> operating system's manual to determine why it occurred."
> Does Stata 12 not support .xlsm files, or is there another problem at
> work here? I use a fully updated Stata 12 on Windows 7 64-bit, with
> Excel 2010.
> John

*   For searches and help try:

© Copyright 1996–2016 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index