根据CVE编号爬取相关信息_输出cve 查询详细信息

import openpyxl as xcl


def init_wb():
    wb = xcl.Workbook()
    sheet = wb.active
    sheet.title = "CVE INFO"
    sheet["A1"] = "CVE NO."
    sheet["B1"] = "V2"
    sheet["C1"] = "V3"
    sheet["D1"] = "Summary"
    # 设置单元格式
    # A1居右,B1, C1居中,D1长度为256
    # end
    sheet.column_dimensions["A"].width = 18
    sheet.column_dimensions["D"].width = 196
    return wb, sheet


def write_cveno_lst(src_file):
    wb, sheet = init_wb()
    with open(src_file, "r") as src:
        lst = src.readlines()
        i = 2
        for cveno in lst:
            sheet["A%d" % i].value = cveno.replace("\n", "")
            i += 1
    wb.save(src_file+".xlsx")


if __name__ == "__main__":
    # l2 是一个文本,每一行是一个cve编号
    write_cveno_lst("l2")

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34

from urll