Ruby:解析Excel 95-2003文件?

我正在使用 spreadsheet

还有roo: http://roo.rubyforge.org/

spreadsheet roo 但是,roo可以支持电子表格无法支持的.xlsx格式。

正如khell提到的,电子表格是一个很好的工具。请参阅下面我用来构建爬虫的代码。

require 'find'
require 'spreadsheet'
Spreadsheet.client_encoding = 'UTF-8'

count = 0

Find.find('/Users/toor/crawler/') do |file|             # begin iteration of each file of a specified directory
  if file =~ /\b.xls$\b/                                # check if a given file is xls format
    workbook =  Spreadsheet.open(file).worksheets       # creates an object containing all worksheets of an excel workbook
    workbook.each do |worksheet|                        # begin iteration over each worksheet
      worksheet.each do |row|                           # begin iteration over each row of a worksheet
        if row.to_s =~ /regex/                          # rows must be converted to strings in order to match the regex
          puts file
          count += 1
        end
      end
    end
  end
end

puts "#{count} pieces of information were found"

我以前没有尝试过解析Excel文件,但我知道FasterCSV是一个解析CSV文件(Excel可以生成)的好库。

看一下 http://rubyonwindows.blogspot.com/search/label/excel