blocks|key|977503|text|我刚找到了roo，这可能会满足我的需求，读一个基本的电子表格。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|977504|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/Empact/roo^0|5|3|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Just found <a href="https://github.com/Empact/roo" rel="noreferrer">roo</a>, that might do the job - works for my requirements, reading a basic spreadsheet.

blocks|key|1191819|text|XLSX+gem可以很好地解析rubyXL文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1191820|entityMap|0|LINK|mutability|MUTABLE|url|http://github.com/gilt/rubyXL^0|F|6|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

The <a href="http://github.com/gilt/rubyXL" rel="nofollow">rubyXL</a> gem parses XLSX files beautifully.

blocks|key|1191841|text|Excel适用于roo+(.xls和.xlsx)，并且正在积极开发中。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1191842|我同意它的语法不是很好，也不像ruby。但这可以很容易地实现，例如：|1191843|class+Spreadsheet
++def+initialize(file_path)
++++@xls+=+Roo::Spreadsheet.open(file_path)
++end

++def+each_sheet
++++@xls.sheets.each+do+%7Csheet%7C
++++++@xls.default_sheet+=+sheet
++++++yield+sheet
++++end
++end

++def+each_row
++++0.upto(@xls.last_row)+do+%7Cindex%7C
++++++yield+@xls.row(index)
++++end
++end

++def+each_column
++++0.upto(@xls.last_column)+do+%7Cindex%7C
++++++yield+@xls.column(index)
++++end
++end
end|code-block|syntax|javascript|1191844|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/Empact/roo^0|8|3|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@]|C|$I|J]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]]]

The <a href="https://github.com/Empact/roo" rel="noreferrer">roo</a> gem works great for Excel (.xls and .xlsx) and it's being actively developed.

I agree the syntax is not great nor ruby-like. But that can be easily achieved with something like:

<pre><code>class Spreadsheet
 def initialize(file_path)
 @xls = Roo::Spreadsheet.open(file_path)
 end

 def each_sheet
 @xls.sheets.each do |sheet|
 @xls.default_sheet = sheet
 yield sheet
 end
 end

 def each_row
 0.upto(@xls.last_row) do |index|
 yield @xls.row(index)
 end
 end

 def each_column
 0.upto(@xls.last_column) do |index|
 yield @xls.column(index)
 end
 end
end
</code></pre>

blocks|key|1192019|text|我找不到令人满意的xlsx解析器。RubyXL不做日期类型转换，Roo试图将数字类型转换为日期，两者在应用编程接口和代码中都是一团糟。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1192020|所以，我写了simple_xlsx_reader。但是，对于xls，您必须使用其他东西，所以它可能不是您正在寻找的完整答案。|offset|length|1192021|entityMap|0|LINK|mutability|MUTABLE|url|https://rubygems.org/gems/simple_xlsx_reader^0|0|6|I|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

I couldn't find a satisfactory xlsx parser. RubyXL doesn't do date typecasting, Roo tried to typecast a number as a date, and both are a mess both in api and code.

So, I wrote <a href="https://rubygems.org/gems/simple_xlsx_reader" rel="nofollow">simple_xlsx_reader</a>. You'd have to use something else for xls, though, so maybe it's not the full answer you're looking for.

