# Spreadsheet gem -- way to work with a subset of rows?

**URL:** <https://www.ruby-forum.com/t/spreadsheet-gem-way-to-work-with-a-subset-of-rows/180476>\
**Category:** Ruby\
**Created:** [December 19, 2009, 6:06pm UTC](https://www.ruby-forum.com/t/spreadsheet-gem-way-to-work-with-a-subset-of-rows/180476 "2009-12-19T18:06:48Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![jtoly](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/b9bd4f/32.png) [@jtoly](https://www.ruby-forum.com/u/jtoly)\
**Post date:** [December 19, 2009, 6:06pm UTC](https://www.ruby-forum.com/t/spreadsheet-gem-way-to-work-with-a-subset-of-rows/180476/1 "2009-12-19T18:06:48Z")

</div>

The spreadsheet I’m trying to ingest is quite large, so I tried what  
works with arrays:

sheet[1…20].each do |foo|  
.  
.  
end

But that results in an error, wrong number of arguments (1 for 2)

Has anyone else come up with a way to test a subset of rows, other than  
creating an extract file to work with?