how to use rubyxl to access the first row

workbook = RubyXL::Parser.parse(params[:file].path)
worksheet = workbook[0]
puts worksheet.sheet_data[0][0]

But I am getting this as output

<RubyXL::Cell(0,0): "0", datatype="s", style_index=1>

My excel sheet is of this form

 name coupon gates gates1234 jobs jobs1234

I want to access rows one by one .. any help will be appreciated.

I also made a sample app for this post, if you want to run it ..

3 Answers

worksheet.sheet_data[0]

gives you a Ruby object representing the first row.

worksheet.sheet_data[0][0]

gives you a Ruby object representing the first cell on the first row. But to get the actual contents of that cell, you need

worksheet.sheet_data[0][0].value

The worksheet is organised as an array of cells. You have to deal with the cells one by one in each row, if you are processing the rows sequentially.

worksheet[0].cells.map(&:value) work for me

I was trying worksheet.extract_data[0] but extract_data is no longer available in RubyXL (I use v.3.3.3)!

worksheet.extract_data

give you entire sheet rows

worksheet.extract_data[0]

give you the first row