Class: Roo::Excelx::Workbook
- Defined in:
- lib/roo/excelx/workbook.rb
Defined Under Namespace
Classes: Label
Instance Method Summary collapse
- #base_date ⇒ Object
-
#defined_names ⇒ Object
aka labels.
-
#initialize(path) ⇒ Workbook
constructor
A new instance of Workbook.
- #sheets ⇒ Object
Constructor Details
#initialize(path) ⇒ Workbook
Returns a new instance of Workbook.
21 22 23 24 |
# File 'lib/roo/excelx/workbook.rb', line 21 def initialize(path) super fail ArgumentError, 'missing required workbook file' unless doc_exists? end |
Instance Method Details
#base_date ⇒ Object
41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 |
# File 'lib/roo/excelx/workbook.rb', line 41 def base_date @base_date ||= begin # Default to 1900 (minus one day due to excel quirk) but use 1904 if # it's set in the Workbook's workbookPr # http://msdn.microsoft.com/en-us/library/ff530155(v=office.12).aspx result = Date.new(1899, 12, 30) # default doc.css('workbookPr[date1904]').each do |workbookPr| if workbookPr['date1904'] =~ /true|1/i result = Date.new(1904, 01, 01) break end end result end end |
#defined_names ⇒ Object
aka labels
31 32 33 34 35 36 37 38 39 |
# File 'lib/roo/excelx/workbook.rb', line 31 def defined_names Hash[doc.xpath('//definedName').map do |defined_name| # "Sheet1!$C$5" sheet, coordinates = defined_name.text.split('!$', 2) col, row = coordinates.split('$') name = defined_name['name'] [name, Label.new(name, sheet, row, col)] end] end |
#sheets ⇒ Object
26 27 28 |
# File 'lib/roo/excelx/workbook.rb', line 26 def sheets doc.xpath('//sheet') end |