用python在xlsx文件中插入列表值

2024-04-25 00:07:18 发布

您现在位置:Python中文网/ 问答频道 /正文

我想用python在xlsx文件的一列中插入list的值。你知道吗

这是密码

def trasformazione (original):
inProj = Proj(init='epsg:4326')
outProj = Proj(init='epsg:3395')
transformat=[]

for g in range (0,row_count-1):
    x2,y2 = transform(inProj,outProj,original[g][0],original[g][1])
    transformat.append([x2,y2])

return (transformat)
transformat=trasformazione (original)
print(trasformazione (original))
 # Create a workbook and add a worksheet.
  workbook = xlsxwriter.Workbook('campioni1.xlsx')
  worksheet = workbook.add_worksheet()
 # Start from the first cell below the headers.
  row = 1
 col=0

# Iterate over the data and write it out row by row.
worksheet.write(row, col,transformat)
row += 1
workbook.close()

谢谢你的支持


Tags: theinitepsgxlsxrowworkbookprojx2