.xlsx File Examples

rubyXL

require'rubyXL'workbook=RubyXL::Parser.parse'./sample_excel_files/xlsx_500_rows.xlsx'worksheets=workbook.worksheetsputs"Found#{worksheets.count} worksheets"worksheets.eachdo |worksheet|puts"Reading:#{worksheet.sheet_name}"num_rows=0worksheet.eachdo |row|row_cells=row.cells.map{ |cell|cell.value}num_rows +=1# uncomment to print out row values# puts row_cells.join " "endputs"Read#{num_rows} rows"endputs'Done'

roo

require'roo'workbook=Roo::Spreadsheet.open'./sample_excel_files/xlsx_500_rows.xlsx'worksheets=workbook.sheetsputs"Found#{worksheets.count} worksheets"worksheets.eachdo |worksheet|puts"Reading:#{worksheet}"num_rows=0workbook.sheet(worksheet).each_row_streamingdo |row|row_cells=row.map{ |cell|cell.value}num_rows +=1# uncomment to print out row values# puts row_cells.join ' 'endputs"Read#{num_rows} rows"endputs'Done'

creek

require'creek'workbook=Creek::Book.new'./sample_excel_files/xlsx_500_rows.xlsx'worksheets=workbook.sheetsputs"Found#{worksheets.count} worksheets"worksheets.eachdo |worksheet|puts"Reading:#{worksheet.name}"num_rows=0worksheet.rows.eachdo |row|row_cells=row.valuesnum_rows +=1# uncomment to print out row values# puts row_cells.join " "endputs"Read#{num_rows} rows"endputs'Done'

simple_xlsx_reader

require'simple_xlsx_reader'workbook=SimpleXlsxReader.open'./sample_excel_files/xlsx_500000_rows.xlsx'worksheets=workbook.sheetsputs"Found#{worksheets.count} worksheets"worksheets.eachdo |worksheet|puts"Reading:#{worksheet.name}"num_rows=0worksheet.rows.eachdo |row|row_cells=rownum_rows +=1# uncomment to print out row values# puts row_cells.join ' 'endputs"Read#{num_rows} rows"endputs'Done'

Legacy.xls Files

spreadsheet

require'spreadsheet'# Note: spreadsheet only supports .xls files (not .xlsx)workbook=Spreadsheet.open'./sample_excel_files/xls_500_rows.xls'worksheets=workbook.worksheetsputs"Found#{worksheets.count} worksheets"worksheets.eachdo |worksheet|puts"Reading:#{worksheet.name}"num_rows=0worksheet.rows.eachdo |row|row_cells=row.to_a.map{ |v|v.methods.include?(:value) ?v.value :v}num_rows +=1# uncomment to print out row values# puts row_cells.join " "endputs"Read#{num_rows} rows"endputs'Done'