Class: SpreadsheetManager

Inherits:
Object
  • Object
show all
Defined in:
lib/spreadsheet_cache_manager_refi.rb

Overview

access to spreadsheets via roo

  • each file will only be opened once for all requests that are made

Instance Method Summary collapse

Constructor Details

#initialize ⇒ SpreadsheetManager

Returns a new instance of SpreadsheetManager.



27
28
29
30
 
# File 'lib/spreadsheet_cache_manager_refi.rb', line 27

def initialize
	@ss_s = {} # file_pn => spreadsheet
	@metadata_s = {}
end

Instance Method Details

#get_metadata(ss_pn) ⇒ Object 



49
50
51
52
53
54
 
# File 'lib/spreadsheet_cache_manager_refi.rb', line 49

def get_metadata(ss_pn)
	if(@metadata_s[ss_pn] == nil)
		@metadata_s[ss_pn] = {"ss_pn" => ss_pn}.merge( File.get_metadata(ss_pn) )
	end
	return @metadata_s[ss_pn]
end

#get_ss(ss_pn) ⇒ Object 



31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
 
# File 'lib/spreadsheet_cache_manager_refi.rb', line 31

def get_ss(ss_pn)
	if @ss_s[ss_pn] == nil # spreadsheet not opened yet
		$Log.indent
		$Log.tlog( {id: 'info1035', ss_pn: ss_pn } )
		#dputi "K - open spreadsheet: #{$st[:ss_file]}#{ss_pn}"
		#myreq 'roo'
		file_extension = ss_pn.match(/.+\.(.+)$/)[1].to_s
		ss = case file_extension
			when 'xlsx' then Excelx.new(ss_pn)
			when 'xls' then Excel.new(ss_pn)
			when 'ods' then Openoffice.new(ss_pn)
		end
		@ss_s[ss_pn] = ss
		$Log.undent
		#dpun
	end
	return @ss_s[ss_pn]
end