jmeter导出excel接口_从 Jmeter输出数据导出excel表格

时间匆忙，脚本未仔细测试

require 'rexml/document'

require 'win32ole'

include REXML

$input_file_name = ""

$output_file_name = ""

$column_names = ["Sample number", "Response Time", "Latency Time", "Time Start", "Status", "URL", "Return Code", "Return Msg", "Thread Number", "Date Type", "Bytes"]

def print_usage

puts "Usage: JmeterExtractor [JMeterResultFile] [ExcelFile]"

end

def check_input_file

if File.exist? $input_file_name

puts "input file "+ $input_file_name+" found"

else

puts "input file"+ $input_file_name+ " not found"

exit

end

end

def check_output_file

if File.exist? $output_file_name

puts