Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.


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

Re: st: Writing to large Excel files


From   David Epstein <david.l.epstein@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Writing to large Excel files
Date   Tue, 29 Jan 2013 16:17:44 -0500

Right, and my datasets are nowhere near that big anyway: ~1500 rows
and ~100 columns each.

As I understand it, Stata reads the entire Excel workbook into its
memory before changing it, even if I'm only changing data in one
column of one sheet. Perhaps that's where the overload is coming from,
although, again, the entire workbook is only about 60Mb big.

On Tue, Jan 29, 2013 at 3:38 PM, Friedrich Huebler <fhuebler@gmail.com> wrote:
> The statement about Excel is incorrect. The maximum worksheet size in
> Excel 2010 is 1,048,576 rows by 16,384 columns.
>
> Source: http://office.microsoft.com/en-ca/excel-help/excel-specifications-and-limits-HP010342495.aspx
>
> Friedrich
>
> On Tue, Jan 29, 2013 at 2:57 PM, Jeph Herrin <stata@spandrel.net> wrote:
>> The problem is not Stata - you are probably exceeding the limits of Excel:
>> 65,536 rows by 256 columns for Excel 2010.
>>
>>
>> You can get half way there if you write as a comma separated file, but then
>> Excel still can't open it.
>>
>> cheers,
>> Jeph
>>
>>
>>
>> On 1/29/2013 2:14 PM, David Epstein wrote:
>>>
>>> Dear Statalisters,
>>>
>>> I have a large dataset that I want to write to an Excel file, so I was
>>> excited about Stata 12's new, improved import excel/export excel
>>> features. However, the file I'm writing to is ~60Mb in size, and I
>>> keep getting an error "file testsheet.xlsx could not be loaded". This
>>> does not happen when I try to write to a smaller, or blank excel
>>> sheet, I increased Stata's memory to much more than 60Mb, and I even
>>> added the undocumented "set excelxlsxlargefile on" to my code, all to
>>> no avail.
>>>
>>> Anyone have any ideas on how to solve this? Any help appreciated.
>>>
>>> David
> *
> *   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–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index