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
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 |