Python如何将一个列表写入到一个excel表中的一列,求Python代码,谢啦! Python 如何循环读取csv或者excel中的一列数据，...
python 3.x\u7248\u672c\u5982\u4f55\u4f7f\u7528openpyxl\u5c06\u5217\u8868\u6309\u5217\u5199\u5165\u5df2\u6709\u7684xlsx\u6587\u4ef6\u6307\u5b9a\u7684\u5217\uff1f# -*- coding: UTF-8 -*-import openpyxl#\u52a0\u8f7d\u6587\u4ef6wb = openpyxl.load_workbook("../file/test.xlsx")#\u83b7\u5f97sheet\u540d\u79f0sheetNames = wb.sheetnamesprint(sheetNames)#sheetName1 = sheetNames[0]#\u6839\u636e\u540d\u79f0\u83b7\u53d6\u7b2c\u4e00\u4e2asheet#sheet1 = wb[sheetName1]#\u6839\u636e\u7d22\u5f15\u83b7\u5f97\u7b2c\u4e00\u4e2asheetsheet1 = wb.worksheets[0]L = ['\u5f20\u4e09', '\u674e\u56db', '\u738b\u4e94']#excel\u4e2d\u5355\u5143\u683c\u4e3aB2\u5f00\u59cb\uff0c\u5373\u7b2c2\u5217\uff0c\u7b2c2\u884cfor i in range(len(L)): sheet1.cell(i+2, 2).value=L[i]#\u4fdd\u5b58\u6570\u636e\uff0c\u5982\u679c\u63d0\u793a\u6743\u9650\u9519\u8bef\uff0c\u9700\u8981\u5173\u95ed\u6253\u5f00\u7684excelwb.save("../file/test.xlsx")
\u5b9e\u6d4b\u662f\u53ef\u4ee5\u4ece a.csv\u590d\u5236\u5230 b.csv\u4e2d
import csv
def foo():
with open('a.csv', 'r') as f:
reader = csv.DictReader(f)
rows = [row for row in reader]
if not rows:
return
with open('b.csv', mode='w', newline='', errors='ignore') as f2:
for index, row in enumerate(rows):
if index == 0:
f_csv = csv.DictWriter(f2, fieldnames=list(row.keys()))
f_csv.writeheader()
f_csv.writerow(row)
if __name__ == '__main__':
foo()
import xlwt
f = xlwt.Workbook() #创建工作簿
sheet1 = f.add_sheet(u'sheet1',cell_overwrite_ok=True) #创建sheet
l_=[1,2,3,4,5]
for i in range(len(l_)):
sheet1.write(0,i,i)#表格的第一行开始写。第一列，第二列。。。。
#sheet1.write(0,0,start_date,set_style('Times New Roman',220,True))
f.save('text.xls')#保存文件
import xlwt
f = xlwt.Workbook() #创建工作薄
sheet1 = f.add_sheet(u'sheet1',cell_overwrite_ok=True) #创建sheet
list = [1,2,3,4,5]
j = 0
for i in list:
sheet1.write(j,0,i) #循环写入 竖着写
j=j+1
f.save('text.xls')#保存文件
文件存储是按照每个子列表为一行的，所以在写文件时只需要将[10,'haha',0.1]换成[[10],['haha'],[0.1]]。所以只要将mywrite.writerow(i)改为mywrite.writerow([i])。
import csv
def storFile(data,fileName):
with open(fileName,'w',newline ='') as f:
mywrite = csv.writer(f)
for i in data:
mywrite.writerow([i])
data = [10,'haha',0.1]
storFile(data,"haha.csv")
import random
from openpyxl import load_workbook
list = [5,3,1,7,4,2,6]
list_random=random.sample(list, len(list))
list_data = list_random.copy()
print("源列表：",list)
print("新列表：",list_data)
wb = load_workbook(r'D:\works\scripts\interfaceest_dataest.xlsx')
sheet = wb['re']
for i in range(1,16): #行
for data1 in range(len(list)): #获取源数据的列表中内容个数
rowsCount1 = data1+1 #每次读取后+1
sheet.cell(row=rowsCount1, column=1).value = list[data1] #根据内容当前赋值给行数
for data2 in range(len(list_data)): #获取新列表中内容个数
rowsCount2 = data2 + 1 #
sheet.cell(row=rowsCount2, column=2).value = list_data[data2]
wb.save(r'D:\works\scripts\interfaceest_dataest.xlsx')
绛旓細1. 鎵撳紑鏂囦欢浠ヤ緵鍐欏叆銆2. 浣跨敤寰幆閬嶅巻鍒楄〃涓殑姣忎釜鍏冪礌锛屽苟灏嗗叾鍐欏叆鏂囦欢銆3. 鍏抽棴鏂囦欢銆備互涓嬫槸鍏蜂綋鐨勬搷浣滄楠ゅ拰浠ｇ爜绀轰緥锛氫唬鐮佺ず渚嬶細鍋囪鎴戜滑鏈変竴涓垪琛╜my_list`锛屾垜浠兂灏嗗叾鍐欏叆涓涓悕涓篳output.txt`鐨勬枃浠朵腑銆俻ython my_list = ["apple", "banana", "cherry"] # 杩欐槸鎴戜滑瑕佸啓鍏ユ枃浠剁殑鍒...
绛旓細瑕佷粠閿洏杈撳叆鍒楄〃锛屽彲浠ヤ娇鐢╥nput()鍑芥暟缁撳悎鍒楄〃鎺ㄥ寮銆傛偍鍙互鎸夌収浠ヤ笅绀轰緥浠ｇ爜鐨勬牸寮忚繘琛岃緭鍏ワ細涓婅堪浠ｇ爜灏嗕粠閿洏璇诲彇涓涓瓧绗︿覆锛岃瀛楃涓插寘鍚敤绌烘牸鍒嗛殧鐨勫厓绱犮傜劧鍚庯紝split()鍑芥暟灏嗗瓧绗︿覆鎷嗗垎涓轰竴涓垪琛紝骞朵娇鐢╥nt()鍑芥暟灏嗘瘡涓厓绱犺浆鎹负鏁存暟绫诲瀷銆傛渶缁堬紝灏嗗緱鍒颁竴涓暣鏁板垪琛紝瀛樺偍鍦ㄥ悕涓簃y_list鐨勫彉閲...
绛旓細python鎶婂垪琛ㄥ啓鍏鏂囦欢鐨勮缁嗕唬鐮侊細list = ['foo', 'bar']sep = ','fl=open('list.txt', 'w')fl.write(sep.join(list))fl.close()sep鏄垎闅旂锛宻ep='\n'灏辨槸鍒嗚杈撳叆鍙﹀鎻愰啋涓涓嬶紝鑰冭檻涓涓媗ist閲屽惈鏈夋暟瀛:锛岀敤str()鍑芥暟杞竴涓嬶紝鐪嬩綘瑕佸鐞嗙殑鏁版嵁浜嗐備唬鐮佷娇鐢ㄤ妇渚嬶細>>> l=["A","...
绛旓細浣犲彲浠ュ垱寤哄寘鍚瓧姣嶈〃涓墍鏈夊瓧姣嶃佹暟瀛0~9鎴栨墍鏈夊搴垚鍛樺鍚嶇殑鍒楄〃锛涗篃鍙互灏嗕换浣曚笢瑗垮姞鍏ュ垪琛ㄤ腑锛屽叾涓殑鍏冪礌涔嬮棿鍙互娌℃湁 浠讳綍鍏崇郴銆傚湪Python涓紝濡備綍杈撳叆涓涓垪琛ㄥ憿锛熷湪Python涓紝鐢ㄦ柟鎷彿[ ] 鏉ヨ〃绀哄垪琛紝骞剁敤閫楀彿鏉ュ垎闅斿叾涓殑鍏冪礌銆備笅闈㈡槸涓涓畝鍗曠殑鍒楄〃绀轰緥锛岃繖涓垪琛ㄥ寘鍚嚑绉嶈嚜琛岃溅锛歜icycles = [...
绛旓細1銆佸彲浠ヤ娇鐢╢or鎴栬厀hile寰幆缁撳悎list鐨刟ppend鎴栬卛nsert鏂规硶璧嬪糵or i in range(10)锛歛ppend(i)銆2銆佸彲浠ョ洿鎺ヤ粠鍏朵粬瀵硅薄鍒涘缓鍒楄〃锛屾瘮濡傚瓧鍏哥殑keys锛寁alues銆傚洜涓鸿嚜浠嶤杩欑被鐨勮瑷璇炵敓鍚庯紝璇█鐨勮娉曞惈涔変笌瀛楃鐨勬帓鍒楁柟寮忓垎绂诲紑鏉ワ紝鏇剧粡琚涓烘槸涓绉嶇▼搴忚瑷鐨勮繘姝ャ備笉杩囦笉鍙惁璁ょ殑鏄紝閫氳繃寮哄埗绋嬪簭鍛樹滑缂╄繘...
绛旓細绠鍗曠殑鏂规硶鏄細variable_1 = "HELLO"variable_2 = "WORLD"varlist = [variable_1, variable_2]print "INSERT INTO table VALUES %r;" % (tuple(varlist),)鍏抽敭鏄鎶妉ist杞崲鎴恡uple
绛旓細import xlwtf = xlwt.Workbook() #鍒涘缓宸ヤ綔绨縮heet1 = f.add_sheet(u'sheet1',cell_overwrite_ok=True) #鍒涘缓sheetl_=[1,2,3,4,5]for i in range(len(l_)): sheet1.write(0,i,i)#琛ㄦ牸鐨勭涓琛屽紑濮嬪啓銆傜涓鍒楋紝绗簩鍒椼傘傘 #sheet1.write(0,0,start_date,set_style('Tim...
绛旓細-*- coding: UTF-8 -*-import openpyxl#鍔犺浇鏂囦欢wb = openpyxl.load_workbook("../file/test.xlsx")#鑾峰緱sheet鍚嶇ОsheetNames = wb.sheetnamesprint(sheetNames)#sheetName1 = sheetNames[0]#鏍规嵁鍚嶇О鑾峰彇绗涓涓sheet#sheet1 = wb[sheetName1]#鏍规嵁绱㈠紩鑾峰緱绗竴涓猻heetsheet1 = wb.worksheets[...
绛旓細璋冪敤json.dump鍑芥暟灏辫浜嗭紝涓嬮潰鏄涓涓渚嬪瓙 import json 灏咶ileName鎸囧畾涓轰綘鐨勬枃浠剁殑瀹為檯璺緞 FileName='t.txt'lst=[{'name':'lili','age':25},{'name':'gg','age':18}]with open(FileName,'w') as f:json.dump(lst,f)
绛旓細a = [1,2,3,4,5,6,7,8,9]tmp = []for i in range(0,len(a),3):tmp.append(str(a[i])+","+str(a[i+1])+","+str(a[i+2])+"\n")file("./a.txt",'w').writelines(tmp)
