class GoogleSpreadsheet::List

Returns Hash-like object (GoogleSpreadsheet::ListRow) for the row with the index. Keys of the object are colum names (the first row). The second row has index 0.

Note that updates to the returned object are not sent to the server until you call GoogleSpreadsheet::Worksheet#save.

# File lib/google_spreadsheet/list.rb, line 36
def [](index)
  return ListRow.new(self, index)
end

Updates the row with the index with the given Hash object. Keys of hash are colum names (the first row). The second row has index 0.

Note that update is not sent to the server until you call GoogleSpreadsheet::Worksheet#save.

# File lib/google_spreadsheet/list.rb, line 46
def []=(index, hash)
  self[index].replace(hash)
end

Iterates over Hash-like object (GoogleSpreadsheet::ListRow) for each row (except for the first row). Keys of the object are colum names (the first row).

# File lib/google_spreadsheet/list.rb, line 53
def each(&block)
  for i in 0...self.size
    yield(self[i])
  end
end

Column names i.e. the contents of the first row. Duplicates are removed.

# File lib/google_spreadsheet/list.rb, line 61
def keys
  return (1..@worksheet.num_cols).map(){ |i| @worksheet[1, i] }.uniq()
end

Updates column names i.e. the contents of the first row.

Note that update is not sent to the server until you call GoogleSpreadsheet::Worksheet#save.

# File lib/google_spreadsheet/list.rb, line 69
def keys=(ary)
  for i in 1..ary.size
    @worksheet[1, i] = ary[i - 1]
  end
  for i in (ary.size + 1)..@worksheet.num_cols
    @worksheet[1, i] = ""
  end
end

Adds a new row to the bottom. Keys of hash are colum names (the first row). Returns GoogleSpreadsheet::ListRow for the new row.

Note that update is not sent to the server until you call GoogleSpreadsheet::Worksheet#save.

# File lib/google_spreadsheet/list.rb, line 84
def push(hash)
  row = self[self.size]
  row.update(hash)
  return row
end

Number of non-empty rows in the worksheet excluding the first row.

# File lib/google_spreadsheet/list.rb, line 26
def size
  return @worksheet.num_rows - 1
end

Returns all rows (except for the first row) as Array of Hash. Keys of Hash objects are colum names (the first row).

# File lib/google_spreadsheet/list.rb, line 92
def to_hash_array()
  return self.map(){ |r| r.to_hash() }
end