0

I know how to create HTML reports, but I don't know how to create excel report. Does anyone know how to create the excel report.

orde
  • 5,233
  • 6
  • 31
  • 33
Ajay
  • 21
  • 7
  • Why do you need excel report? – Priyanshu Jul 27 '16 at 07:13
  • 1
    You can output to json then import to excel. http://stackoverflow.com/questions/8044423/json-import-to-excel – Dave McNulla Jul 27 '16 at 15:18
  • I had generated the HTML report but my team leader told me to generate the excel sheet report, so that is the reason.( Priyanshu Shekhar) – Ajay Jul 27 '16 at 16:06
  • Hi Dave McNulla, Is there any other way to generate the excel report. Thanks in advance. – Ajay Jul 27 '16 at 16:10
  • Possible duplicate of [Output array to CSV in Ruby](http://stackoverflow.com/questions/4822422/output-array-to-csv-in-ruby) – JeffC Jul 27 '16 at 18:02
  • Write to CSV and then import to Excel. See the link above. – JeffC Jul 27 '16 at 18:02
  • Hi JeffC, But how to convert the CSV to excel. – Ajay Jul 28 '16 at 18:41
  • I have created csv and able to output the array into CSV. Here is my code require 'csv' class Csv_Excel def initialize(browser) @browser = browser end def loading_to_csv CSV.open("c:/AJAY/report.csv", "wb") do |csv| csv << ["time", "url", "elec_disc", "check_box", "full_disc", "report" ] end end end But here my question is how to convert csv into excel . – Ajay Jul 29 '16 at 19:49
  • How do you expect this report to look like? I mean an excel report only makes sense if you have results of multiple runs and you want to fit them all in an excel sheet. – Eugene S Aug 11 '16 at 01:55
  • Hi Eugene, Do you know how to create excel sheet report, it does't matter how it looks but I need to generate the excel report. – Ajay Aug 18 '16 at 17:45

0 Answers0