Skip to content

Instantly share code, notes, and snippets.

Created March 29, 2016 15:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/62f33e11e9cd072f2ae3 to your computer and use it in GitHub Desktop.
Save anonymous/62f33e11e9cd072f2ae3 to your computer and use it in GitHub Desktop.
#Henter array med alle filer, som ender på .xlsx i den mappe, som scriptet befinder sig i
excel_navn = Dir.glob('*.xlsx')
#For hvert element i array'et, udføres følgende:
excel_navn.each do |navn|
$excel_name = navn
puts "Alrighty. Hvad er forsøgspersonens navn? (FX: BR253K)"
$fp = gets.chomp
puts "Opretter PDF-dokumentet for forsøgsperson:" + $fp + ". Hent en kop kaffe imens."
$xlsx = Roo::Spreadsheet.open($excel_name)
array = $xlsx.sheets
Prawn::Document.generate($excel_name.slice(".xlsx") + ".pdf") do
array.each do |ark|
calculate(ark)
end
end
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment