如何将打印功能追加并保存到 excel 或 csv?

Question

如何将打印功能追加并保存到 excel 或 csv

法典：

firstpts= ['20']
for pfts in firstpts:
try:
(Operation)
print('test11 : PASSED')
except:
(Operation)
print('test11 : FAILED')

secondpts= ['120']
for sfts in secondpts:
try:
(Operation)
print('test22 : PASSED')
except:
(Operation)
print('test22 : FAILED')

如果我运行此代码，我将在输出中获取此代码

test11 : PASSED
test22 : FAILED

如何将所有尝试除外情况的输出重定向到 csv

Answer 1

首先，你对 try-catch 的基本使用是错误的，因为 if-elsing。

无论如何，除此之外，您需要将所有记录的语句收集在一个字符串中，然后将该字符串写入".csv"文件。

喜欢这个：-

# @author Vivek
# @version 1.0
# @since 24-08-2019
data = ""
firstpts = [20]
for pfts in firstpts:
try:
if pfts < 100:
print('test11 : PASSED')
data = 'test11 : PASSEDn'
except:
if pfts > 100:
print('test11 : FAILED')
data += 'test11 : PASSEDn'
secondpts = [120]
for sfts in secondpts:
try:
if sfts < 100:
print('test22 : PASSED')
data += 'test11 : PASSEDn'
except:
if sfts > 100:
print('test22 : FAILED')
data += 'test22 : FAILED'
file = open('test.csv', 'w')
file.write(data)
file.close()

Answer 2

创建一个文件 csv 并在里面写入信息。

firstpts= ['20']
for pfts in firstpts:
if int(pfts) < 100:
print('test11 : PASSED')
result_test11 = 'test11 : PASSED'
else:
print('test11 : FAILED')
result_test11 = 'test11 : FAILED'
secondpts= ['120']
for sfts in secondpts:
if int(sfts) < 100:
print('test22 : PASSED')
result_test22 = 'test22 : PASSED'
else:
print('test22 : FAILED')
result_test22 = 'test22 : FAILED'
f = open("file.csv","w+")
f.write("{}n{}".format(result_test11, result_test22))
f.close()