通过 python 创建 Excel 文件, 可导入阿里云域名解析!
因工作需要编写的脚本, 没啥难度, 分享出来供大家参考
示例代码:
- #!/usr/bin/env python
- #coding:utf-8
- import xlsxwriter
- serverid = list(range(001,016))
- ym = ". 域名"
- iplist = [
- "192.168.112.100",
- "192.168.112.101",
- "192.168.112.102"
- ]
- row = 0
- def dns():
- global row
- workbook = xlsxwriter.Workbook('dns.xlsx')
- worksheet = workbook.add_worksheet()
- for i in range(5):
- for inter_ip in iplist:
- server_id = str(serverid.pop(0))
- server_idstr = "s%s%s" %(server_id,ym)
- a = ['A', server_idstr, '默认', inter_ip, '--','600','0']
- for l in range(7):
- worksheet.write(row,l,a[l])
- row += 1
- workbook.close()
- dns()
来源: http://www.bubuko.com/infodetail-3102105.html