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

[Steve Nakoneshny <scnakone@ucalgary.ca>]

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/