blocks|key|1192099|text|RemoteTable+library在内部使用roo。它使得读取不同格式的电子表格(XLS、XLSX、CSV等)变得很容易，可能是远程的，可能存储在zip、gz等文件中：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1192100|require+'remote_table'
r+=+RemoteTable.new+'http://www.fueleconomy.gov/FEG/epadata/02data.zip',+:filename+=>+'guide_jan28.xls'
r.each+do+%7Crow%7C
++puts+row.inspect
end|code-block|syntax|javascript|1192101|输出：|1192102|{"Class"=>"TWO+SEATERS",+"Manufacturer"=>"ACURA",+"carline+name"=>"NSX",+"displ"=>"3.0",+"cyl"=>"6.0",+"trans"=>"Auto(S4)",+"drv"=>"R",+"bidx"=>"60.0",+"cty"=>"17.0",+"hwy"=>"24.0",+"cmb"=>"20.0",+"ucty"=>"19.1342",+"uhwy"=>"30.2",+"ucmb"=>"22.9121",+"fl"=>"P",+"G"=>"",+"T"=>"",+"S"=>"",+"2pv"=>"",+"2lv"=>"",+"4pv"=>"",+"4lv"=>"",+"hpv"=>"",+"hlv"=>"",+"fcost"=>"1238.0",+"eng+dscr"=>"DOHC-VTEC",+"trans+dscr"=>"2MODE",+"vpc"=>"4.0",+"cls"=>"1.0"}
{"Class"=>"TWO+SEATERS",+"Manufacturer"=>"ACURA",+"carline+name"=>"NSX",+"displ"=>"3.2",+"cyl"=>"6.0",+"trans"=>"Manual(M6)",+"drv"=>"R",+"bidx"=>"65.0",+"cty"=>"17.0",+"hwy"=>"24.0",+"cmb"=>"19.0",+"ucty"=>"18.7",+"uhwy"=>"30.4",+"ucmb"=>"22.6171",+"fl"=>"P",+"G"=>"",+"T"=>"",+"S"=>"",+"2pv"=>"",+"2lv"=>"",+"4pv"=>"",+"4lv"=>"",+"hpv"=>"",+"hlv"=>"",+"fcost"=>"1302.0",+"eng+dscr"=>"DOHC-VTEC",+"trans+dscr"=>"",+"vpc"=>"4.0",+"cls"=>"1.0"}
{"Class"=>"TWO+SEATERS",+"Manufacturer"=>"ASTON+MARTIN",+"carline+name"=>"ASTON+MARTIN+VANQUISH",+"displ"=>"5.9",+"cyl"=>"12.0",+"trans"=>"Auto(S6)",+"drv"=>"R",+"bidx"=>"1.0",+"cty"=>"12.0",+"hwy"=>"19.0",+"cmb"=>"14.0",+"ucty"=>"13.55",+"uhwy"=>"24.7",+"ucmb"=>"17.015",+"fl"=>"P",+"G"=>"G",+"T"=>"",+"S"=>"",+"2pv"=>"",+"2lv"=>"",+"4pv"=>"",+"4lv"=>"",+"hpv"=>"",+"hlv"=>"",+"fcost"=>"1651.0",+"eng+dscr"=>"GUZZLER",+"trans+dscr"=>"CLKUP",+"vpc"=>"4.0",+"cls"=>"1.0"}|1192103|entityMap|0|LINK|mutability|MUTABLE|url|http://github.com/seamusabshere/remote_table|1|http://roo.rubyforge.org/^0|0|J|0|O|3|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]|$A|10|B|11|1|12]]|C|$]]|$1|D|3|E|5|F|7|13|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|14|8|@]|9|@]|C|$]]|$1|K|3|L|5|F|7|15|8|@]|9|@]|C|$G|H]]|$1|M|3|-4|5|6|7|16|8|@]|9|@]|C|$]]]|N|$O|$5|P|Q|R|C|$S|T]]|U|$5|P|Q|R|C|$S|V]]]]

The <a href="http://github.com/seamusabshere/remote_table" rel="nofollow">RemoteTable library</a> uses <a href="http://roo.rubyforge.org/" rel="nofollow">roo</a> internally. It makes it easy to read spreadsheets of different formats (XLS, XLSX, CSV, etc. possibly remote, possibly stored inside a zip, gz, etc.):

<pre><code>require 'remote_table'
r = RemoteTable.new 'http://www.fueleconomy.gov/FEG/epadata/02data.zip', :filename =&gt; 'guide_jan28.xls'
r.each do |row|
 puts row.inspect
end
</code></pre>

Output:

