Re: st: excel import issue

[Gabi Huiber <ghuiber@gmail.com>]

I am having the exact same problem with the latest Stata 12. I get the
r(603) error both on a 64-bit Win 7 machine and on a Mac OS X Lion. I
am trying to open .xls (Excel 97-2003) files. On the Mac, they all
have the permissions set to 777. On the PC, I am running Stata as an
administrator.

The files open fine with Office 2010, and as far as I can tell there's
no strange formatting present in the cell range of interest to me. If
anybody has advice, I'm next in line after Dimitriy.

Thank you,
Gabi

On Tue, Nov 1, 2011 at 3:23 PM, Dimitriy V. Masterov <dvmaster@gmail.com> wrote:
>
> I am using Stata 12 MP on a 64-bit Windows 7 machine. Current update
> level is 13 Oct 2011.  I've been trying to load a series of Excel
> files, but I am running into a problem I can't figure out. For
> example:
>
> import excel using "Top 30 Market Data with TUSA EBITDA 10-25-11.xlsx", sheet("
> > summary") allstring firstrow cellrange(A4:AI35) clear;
> file Top 30 Market Data with TUSA EBITDA 10-25-11.xlsx could not be loaded
> r(603);
>
> Doing this through the dialog menu gives "Mandatory Element Missing"
> error when I try to specify the Excel file to use.
>
> Taking the spaces and hyphens out of the file name does not fix
> things. There's some stupid formatting, but the cell range I am trying
> to import appears to be free from it.
>
> Does anyone have any idea how to hack this one?
>
> DVM
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/statalist/faq
> *   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/