如何使用.out文件编写python代码在excel表格中打印结果？

Question

我有一张长凳-内存输出文件。它包含如下输入。 { "timing_type": "hp_timing", "functions": { "memset": { "bench-variant": "", "ifuncs": ["builtin_memset", "simple_memset", "__memset_sse2_unaligned", "__memset_sse2_unaligned_erms", "__memset_erms", "__memset_avx2_unaligned", "__memset_avx2_unaligned_erms"], "results": [ { "length": 1, "alignment": 0, "char": -65, "timings": [101.812, 50.0625, 50.625, 46.6875, 60.1875, 55.125, 50.625] }, { "length": 2, "alignment": 0, "char": -65, "timings": [61.3125, 45.5625, 47.25, 44.4375, 59.625, 50.0625, 48.9375] }] } } } 我必须用excel打印计时值床单。怎么办我可以吗？ 谁能帮我解决这个问题吗。

Answer 1

使用Excel打开XML文件的能力是一种简单的方法。 下面是要生成的代码计时.xmlExcel可以打开。在

import json
#JSON loaded via a file (for instance)
f=open('bench-memcpy.out','r')
json_input = f.read()
f.close()
#defining XML header
output = '<?xml version="1.0"?><ss:Workbook xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"><ss:Worksheet ss:Name="Timings"><ss:Table>'
#Load info as JSON data
json_data = json.loads(json_input)
#loop data
for r in range (0,len(json_data['functions']['memset']['results'])):
    output = output + '<ss:Row>'
    for t in range (0,len(json_data['functions']['memset']['results'][r]['timings'])):
        output += '<ss:Cell><ss:Data ss:Type="String">' + str(json_data['functions']['memset']['results'][r]['timings'][t]) + '</ss:Data></ss:Cell>'
    output += '</ss:Row>'
output += '</ss:Table></ss:Worksheet></ss:Workbook>'
f=open('timings.xml','w')
f.write(output)
f.close