<pre><code>{"Class"=&gt;"TWO SEATERS", "Manufacturer"=&gt;"ACURA", "carline name"=&gt;"NSX", "displ"=&gt;"3.0", "cyl"=&gt;"6.0", "trans"=&gt;"Auto(S4)", "drv"=&gt;"R", "bidx"=&gt;"60.0", "cty"=&gt;"17.0", "hwy"=&gt;"24.0", "cmb"=&gt;"20.0", "ucty"=&gt;"19.1342", "uhwy"=&gt;"30.2", "ucmb"=&gt;"22.9121", "fl"=&gt;"P", "G"=&gt;"", "T"=&gt;"", "S"=&gt;"", "2pv"=&gt;"", "2lv"=&gt;"", "4pv"=&gt;"", "4lv"=&gt;"", "hpv"=&gt;"", "hlv"=&gt;"", "fcost"=&gt;"1238.0", "eng dscr"=&gt;"DOHC-VTEC", "trans dscr"=&gt;"2MODE", "vpc"=&gt;"4.0", "cls"=&gt;"1.0"}
{"Class"=&gt;"TWO SEATERS", "Manufacturer"=&gt;"ACURA", "carline name"=&gt;"NSX", "displ"=&gt;"3.2", "cyl"=&gt;"6.0", "trans"=&gt;"Manual(M6)", "drv"=&gt;"R", "bidx"=&gt;"65.0", "cty"=&gt;"17.0", "hwy"=&gt;"24.0", "cmb"=&gt;"19.0", "ucty"=&gt;"18.7", "uhwy"=&gt;"30.4", "ucmb"=&gt;"22.6171", "fl"=&gt;"P", "G"=&gt;"", "T"=&gt;"", "S"=&gt;"", "2pv"=&gt;"", "2lv"=&gt;"", "4pv"=&gt;"", "4lv"=&gt;"", "hpv"=&gt;"", "hlv"=&gt;"", "fcost"=&gt;"1302.0", "eng dscr"=&gt;"DOHC-VTEC", "trans dscr"=&gt;"", "vpc"=&gt;"4.0", "cls"=&gt;"1.0"}
{"Class"=&gt;"TWO SEATERS", "Manufacturer"=&gt;"ASTON MARTIN", "carline name"=&gt;"ASTON MARTIN VANQUISH", "displ"=&gt;"5.9", "cyl"=&gt;"12.0", "trans"=&gt;"Auto(S6)", "drv"=&gt;"R", "bidx"=&gt;"1.0", "cty"=&gt;"12.0", "hwy"=&gt;"19.0", "cmb"=&gt;"14.0", "ucty"=&gt;"13.55", "uhwy"=&gt;"24.7", "ucmb"=&gt;"17.015", "fl"=&gt;"P", "G"=&gt;"G", "T"=&gt;"", "S"=&gt;"", "2pv"=&gt;"", "2lv"=&gt;"", "4pv"=&gt;"", "4lv"=&gt;"", "hpv"=&gt;"", "hlv"=&gt;"", "fcost"=&gt;"1651.0", "eng dscr"=&gt;"GUZZLER", "trans dscr"=&gt;"CLKUP", "vpc"=&gt;"4.0", "cls"=&gt;"1.0"}
</code></pre>

