|
马上注册,结交更多好友,享用更多功能^_^
您需要 登录 才可以下载或查看,没有账号?立即注册
x
- #coding=gbk
- import openpyxl
- from openpyxl.utils import column_index_from_string
- filename = r'./waf策略统计.xlsx'
- tongji = openpyxl.load_workbook( filename )
- #——————————————服务器ip:10.254.221.140————————————————————————————————————————
- tongji1 = tongji['Sheet1']
- maxtongji_hang = tongji1.max_row
- daochu = openpyxl.load_workbook( r'./waf导出日志.xlsx' )
- daochu1 = daochu['Sheet1']
- maxdaochu_hang = daochu1.max_row
- maxdaochu_lie = daochu1.max_column
- for i in range(2,maxdaochu_hang + 1):
-
- tongji1.cell(maxtongji_hang + 1,column_index_from_string('A')).value = maxtongji_hang + 0
-
-
- if daochu1.cell(i,column_index_from_string('C')).value == '10.254.221.140':
-
-
- tongji1.cell(2,column_index_from_string('B')).value = daochu1.cell(i,column_index_from_string('C')).value
-
-
-
- maxtongji_hang += 1
-
-
-
-
-
-
- tongji.save('./xin.xlsx')
复制代码
比如我想统计导出日志的表格内10.254.221.140这个ip,总共出现多少次应该怎么写,本人小白,求大佬鞭策
本帖最后由 逃兵 于 2020-11-12 17:46 编辑
下班了,明天再说
- #coding=gbk
- import openpyxl
- from openpyxl.utils import column_index_from_string
- filename = r'./waf策略统计.xlsx'
- tongji = openpyxl.load_workbook( filename )
- #——————————————服务器ip:10.254.221.140————————————————————————————————————————
- tongji1 = tongji['Sheet1']
- maxtongji_hang = tongji1.max_row
- daochu = openpyxl.load_workbook( r'./waf导出日志.xlsx' )
- daochu1 = daochu['Sheet1']
- maxdaochu_hang = daochu1.max_row
- maxdaochu_lie = daochu1.max_column
- for i in range(2,maxdaochu_hang + 1):
-
- tongji1.cell(maxtongji_hang + 1,column_index_from_string('A')).value = maxtongji_hang + 0
-
-
- if daochu1.cell(i,column_index_from_string('C')).value == '10.254.221.140':
-
-
- tongji1.cell(2,column_index_from_string('B')).value = daochu1.cell(i,column_index_from_string('C')).value
-
-
-
- maxtongji_hang += 1
-
- times = 0
- file_value={}
- for each in daochu1['C']:
- if each.value == '10.254.221.140':
- times+=1
- print(times)
- tongji.active['K2']=times
-
-
-
- tongji.save('./waf策略统计.xlsx')
复制代码
|
|