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, statalist.org is already up and running.


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

Re: st: Trouble importing an Excel spreadsheet when the desired sheet is not the first sheet


From   Steve Nakoneshny <scnakone@ucalgary.ca>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   Re: st: Trouble importing an Excel spreadsheet when the desired sheet is not the first sheet
Date   Wed, 31 Oct 2012 13:12:00 -0600

Aaron,

I'm running Stata 12.1 on Mac 10.6.8. I was unable to reproduce this error. As a stab in the dark, is the Excel sheet stored in your working directory? You may want to make absolutely certain by including the full path in the filename.

Steve

On 2012-10-31, at 12:59 PM, Aaron Kirkman wrote:

> Dear Statalist,
> 
> I'm using Stata 12.1 with the 22 Oct 2012 revision on Windows 7 x64. I
> need to import data from an excel spreadsheet where the desired sheet
> is not the first sheet, but the --import excel-- command returns an
> r(601) error of "Sheet not found."
> 
> The spreadsheet contains data from the Workforce Investment Act, found
> at this link:
> 
> http://www.doleta.gov/budget/docs/110630_wia_spendsum_bypgm_asof_120209_out.xls
> 
> The sheet I need is titled "DW_Sum". I ran this command:
> 
> ****
> import excel "110630_wia_spendsum_bypgm_asof_120209_out.xls",
> sheet("DW_Sum") clear
> ****
> 
> but I get the r(601) error. If I open Excel and move the DW_Sum sheet
> to a position as the first sheet, the above command works. The same
> command also works if I remove the --sheet-- option all together
> (assuming I've moved DW_Sum to be the first sheet).
> 
> Can anyone reproduce this error? In other spreadsheets from the site,
> i.e. this one:
> 
> http://www.doleta.gov/budget/docs/101231_WIA_SpendSum_byPgm_asof_110603_OUT.xls
> 
> I do not have this problem, so I assume this is a problem with this
> specific spreadsheet, but I want to make sure.
> 
> Thank you,
> Aaron
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/faqs/resources/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/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/


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