python数据处理、
Mr.徐zZZZ
11
展开
-
python 对excel文件的追加操作
#ecoding=utf-8import xlrdimport xlwtimport numpy as npfrom xlutils.copy import copy# 打开测试数据文件workbook = xlrd.open_workbook('C:/Users/Administrator/Desktop/S1data.xlsx')sheet1 = workbook.sheet_...原创 2019-10-09 18:37:47 · 488 阅读 · 0 评论 -
python 对excel文件的删除操作
from openpyxl import *filename = '20191009_1454_S1_Temp.xlsx'wb = load_workbook('C:/Users/Administrator/Desktop/'+filename)#装载文件ws = wb.activefor i in range(1,ws.max_row+1):#最大行数 print(i ,ws....原创 2019-10-09 18:40:26 · 4819 阅读 · 0 评论