DRYAD Generator Ruby

require 'axlsx'

#Axlsx boilerplate
p = Axlsx::Package.new
wb = p.workbook

#Generate a random 5 letter code word
def rand
	[*('A'..'Z')].sample(5).join
end

#Axlsx style enhancements



wb.add_worksheet(:name => "Dryad Worksheet" ) do |sheet|



  	sheet.add_row(['For Training Use Only', '', "UID:", ""])
  	sheet.add_row(["Start DTG:", "", "End DTG:", ""])
  	sheet.add_row(["Distribution", "", ""])
  	sheet.add_row([""])

    sheet.add_row ['', 'ABCD', 'EFG', 'HIJ', 'KL', 'MN', 'OPQ', 'RS', 'TUV', 'WX', 'YZ',]
    sheet.add_row ['', '0', '1', '2', '3', '4', '5', '6', '7', '8', '9',]

    sheet.add_row ['A', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]
    sheet.add_row ['B', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]
    sheet.add_row ['C', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]
    sheet.add_row ['D', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]
    sheet.add_row ['E', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]
    sheet.add_row ['F', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]


    sheet.add_row ['','', '', '', '', '', '', '', '', '',  ]
    sheet.add_row ['', 'ABCD', 'EFG', 'HIJ', 'KL', 'MN', 'OPQ', 'RS', 'TUV', 'WX', 'YZ',]
    sheet.add_row ['', '0', '1', '2', '3', '4', '5', '6', '7', '8', '9',]


    sheet.add_row ['G', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]
    sheet.add_row ['H', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]
    sheet.add_row ['I', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]
    sheet.add_row ['J', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]
    sheet.add_row ['K', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]
    sheet.add_row ['L', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]


    sheet.add_row ['','', '', '', '', '', '', '', '', '',  ]
    sheet.add_row ['', 'ABCD', 'EFG', 'HIJ', 'KL', 'MN', 'OPQ', 'RS', 'TUV', 'WX', 'YZ',]
    sheet.add_row ['', '0', '1', '2', '3', '4', '5', '6', '7', '8', '9',]


    sheet.add_row ['M', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]
    sheet.add_row ['N', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]
    sheet.add_row ['O', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]
    sheet.add_row ['P', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]
    sheet.add_row ['Q', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]
    sheet.add_row ['R', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]


    sheet.add_row ['','', '', '', '', '', '', '', '', '',  ]
    sheet.add_row ['', 'ABCD', 'EFG', 'HIJ', 'KL', 'MN', 'OPQ', 'RS', 'TUV', 'WX', 'YZ',]
    sheet.add_row ['', '0', '1', '2', '3', '4', '5', '6', '7', '8', '9',]


    sheet.add_row ['S', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]
    sheet.add_row ['T', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]
    sheet.add_row ['U', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]
    sheet.add_row ['V', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]
    sheet.add_row ['W', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]
    sheet.add_row ['X', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]
    sheet.add_row ['Y', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]
    sheet.add_row ['Z', rand, rand, rand, rand, rand, rand, rand, rand, rand, rand,]




  end

  p.serialize('DryadGenerator.xlsx')