# Count Coulmns in Excel file

**URL:** <https://www.ruby-forum.com/t/count-coulmns-in-excel-file/154831>\
**Category:** Ruby\
**Created:** [December 4, 2008, 9:45am UTC](https://www.ruby-forum.com/t/count-coulmns-in-excel-file/154831 "2008-12-04T09:45:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ganeshguna](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/858c86/32.png) [@ganeshguna](https://www.ruby-forum.com/u/ganeshguna)\
**Post date:** [December 4, 2008, 9:45am UTC](https://www.ruby-forum.com/t/count-coulmns-in-excel-file/154831/1 "2008-12-04T09:45:34Z")

</div>

Hi,  
How to count the number of columns in an excel file…  
and i am using “Spreadsheet::ParseExcel” gem to parse the excel file

if anybody knows plz reply me

advanced thanks  
Ganesh

---

<div class="post-metadata">

**Author:** ![ganeshguna](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/858c86/32.png) [@ganeshguna](https://www.ruby-forum.com/u/ganeshguna)\
**Post date:** [December 4, 2008, 2:57pm UTC](https://www.ruby-forum.com/t/count-coulmns-in-excel-file/154831/2 "2008-12-04T14:57:31Z")

</div>

I don’t know how to do this, but maybe you can find something on the  
Ruby on  
Windows blog in the articles related to Excel.

> **[Ruby on Windows](http://rubyonwindows.blogspot.com/search/label/excel)**
>
> On using the Ruby programming language on the Microsoft Windows platform

Regards,  
Craig

---

<div class="post-metadata">

**Author:** ![ganeshguna](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/858c86/32.png) [@ganeshguna](https://www.ruby-forum.com/u/ganeshguna)\
**Post date:** [December 5, 2008, 3:35pm UTC](https://www.ruby-forum.com/t/count-coulmns-in-excel-file/154831/3 "2008-12-05T15:35:08Z")

</div>

Ganesh G. wrote:

> How to count the number of columns in an excel file…  
> and i am using “Spreadsheet::ParseExcel” gem to parse the excel file

the ParseExcel-Gem is deprecated - please use its shiny new replacement:  
gem install spreadsheet

and use Worksheet#dimensions:  
[http://spreadsheet.rubyforge.org/classes/Spreadsheet/Worksheet.html#M000197](http://spreadsheet.rubyforge.org/classes/Spreadsheet/Worksheet.html#M000197)

hth

cheers  
Hannes

---

<div class="post-metadata">

**Author:** ![ganeshguna](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/g/858c86/32.png) [@ganeshguna](https://www.ruby-forum.com/u/ganeshguna)\
**Post date:** [January 11, 2009, 2:00am UTC](https://www.ruby-forum.com/t/count-coulmns-in-excel-file/154831/4 "2009-01-11T02:00:48Z")

</div>

2008/12/4 Ganesh G. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid):

> Hi,  
> How to count the number of columns in an excel file…  
> and i am using “Spreadsheet::ParseExcel” gem to parse the excel file
> 
> if anybody knows plz reply me

## in my ‘roo’ gem ([http://rubyforge.org/projects/roo/](http://rubyforge.org/projects/roo/)):

require ‘rubygems’  
require ‘roo’

## s = Excel.new(“test/numbers1.xls”) s.default\_sheet = s.sheets.first puts “first column: #{s.first\_column}” puts “last column: #{s.last\_column}” puts “number of non empty colums: #{s.last\_column-s.first\_column+1}” puts “number of colums from ‘A’ to last column: #{s.last\_column}”

-Thomas