New at parsexcel

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::stuck_out_tongue:
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.

For parsing excels I used roo:

http://roo.rubyforge.org/

Regards,
Andrés

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs