Advertisement
Guest User

Untitled

a guest
Sep 21st, 2017
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.82 KB | None | 0 0
  1. module Consolis
  2. def parse_xls(opts={})
  3. opts[:file] = "output" unless opts[:file].present?
  4. opts[:headers] = ["Important", "Data"] unless opts[:headers].present?
  5. opts[:data] = [["foo","bar"]] unless opts[:data].present?
  6. File.open(opts[:file]+".xls", "w+") do |f|
  7. f.write("<meta charset='utf-8'><table border=yes width=100%>")
  8. opts[:size] = 1 unless opts[:size].present?
  9. f.write("<tr>")
  10. opts[:headers].map do |header|
  11. f.write("<td>")
  12. f.write(header)
  13. f.write("</td>")
  14. end
  15. f.write("</tr>")
  16. opts[:data].map do |mapped|
  17. f.write("<tr>")
  18. mapped.each do |content|
  19. f.write("<td>")
  20. f.write(content)
  21. f.write("</td>")
  22. end
  23. f.write("</tr>")
  24. end
  25. f.write("</table>")
  26. end
  27. end
  28. end
  29. include Consolis
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement