Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| From | Joe Canner <jcanner1@jhmi.edu> |
| To | "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu> |
| Subject | RE: st: Import Excel: last for columns ignored |
| Date | Wed, 19 Mar 2014 17:51:35 +0000 |
Sergiy et al., One last follow-up on this and then we can put it to bed. It turns out there are several different ways in Excel to hide and unhide things. Unfortunately, these methods are somewhat hidden. :) In my case, I was able to go to Home->Format->Hide & Unhide->Unhide Sheet and that did the trick. Regards, Joe -----Original Message----- From: Joe Canner Sent: Wednesday, March 19, 2014 8:41 AM To: 'statalist@hsphsun2.harvard.edu' Subject: RE: st: Import Excel: last for columns ignored Sergiy, I have no idea what software produced the Excel files, as we received them from somewhere else. They had an .xlsx extension, so I assume MS Excel 2010 or 2013, but I can't say for sure. I used MS Excel 2010 to save the file under a new name. I also tried saving as .xls. Regards, Joe -----Original Message----- From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Sergiy Radyakin Sent: Tuesday, March 18, 2014 7:19 PM To: statalist@hsphsun2.harvard.edu Subject: Re: st: Import Excel: last for columns ignored Joe, just to have a complete picture: -- which software produced the Excel files? and -- which Excel program did you use to re-save the file? Thank you, Sergiy On Tue, Mar 18, 2014 at 11:22 AM, Joe Canner <jcanner1@jhmi.edu> wrote: > Sergiy, > > Thanks for this information. I updated my Stata to the latest version (not sure why I didn't think of that before), but I still had the same problem. I will contact Stata to inform them that perhaps their fix did not entirely "take". > > I tried to resave the Excel file, as per your advice, which didn't work, but I was able to copy and paste all of the cells to a new spreadsheet and that worked. > > Regards, > Joe > > -----Original Message----- > From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Sergiy Radyakin > Sent: Monday, March 17, 2014 11:22 AM > To: statalist@hsphsun2.harvard.edu > Subject: Re: st: Import Excel: last for columns ignored > > Joe, this is a confirmed problem with Stata 12, it used ranges data > saved in file rather then actually looking at the populated data. Some > programs do not set those ranges, hence the result. > > I have reported same to StataCorp in summer 2013 and it is reported as > fixed in the 25nov2013 update (see item #10 here: > http://www.stata.com/help.cgi?whatsnew12). > > You can resave in excel o refresh cached ranges. Gnumeric definitely > saved wrong ranges, open office AFAIK too. > > Best, Sergiy Radyakin > > On Fri, Mar 14, 2014 at 3:03 PM, Joe Canner <jcanner1@jhmi.edu> wrote: >> Dear Colleagues, >> >> I am trying to import an Excel spreadsheet into Stata 12.1. The spreadsheet has 22 columns (A-V) and 438 rows. When I try to import, the default cell range is A1:Q438 and when I try to change the "Q" to a "V" it tells me: "The right column is out of range. Choose a value between A and Q inclusive." >> >> I was able to work around this by saving the spreadsheet as a CSV, but that is not a great solution because all of the date/time variables are input as strings. Are there settings in Excel or Stata might cause this to happen? I thought I remembered a question like this previously on Statalist, but I couldn't find anything online. >> >> Thanks, >> Joe Canner >> >> >> >> * >> * 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/ > > * > * 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/ * * 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/