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]

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


From   Aaron Kirkman <ak1795mailserv@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: Trouble importing an Excel spreadsheet when the desired sheet is not the first sheet
Date   Wed, 31 Oct 2012 13:59:18 -0500

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/


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