Howto iterate over columns

[computerlyrik]

Hi, i am parsing a xls-File.

How do i walk over the existing file columnwise?

worksheet.columns => []

Thank you!

[computerlyrik]

Goal is to have something like

worksheet.columns.each do |column|
  #do some freaky stuff with column and then:
  column.each_with_index do |cellvalue, rowindex|
   logger.debug "On Row #{rowindex} ; Value #{cellvalue}
  end
end

[zdavatz]

Google and read the guide: https://github.com/zdavatz/spreadsheet/blob/master/GUIDE.md

[computerlyrik]

Thank you, i did the RFTM-Work already.

I asked for a hint to the solution.

Tnx

Am 23.08.2015 um 18:46 schrieb Zeno R.R. Davatz:

Google and read the guide: https://github.com/zdavatz/spreadsheet/blob/master/GUIDE.md

— Reply to this email directly or view it on GitHub https://github.com/zdavatz/spreadsheet/issues/142#issuecomment-133877876.