擅长:python、mysql、java
<p>你看过熊猫吗?它有很多强大的表格功能,包括直接导出到excel。下面是我的简单代码,希望有用</p>
<pre><code>import pandas as pd
plc_data = pd.DataFrame(columns=['Tag', 'DateTime', 'Actuator', 'Value'], dtype=object)
# Code to get tags e.g.:
for i in range(10):
# This is just a loop to generate data. In your case put your code to extract data correctly
plc_tag = 'XXX_{0}'.format(i)
date_time = '2019-06-{0}'.format(i+5)
actuator = 'ACTUADOR {0}'.format(i)
act_value = 'Work Ok'
temp_dict = {'Tag': plc_tag, 'DateTime': date_time, 'Actuator': actuator, 'Value': act_value}
plc_data = plc_data.append(temp_dict.copy(), ignore_index=True) # I have used a copy of the dictionary, although I'm not sure it's fully necessary.
plc_data.to_excel("output.xlsx", sheet_name='Sheet_name_1', index=False)
</code></pre>