Class: SpreadsheetReport
- Inherits:
-
Object
- Object
- SpreadsheetReport
- Defined in:
- lib/spreadsheet_report.rb
Instance Method Summary collapse
-
#initialize(username, password, spreadsheet_key) {|_self| ... } ⇒ SpreadsheetReport
constructor
A new instance of SpreadsheetReport.
- #worksheet(name, query) ⇒ Object
Constructor Details
#initialize(username, password, spreadsheet_key) {|_self| ... } ⇒ SpreadsheetReport
Returns a new instance of SpreadsheetReport.
5 6 7 8 9 10 |
# File 'lib/spreadsheet_report.rb', line 5 def initialize(username, password, spreadsheet_key, &block) @session = GoogleSpreadsheet.login(username, password) @spreadsheet = @session.spreadsheet_by_key(spreadsheet_key) yield(self) end |
Instance Method Details
#worksheet(name, query) ⇒ Object
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 50 51 |
# File 'lib/spreadsheet_report.rb', line 12 def worksheet(name, query) worksheet = @spreadsheet.worksheets.find { |ws| ws.title == name } # create the worksheet if we didn't find it if worksheet != nil worksheet.delete worksheet = nil end # run the query result = ActiveRecord::Base.connection.select_all(query) # resize the worksheet rows = result.size + 1 keys = [] if result.size > 0 keys = result[0].keys end cols = keys.size worksheet = @spreadsheet.add_worksheet(name, result.size + 1, keys.size) # add the title cells keys.each_with_index do |key, index| worksheet[1, index + 1] = key end current_row = 2 result.each do |row_data| keys.each_with_index do |key, index| worksheet[current_row, index + 1] = row_data[key] end current_row += 1 if current_row % 250 == 0 worksheet.save end end worksheet.save end |