使用Ruby解析XLS和XLSX(MS Excel)文件？

gem install rubyXL

require 'rubyXL'

workbook = RubyXL::Parser.parse('example.xlsx')
sheet = workbook[0]

sheet.each_with_index do |row, row_index|
  row.each_with_index do |cell, cell_index|
    puts "Row #{row_index}, Cell #{cell_index}: #{cell.value}"
  end
end

gem install roo

require 'roo'

# 解析XLS文件
xls = Roo::Excel.new('example.xls')

# 解析XLSX文件
xlsx = Roo::Excelx.new('example.xlsx')

# 读取数据
xls.each_row_streaming do |row|
  puts row.map(&:value).join(', ')
end

xlsx.each_row_streaming do |row|
  puts row.map(&:value).join(', ')
end