Class: SpreadsheetManager

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

Instance Method Summary collapse

Constructor Details

#initialize ⇒ SpreadsheetManager

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


8
9
10
11
 
# File 'lib/spreadsheet_manager_refi.rb', line 8

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

Instance Method Details

#get_metadata(ss_pn) ⇒ Object 



29
30
31
32
33
34
 
# File 'lib/spreadsheet_manager_refi.rb', line 29

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

ss_pn spreadsheet-pathname



13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
 
# File 'lib/spreadsheet_manager_refi.rb', line 13

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 } )
		#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
	end
	return @ss_s[ss_pn]
end