axebomber

Hogan Excel

Mainly in Japan, Excel workbook is used as a grid paper in business scene.

So we need more flexible and intelligent parser. only POI or OLE is not enough.

Sense the atmosphere

Japanese offten say "Kuuki Yome!". To parse excel is the same thing. A row whose background color is gray means deleted. So, we need a feature that it skip such a row.

POI + JRuby

POI is an awesome tool for parsing excel data.

Example

Here is a very simple example.

sheet.rows({
  'exceptGrayout'=>true
}).each{|row|
  puts row.cell("No").to_i
  puts row.cell("name")
}
            

An example of Hogan Excel