# MaxSizeError on spreadsheet-excel olewriter

**URL:** <https://www.ruby-forum.com/t/maxsizeerror-on-spreadsheet-excel-olewriter/116887>\
**Category:** Ruby\
**Created:** [October 10, 2007, 8:16pm UTC](https://www.ruby-forum.com/t/maxsizeerror-on-spreadsheet-excel-olewriter/116887 "2007-10-10T20:16:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dbf](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/7feea3/32.png) [@dbf](https://www.ruby-forum.com/u/dbf)\
**Post date:** [October 10, 2007, 8:16pm UTC](https://www.ruby-forum.com/t/maxsizeerror-on-spreadsheet-excel-olewriter/116887/1 "2007-10-10T20:16:56Z")

</div>

I am making an excel file with spreadsheet-excel 0.3.5.1. Getting a  
MaxSizeError in set\_size (olewriter.rb line 65) when generating a large  
file. Does anyone know what causes this? The docs refer to a former bug  
in the max size of the data in a cell. But I don’t think that is the  
case in this situation. Any help is appreciated.

Thanks,

Dan

---

<div class="post-metadata">

**Author:** ![dbf](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/7feea3/32.png) [@dbf](https://www.ruby-forum.com/u/dbf)\
**Post date:** [October 11, 2007, 1:51pm UTC](https://www.ruby-forum.com/t/maxsizeerror-on-spreadsheet-excel-olewriter/116887/2 "2007-10-11T13:51:12Z")

</div>

On Oct 10, 12:16 pm, Dan F. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> I am making an excel file with spreadsheet-excel 0.3.5.1. Getting a  
> MaxSizeError in set\_size (olewriter.rb line 65) when generating a large  
> file. Does anyone know what causes this? The docs refer to a former bug  
> in the max size of the data in a cell. But I don’t think that is the  
> case in this situation. Any help is appreciated.

You can’t create a spreadsheet larger than 7mb currently (iirc),  
unless Hannes has changed something since I last worked on it.

Regards,

Dan

---

<div class="post-metadata">

**Author:** ![dbf](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/7feea3/32.png) [@dbf](https://www.ruby-forum.com/u/dbf)\
**Post date:** [October 12, 2007, 4:00am UTC](https://www.ruby-forum.com/t/maxsizeerror-on-spreadsheet-excel-olewriter/116887/3 "2007-10-12T04:00:37Z")

</div>

Daniel B. wrote:

> unless Hannes has changed something since I last worked on it.
> 
> Regards,
> 
> Dan

Hi Daniel,

Thanks for the info.

Dan

Dan F.  
ePark Labs - [www.eparklabs.com](http://www.eparklabs.com)  
removed\_email\_address@domain.invalid +1 800 331-3133 x411