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 at the end of May, and its replacement, statalist.org is already up and running.


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

Re: st: excel import issue


From   Gabi Huiber <ghuiber@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: excel import issue
Date   Fri, 4 Nov 2011 16:56:26 -0400

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/


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