# New at parsexcel

**URL:** <https://www.ruby-forum.com/t/new-at-parsexcel/145781>\
**Category:** Ruby\
**Created:** [August 13, 2008, 9:49pm UTC](https://www.ruby-forum.com/t/new-at-parsexcel/145781 "2008-08-13T21:49:08Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![joep](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/87869e/32.png) [@joep](https://www.ruby-forum.com/u/joep)\
**Post date:** [August 13, 2008, 9:49pm UTC](https://www.ruby-forum.com/t/new-at-parsexcel/145781/1 "2008-08-13T21:49:08Z")

</div>

I’m trying to use the parseexcel gem (0.5.2).  
I have an excel sheet with 2 columns & 5 rows: 1,2,3,4,5 and a,b,c,d,e

irb(main):001:0\> require ‘parseexcel’  
default formats are encoded in ISO-8859-1  
=\> true  
irb(main):002:0\> workbook = Spreadsheet::ParseExcel.parse(‘book.xls’)

=\> #\<Spreadsheet::ParseExcel::Workbook:0x2deed7c  
@formats=[#\<Spreadsheet::ParseExcel::Format:0x2de65dc @read\_dir=0,  
@font\_no=0, @encoding=“UTF-16LE”, @just\_last=false, @key\_123=false,  
@borde  
r\_diag=[0, 0, 0], @merge=false, @style=true, @align\_v=2,  
@border\_color=[0, 0, 0, 0], @hidden=false, @fmt\_idx=0, @indent=0,  
@shrink=false, @wrap=false, @border\_style=[0, 0, 0, 0], @lock=true,  
@rotate=0, @fill=[0, 64, 65], @align\_h=0\>,  
#\<Spreadsheet::ParseExcel::Format:0x2de5e34 @read\_dir=0, @font\_no=1,  
@encoding=“UTF-16LE”, @just\_last=false, @key\_123=false, @border\_diag=[0,  
0, 0  
], @merge=false, @style=true, @align\_v=2, @border\_color=[0, 0, 0, 0],  
@hidden=false, @fmt\_idx=0, @indent=0, @shrink=false, @wrap=false,  
@border\_style=[0, 0, 0, 0], @lock=true, @rotate=0, @fi  
ll=[0, 64, 65], @align\_h=0\>, #\<Spreadsheet::ParseExcel::Format:0x2de568c  
@read\_dir=0, @font\_no=1, @encoding=“UTF-16LE”, @just\_last=false,  
@key\_123=false, @border\_diag=[0, 0, 0], @merge=false  
, @style=true, @align\_v=2, @border\_color=[0, 0, 0, 0], @hidden=false,  
@fmt\_idx=0, @indent=0, @shrink=false, @wrap=false, @border\_style=[0, 0,  
0, 0], @lock=true, @rotate=0, @fill=[0, 64, 65],  
@align\_h=0\>, #\<Spreadsheet::ParseExcel::Format:0x2de4ee4 @read\_dir=0,  
@font\_no=2, @encoding=“UTF-16LE”, @just\_last=false, @key\_123=false,  
@border\_diag=[0, 0, 0], @merge=false, @style=true,  
@align\_v=2, @border\_color=[0, 0, 0, 0], @hidden=false, @fmt\_idx=0,  
@indent=0, @shrink=false, @wrap=false, @border\_style=[0, 0, 0, 0],  
@lock=true, @rotate=0, @fill=[0, 64, 65], @align\_h=0\>, #  
\<Spreadsheet::ParseExcel::Format:0x2de473c @read\_dir=0, @font\_no=2,  
@encoding=“UTF-16LE”, @just\_last=false, @key\_123=false, @border\_diag=[0,  
0, 0], @merge=false, @style=true, @align\_v=2, @bo  
rder\_color=[0, 0, 0, 0], @hidden=false, @fmt\_idx=0, @indent=0,  
@shrink=false, @wrap=false, @border\_style=[0, 0, 0, 0], @lock=true,  
@rotate=0, @fill=[0, 64, 65], @align\_h=0\>, #\<Spreadsheet:😛  
arseExcel::Format:0x2de3f94 @read\_dir=0, @font\_no=0,  
@encoding=“UTF-16LE”, @just\_last=false, @key\_123=false, @border\_diag=[0,  
0, 0], @merge=false, @style=true, @align\_v=2, @border\_color=[0,  
0, 0, 0], @hidden=false, @fmt\_idx=0, @indent=0, @shrink=false,  
@wrap=false, @border\_style=[0, 0, 0, 0], @lock=true, @rotate=0,  
@fill=[0, 64, 65], @align\_h=0\>, #\<Spreadsheet::ParseExcel::Form  
at:0x2de37ec @read\_dir=0, @font\_no=0, @encoding=“UTF-16LE”,  
@just\_last=false, @key\_123=false, @border\_diag=[0, 0, 0], @merge=false,  
@style=true, @align\_v=2, @border\_color=[0, 0, 0, 0], @hidd …

and it just goes on and on.

---

<div class="post-metadata">

**Author:** ![joep](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/j/87869e/32.png) [@joep](https://www.ruby-forum.com/u/joep)\
**Post date:** [August 14, 2008, 10:16am UTC](https://www.ruby-forum.com/t/new-at-parsexcel/145781/2 "2008-08-14T10:16:40Z")

</div>

For parsing excels I used roo:

[http://roo.rubyforge.org/](http://roo.rubyforge.org/)

Regards,  
Andrés