module SqlToXls::SqlToXlsTemple
Public Instance Methods
temple_report(temple_path,sql,start_row)
click to toggle source
# File lib/sql_to_xls/sql_to_xls_temple.rb, line 6 def temple_report(temple_path,sql,start_row) report = execute_sql(sql) add_size = report.first&.size start_row = start_row.to_i file = Spreadsheet.open temple_path list = file.worksheet 0 # 默认sql的列数要和xls模板列数对应 report.each_with_index do |detail,index| add_size.times do |i| list[index+start_row,i] = detail[i] end end xls_report = StringIO.new file.write xls_report xls_report.string end