def write_excel(asset_all): data = [] now = datetime.datetime.now().strftime('%Y_%m_%d_%H_%M') file_name = 'cmdb_excel_' + now + '.xlsx' workbook = xlsxwriter.Workbook('static/files/excels/%s' % file_name) worksheet = workbook.add_worksheet(u'CMDB数据') worksheet.set_first_sheet() worksheet.set_column('A:E', 15) worksheet.set_column('F:F', 40) worksheet.set_column('G:Z', 15) title = [ u'主机名', u'IP', u'IDC', u'所属主机组', u'操作系统', u'CPU', u'内存(G)', u'硬盘(G)', u'机柜位置', u'MAC', u'远控IP', u'机器状态', u'备注' ] for asset in asset_all: group_list = [] for p in asset.group.all(): group_list.append(p.name) disk = get_disk_info(asset.disk) group_all = '/'.join(group_list) status = asset.get_status_display() idc_name = asset.idc.name if asset.idc else u'' system_type = asset.system_type if asset.system_type else u'' system_version = asset.system_version if asset.system_version else u'' system_os = unicode(system_type) + unicode(system_version) alter_dic = [ asset.hostname, asset.ip, idc_name, group_all, system_os, asset.cpu, asset.memory, disk, asset.cabinet, asset.mac, asset.remote_ip, status, asset.comment ] data.append(alter_dic) format = workbook.add_format() format.set_border(1) format.set_align('center') format.set_align('vcenter') format.set_text_wrap() format_title = workbook.add_format() format_title.set_border(1) format_title.set_bg_color('#cccccc') format_title.set_align('center') format_title.set_bold() format_ave = workbook.add_format() format_ave.set_border(1) format_ave.set_num_format('0.00') worksheet.write_row('A1', title, format_title) i = 2 for alter_dic in data: location = 'A' + str(i) worksheet.write_row(location, alter_dic, format) i += 1 workbook.close() ret = (True, file_name) return ret
def write_excel(asset_all): data = [] now = datetime.datetime.now().strftime('%Y_%m_%d_%H_%M') file_name = 'cmdb_excel_' + now + '.xlsx' workbook = xlsxwriter.Workbook('static/files/excels/%s' % file_name) worksheet = workbook.add_worksheet(u'CMDB数据') worksheet.set_first_sheet() worksheet.set_column('A:E', 15) worksheet.set_column('F:F', 40) worksheet.set_column('G:Z', 15) title = [u'主机名', u'IP', u'IDC', u'所属主机组', u'操作系统', u'CPU', u'内存(G)', u'硬盘(G)', u'机柜位置', u'MAC', u'远控IP', u'机器状态', u'备注'] for asset in asset_all: group_list = [] for p in asset.group.all(): group_list.append(p.name) disk = get_disk_info(asset.disk) group_all = '/'.join(group_list) status = asset.get_status_display() idc_name = asset.idc.name if asset.idc else u'' system_type = asset.system_type if asset.system_type else u'' system_version = asset.system_version if asset.system_version else u'' system_os = unicode(system_type) + unicode(system_version) alter_dic = [asset.hostname, asset.ip, idc_name, group_all, system_os, asset.cpu, asset.memory, disk, asset.cabinet, asset.mac, asset.remote_ip, status, asset.comment] data.append(alter_dic) format = workbook.add_format() format.set_border(1) format.set_align('center') format.set_align('vcenter') format.set_text_wrap() format_title = workbook.add_format() format_title.set_border(1) format_title.set_bg_color('#cccccc') format_title.set_align('center') format_title.set_bold() format_ave = workbook.add_format() format_ave.set_border(1) format_ave.set_num_format('0.00') worksheet.write_row('A1', title, format_title) i = 2 for alter_dic in data: location = 'A' + str(i) worksheet.write_row(location, alter_dic, format) i += 1 workbook.close() ret = (True, file_name) return ret
def write_excel(asset_all): data = [] now = datetime.datetime.now().strftime("%Y_%m_%d_%H_%M") file_name = "cmdb_excel_" + now + ".xlsx" workbook = xlsxwriter.Workbook("static/files/excels/%s" % file_name) worksheet = workbook.add_worksheet(u"CMDB数据") worksheet.set_first_sheet() worksheet.set_column("A:E", 15) worksheet.set_column("F:F", 40) worksheet.set_column("G:Z", 15) title = [ u"主机名", u"IP", u"IDC", u"所属主机组", u"操作系统", u"CPU", u"内存(G)", u"硬盘(G)", u"机柜位置", u"MAC", u"远控IP", u"机器状态", u"备注", ] for asset in asset_all: group_list = [] for p in asset.group.all(): group_list.append(p.name) disk = get_disk_info(asset.disk) group_all = "/".join(group_list) status = asset.get_status_display() idc_name = asset.idc.name if asset.idc else u"" system_type = asset.system_type if asset.system_type else u"" system_version = asset.system_version if asset.system_version else u"" system_os = unicode(system_type) + unicode(system_version) alter_dic = [ asset.hostname, asset.ip, idc_name, group_all, system_os, asset.cpu, asset.memory, disk, asset.cabinet, asset.mac, asset.remote_ip, status, asset.comment, ] data.append(alter_dic) format = workbook.add_format() format.set_border(1) format.set_align("center") format.set_align("vcenter") format.set_text_wrap() format_title = workbook.add_format() format_title.set_border(1) format_title.set_bg_color("#cccccc") format_title.set_align("center") format_title.set_bold() format_ave = workbook.add_format() format_ave.set_border(1) format_ave.set_num_format("0.00") worksheet.write_row("A1", title, format_title) i = 2 for alter_dic in data: location = "A" + str(i) worksheet.write_row(location, alter_dic, format) i += 1 workbook.close() ret = (True, file_name) return ret