blocks|key|977885|text|我使用的是creek，它使用nokogiri。它很快。在我的Macbook+Air上的21x11250+xlsx桌面上使用了8.3秒。让它在ruby+1.9.3%2B上工作。每一行的输出格式是行和列名到单元格内容的散列：{"A1"=>"a+cell"，“B1”=>“另一个单元格”}散列不能保证键将按原始的列顺序排列。https://github.com/pythonicrubyist/creek|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|977886|dullard是另一个使用nokogiri的很好的工具。它是超级快的。在我的Macbook+Air上的21x11250+xlsx桌面上使用了6.7秒。让它在ruby+2.0.0%2B上工作。每行的输出格式是一个数组："a+cell",+"another+cell"|977887|前面提到的simple_xlsx_reader很棒，但有点慢。在我的Macbook+Air上的21x11250+xlsx桌面上使用了91秒。让它在ruby+1.9.3%2B上工作。每行的输出格式是一个数组："a+cell",+"another+cell"|977888|另一个有趣的是oxcelix。它使用ox的SAX解析器，据说比nokogiri的DOM和SAX解析器都要快。它应该输出一个矩阵。我不能让它工作。此外，rubyzip还存在一些依赖问题。不会推荐这样做。|977889|总之，creek似乎是个不错的选择。其他帖子推荐simple_xlsx_parser，因为它有类似的性能。|977890|删除了推荐的dullard，因为它已经过时了，人们对它有错误/有问题。|977891|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/pythonicrubyist/creek|1|https://github.com/thirtyseven/dullard|2|https://github.com/woahdae/simple_xlsx_reader^0|4D|14|0|0|2Y|O|1|0|2T|O|2|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Z|8|@]|9|@$A|10|B|11|1|12]]|C|$]]|$1|D|3|E|5|6|7|13|8|@]|9|@$A|14|B|15|1|16]]|C|$]]|$1|F|3|G|5|6|7|17|8|@]|9|@$A|18|B|19|1|1A]]|C|$]]|$1|H|3|I|5|6|7|1B|8|@]|9|@]|C|$]]|$1|J|3|K|5|6|7|1C|8|@]|9|@]|C|$]]|$1|L|3|M|5|6|7|1D|8|@]|9|@]|C|$]]|$1|N|3|-4|5|6|7|1E|8|@]|9|@]|C|$]]]|O|$P|$5|Q|R|S|C|$T|U]]|V|$5|Q|R|S|C|$T|W]]|X|$5|Q|R|S|C|$T|Y]]]]

I'm using creek which uses nokogiri. It is fast. Used 8.3 seconds on a 21x11250 xlsx table on my Macbook Air. Got it to work on ruby 1.9.3+. The output format for each row is a hash of row and column name to cell content:
{"A1"=>"a cell", "B1"=>"another cell"}
The hash makes no guarantee that the keys will be in the original column order.
<a href="https://github.com/pythonicrubyist/creek" rel="nofollow noreferrer">https://github.com/pythonicrubyist/creek</a>

dullard is another great one that uses nokogiri. It is super fast. Used 6.7 seconds on a 21x11250 xlsx table on my Macbook Air. Got it to work on ruby 2.0.0+. The output format for each row is an array:
["a cell", "another cell"]
<a href="https://github.com/thirtyseven/dullard" rel="nofollow noreferrer">https://github.com/thirtyseven/dullard</a>

simple_xlsx_reader which has been mentioned is great, a bit slow. Used 91 seconds on a 21x11250 xlsx table on my Macbook Air. Got it to work on ruby 1.9.3+. The output format for each row is an array:
["a cell", "another cell"]
<a href="https://github.com/woahdae/simple_xlsx_reader" rel="nofollow noreferrer">https://github.com/woahdae/simple_xlsx_reader</a>

Another interesting one is oxcelix. It uses ox's SAX parser which supposedly faster than both nokogiri's DOM and SAX parser. It supposedly outputs a Matrix. I could not get it to work. Also, there were some dependency issues with rubyzip. Would not recommend it.

In conclusion, creek seems like a good choice. Other posts recommend simple_xlsx_parser as it has similar performance.

Removed dullard as recommended as it's outdated and people are getting errors/having problems with it.

Are there any gems able to parse XLS and XLSX files? I've found Spreadsheet and ParseExcel, but they both don't understand XLSX format.

Parsing XLS and XLSX (MS Excel) files with Ruby?

有没有能解析XLS和XLSX文件的gem？我找到了Spreadsheet和ParseExcel，但它们都不能理解XLSX格式。

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

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

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

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

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