我有一个列表，看起来像这样：

['192.168.0.1  switch1 ff:ff:ff:ff:ff:ff  657 dynamic port:42','10.60.37.2 switch1 ff:ff:ff:ff:ff:ff  657 dynamic port:41','192.168.0.240  switch1 ff:ff:ff:ff:ff:ff  657 dynamic port:40']

字符串
当我导出到Excel，每个块是在一个不同的行，这是好的，但都在同一列，我想有地址列1开关列2等

Excel column 1
Excel row1: 192.168.0.1  switch1 ff:ff:ff:ff:ff:ff  657 dynamic port:42
Excel row2: 10.60.37.2   switch1 ff:ff:ff:ff:ff:ff  657 dynamic port:41
Excel row3 :192.168.0.240  switch1 ff:ff:ff:ff:ff:ff  657 dynamic port:40

型
我想要这样

exlcol1        exlcol2       exl.col3     exl.col4 exl.col5 exl.col6 
exlrow1: 192.168.0.1     switch1   ff:ff:ff:ff:ff:ff   657   dynamic    port:42
exlrow2: 10.60.37.2      switch1   ff:ff:ff:ff:ff:ff   657   dynamic   port:41
exlrow3 :192.168.0.240   switch1   ff:ff:ff:ff:ff:ff   657   dynamic   port:40

型
我试着将它导出到csv，但它说wtr.writerows(row)必须是byte.object，然后我试图将我的列表更改为字符串，将其更改为byte.object，但它说我的wtr.writerows(row)应该是可输入的。
下面是我用来导出到csv的代码

import csv
with open('test.csv', 'wb') as f:
     wtr = csv.writer(f, delimiter= ',')
     for row in data11parts1:
        wtr.writerows(row)

with open('test.csv', 'r') as f:
    for line in f:
         print (line)

型
我的偏好是将其导出到Excel，但我认为这可以帮助您更好地解释我的问题和我拥有的数据类型。
我只是想告诉你，我的数据11部分1来自这个附件：

for element in data2:
    elementstring=''.join(element)
    for element in res1:
        elementstring5=''.join(element)
        if elementstring in elementstring5:
             with open(Sw1, 'r') as f3:
              for line5 in f3:
               if elementstring in line5:
                  print('managemnet-tool' + ' - ' + Sw1.rsplit('.txt',1)[0] + ' - ' + elementstring5.rsplit('-', 1)[0] + ' - ' + line5.rsplit('\n', 1)[0])
                  data11.append(elementstring5.rsplit('-',1)[0] + '  ' + Sw1.rsplit('.txt',1)[0] + ' ' + line5.rsplit('\n', 1)[0])
                  data13.append(str(line5.rsplit('\n', 1)[0]))
                  exit

型