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 <[email protected]>
To
[email protected]
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 <[email protected]> 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 <[email protected]> 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/