Class: LoaderCsv

Inherits:
FileIO show all
Defined in:
lib/loader_csv.rb

Class Method Summary collapse

Methods inherited from FileIO

encodePath, filesystem, readPath

Class Method Details

.makeMatrix(file, opts = nil) ⇒ Object 



4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
 
# File 'lib/loader_csv.rb', line 4

def self.makeMatrix(file, opts=nil)
  opts ||= {}
  opts[:offset] ||= 0
  opts[:encode] ||= 'Windows-31J'

#CSV読み込みメソッド
#1.9系ではFasterCSVを使えない
if(RUBY_VERSION =~ /1\.[^9]/)
  #1.8以下の場合
  require 'fastercsv'
  csv = FasterCSV
else
  #1.9以上の場合
  require 'csv'
  #Encoding.default_external = opts[:encode]
  csv = CSV
end
out = []
i= 0
syspath = self.encodePath(file)
#csv.foreach(syspath, {:row_sep => "\r\n", :encoding => opts[:encode]}) do |row|
  csv.foreach(syspath, {:encoding => opts[:encode]}) do |row|
  if(opts[:offset])
    if(opts[:offset] < i)
      next
    end
  end
  #「1,300台」などカンマが使われている場合、「"1,300台"」となってしまうので、カンマを無視する
  newRow = []
  row.each do |cell|
    cell = cell.to_s
    cell ||= ''
      p cell
    #cell = MyMatrix.toutf8(cell)
    #cell = cell.gsub(/^\"/, "")
    #cell = cell.gsub(/\"$/, "")
    #"
    newRow << cell
  end
  out << newRow
  i += 1
end
return out


end