Search
 
SCRIPT & CODE EXAMPLE
 

RUBY

read xls file in ruby

require 'creek'

workbook = Creek::Book.new 'path/to/file.xlsx'
worksheets = workbook.sheets

worksheets.each do |worksheet|
  worksheet.rows.each do |row|
    row_cells = row.values
    # do something with row_cells
  end
end
Comment

PREVIOUS NEXT
Code Example
Ruby :: Rails validations: unique scope 
Ruby :: ruby copy file 
Ruby :: rails g migration remove default 
Ruby :: capitalize composed name ruby 
Ruby :: rails add index specifc name 
Ruby :: create_enum in rails 7 
Ruby :: rails content for head 
Ruby :: ruby version from script 
Ruby :: What does inject in ruby do 
Ruby :: ruby array shift 
Ruby :: infinite loop ruby 
Ruby :: uninstall ruby windows 
Ruby :: ruby random number between 
Ruby :: ruby loop using integer 
Ruby :: rails g controller with actions 
Ruby :: ruby on rails examples 
Ruby :: rails start id to 1000 
Ruby :: what is touch in rails 
Ruby :: rails change reference 
Ruby :: stringio original_filename 
Ruby :: self join relationship rails 
Ruby :: ruby classes 
Ruby :: add key and value to the beginning of a hash ruby 
Ruby :: ruby check if string is integer 
R :: r how to import tsv file 
R :: how to re-arrange weekdays in r 
R :: sort R 
R :: comment in r 
R :: r merge columns 
R :: describe data in r 
ADD CONTENT
Topic
Content
Source link
Name
4+5 =