Advertisement
Guest User

Untitled

a guest
May 21st, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Ruby 0.49 KB | None | 0 0
  1. workbook = WriteExcel.new ('/Users/oleg/Desktop/Mtrx.xlsx')
  2.  
  3. # Add worksheet(s)
  4. worksheet  = workbook.add_worksheet
  5. mafia_cisel = [1,2,3,4,5]
  6. mafia_chisel_2 = [0,1,2,3,4,5]
  7. magic_bukv = ["A1", "A2", "A3", "A4", "A5"]
  8. magic_bukv_2 = ["Z", "A", "L", "U", "P", "A"]
  9. mafia_cisel.map do |element|
  10.     worksheet.write(0, element,  'Hi Excel.') # cell B3
  11. end
  12. magic_bukv.each_with_index do |letter|
  13.     magic_bukv_2.map do |element|
  14.     worksheet.write(letter, element)
  15.   end
  16. end
  17.  
  18. workbook.close
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement