Skip to content

Instantly share code, notes, and snippets.

@gaga5lala
Created March 25, 2017 12:04
Show Gist options
  • Save gaga5lala/6ead2eb50fb01f069a231ad5a3025cd7 to your computer and use it in GitHub Desktop.
Save gaga5lala/6ead2eb50fb01f069a231ad5a3025cd7 to your computer and use it in GitHub Desktop.
Parse xls
# 175梯教育役服勤處所分配表
# http://maseduc.moe.gov.tw/board/upload/175%E6%A2%AF%E5%BD%99%E6%95%B4%E6%9C%8D%E5%8B%A4%E8%99%95%E6%89%80%E9%A0%90%E6%93%AC%E5%88%86%E9%85%8D%E8%A1%A8.xls
require 'spreadsheet'
workbook = Spreadsheet.open './175t.xls'
worksheets = workbook.worksheets
worksheets.each do |worksheet|
puts "Reading #{worksheet.name}"
worksheet.rows.each do |row|
puts row.to_a
end
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment