def write_status_report_and_pivot_table_in_xlsx(self, row_list, output_dir, report_name, vs_level_status):
    '\n        This method writes the status and make pivot table in excel sheet\n        :param row_list:\n        :param output_dir:\n        :param report_name:\n        :param vs_level_status:\n        :return:\n        '
    global total_count
    global progressbar_count
    if vs_level_status:
        fieldnames = ['Line Number', 'Netscaler Command', 'Object Name', 'Full Command', 'Status', 'Skipped settings', 'Indirect mapping', 'Not Applicable', 'User Ignored', 'Overall skipped settings', 'Complexity Level', 'VS Reference', 'AVI Object']
    else:
        fieldnames = ['Line Number', 'Netscaler Command', 'Object Name', 'Full Command', 'Status', 'Skipped settings', 'Indirect mapping', 'Not Applicable', 'User Ignored', 'Complexity Level', 'AVI Object']
    xlsx_report = ((output_dir + os.path.sep) + ('%s-ConversionStatus.xlsx' % report_name))
    status_wb = Workbook(xlsx_report)
    status_ws = status_wb.add_worksheet('Status Sheet')
    status_ws.freeze_panes(1, 0)
    first_row = 0
    for header in fieldnames:
        col = fieldnames.index(header)
        status_ws.write(first_row, col, header)
    row = 1
    for row_data in row_list:
        progressbar_count += 1
        for (_key, _value) in row_data.items():
            if (_key in fieldnames):
                col = fieldnames.index(_key)
                status_ws.write(row, col, _value)
        msg = 'Writing excel sheet started...'
        self.print_progress_bar(progressbar_count, total_count, msg, prefix='Progress', suffix='')
        row += 1
    status_wb.close()
    df = pandas.DataFrame(row_list, columns=fieldnames)
    pivot_table = pandas.pivot_table(df, index=['Status', 'Netscaler Command'], values=[], aggfunc=[len], fill_value=0)
    pivot_df = pandas.DataFrame(pivot_table)
    master_book = load_workbook(xlsx_report)
    master_writer = pandas.ExcelWriter(xlsx_report, engine='openpyxl')
    master_writer.book = master_book
    pivot_df.to_excel(master_writer, 'Pivot Sheet')
    master_writer.save()
This method writes the status and make pivot table in excel sheet
:param row_list:
:param output_dir:
:param report_name:
:param vs_level_status:
:return:
def write_status_report_and_pivot_table_in_xlsx(self, row_list, output_dir, report_name, vs_level_status):
    '\n        This method writes the status and make pivot table in excel sheet\n        :param row_list:\n        :param output_dir:\n        :param report_name:\n        :param vs_level_status:\n        :return:\n        '
    global total_count
    global progressbar_count
    if vs_level_status:
        fieldnames = ['Line Number', 'Netscaler Command', 'Object Name', 'Full Command', 'Status', 'Skipped settings', 'Indirect mapping', 'Not Applicable', 'User Ignored', 'Overall skipped settings', 'Complexity Level', 'VS Reference', 'AVI Object']
    else:
        fieldnames = ['Line Number', 'Netscaler Command', 'Object Name', 'Full Command', 'Status', 'Skipped settings', 'Indirect mapping', 'Not Applicable', 'User Ignored', 'Complexity Level', 'AVI Object']
    xlsx_report = ((output_dir + os.path.sep) + ('%s-ConversionStatus.xlsx' % report_name))
    status_wb = Workbook(xlsx_report)
    status_ws = status_wb.add_worksheet('Status Sheet')
    status_ws.freeze_panes(1, 0)
    first_row = 0
    for header in fieldnames:
        col = fieldnames.index(header)
        status_ws.write(first_row, col, header)
    row = 1
    for row_data in row_list:
        progressbar_count += 1
        for (_key, _value) in row_data.items():
            if (_key in fieldnames):
                col = fieldnames.index(_key)
                status_ws.write(row, col, _value)
        msg = 'Writing excel sheet started...'
        self.print_progress_bar(progressbar_count, total_count, msg, prefix='Progress', suffix=)
        row += 1
    status_wb.close()
    df = pandas.DataFrame(row_list, columns=fieldnames)
    pivot_table = pandas.pivot_table(df, index=['Status', 'Netscaler Command'], values=[], aggfunc=[len], fill_value=0)
    pivot_df = pandas.DataFrame(pivot_table)
    master_book = load_workbook(xlsx_report)
    master_writer = pandas.ExcelWriter(xlsx_report, engine='openpyxl')
    master_writer.book = master_book
    pivot_df.to_excel(master_writer, 'Pivot Sheet')
    master_writer.save()