RE: st: re: import excel limits

["David Radwin" <dradwin@mprinc.com>]

Thank you for posting this solution. Too often these threads remain open.
Now Stata users who run into a similar problem in the future can benefit
from your experience. 

David
--
David Radwin
Senior Research Associate
MPR Associates, Inc.
2150 Shattuck Ave., Suite 800
Berkeley, CA 94704
Phone: 510-849-4942
Fax: 510-849-0794

www.mprinc.com


> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-
> statalist@hsphsun2.harvard.edu] On Behalf Of David Epstein
> Sent: Wednesday, January 30, 2013 1:36 PM
> To: statalist@hsphsun2.harvard.edu
> Subject: Re: st: re: import excel limits
> 
> After testing the spreadsheet in various ways this morning, I finally
> homed in on the problem, which is that the workbook contained macro
> buttons (even though the buttons weren't actually hooked up to macros,
> since I had converted the sheet from .xlsm to .xlsx). Once the buttons
> were removed, the download worked.
> 
> I'm not sure if this is a feature or a bug; I'm in contact with
> engineers at Stata, but I thought people might like to know what the
> problem was, and at the least the documentation should be updated to
> reflect this limitation.
> 
> David
> 
> 
> On Wed, Jan 30, 2013 at 7:29 AM, Christopher Baum <kit.baum@bc.edu>
wrote:
> > <>
> > Note from the help:
> >
> >     For performance, import excel imposes a size limit of 50 MB for
> Excel 2007/2010 (.xlsx) files.  Be warned that importing
> >     large .xlsx files can severely affect your machine's performance.
> >
> > Technical note:  Excel data size limits
> >
> >     For an Excel .xls-type workbook, the worksheet size limits are
> 65,536 rows by 256 columns.  The string size limit is 255
> >     characters.
> >
> >     For an Excel .xlsx-type workbook, the worksheet size limits are
> 1,048,576 rows by 16,384 columns.  The string size limit
> >     is 32,767 characters.
> >
> >
> > This suggests you might be able to read in a larger file if it was in
> .xls format, but catch-22, xls files can only have 256 columns.
> >
> > Kit
> >
> >
> > Kit Baum   |   Boston College Economics & DIW Berlin   |
> http://ideas.repec.org/e/pba1.html
> >                              An Introduction to Stata Programming  |
> http://www.stata-press.com/books/isp.html
> >   An Introduction to Modern Econometrics Using Stata  |
> http://www.stata-press.com/books/imeus.html
> >
> | http://www.crup.com.cn/Item/111779.aspx
> >
> >
> > *
> > *   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/