Function generate_error_file

backend/apps/system/crud/user_excel.py:175–238

(error_list: list[RowValidator], head_list: list[str])

    return validator

def generate_error_file(error_list: list[RowValidator], head_list: list[str]) -> str:
    # If no errors, return empty string
    if not error_list:
        return ""

    # Build DataFrame from error rows (only include rows that had errors)
    df_rows = [err.row for err in error_list]
    df = pd.DataFrame(df_rows, columns=head_list)

    tmp = tempfile.NamedTemporaryFile(delete=False, suffix=".xlsx")
    tmp_name = tmp.name
    tmp.close()

    with pd.ExcelWriter(tmp_name, engine='xlsxwriter', engine_kwargs={'options': {'strings_to_numbers': False}}) as writer:
        df.to_excel(writer, sheet_name='Errors', index=False)

        workbook = writer.book
        worksheet = writer.sheets['Errors']

        # header format similar to downTemplate
        header_format = workbook.add_format({
            'bold': True,
            'font_size': 12,
            'font_name': '微软雅黑',
            'align': 'center',
            'valign': 'vcenter',
            'border': 0,
            'text_wrap': False,
        })

        # apply header format and column widths
        for i, col in enumerate(df.columns):
            max_length = max(
                len(str(col).encode('utf-8')) * 1.1,
                (df[col].astype(str)).apply(len).max() if len(df) > 0 else 0
            )
            worksheet.set_column(i, i, max_length + 12)
            worksheet.write(0, i, col, header_format)

        worksheet.set_row(0, 30)
        for row_idx in range(1, len(df) + 1):
            worksheet.set_row(row_idx, 25)

        red_format = workbook.add_format({'font_color': 'red'})

        # Add comments and set red font for each erroneous cell.
        # Note: pandas wrote header at row 0, data starts from row 1 in the sheet.
        for sheet_row_idx, err in enumerate(error_list, start=1):
            for col_idx, message in err.error_info.items():
                if message:
                    comment_text = str(message)
                    worksheet.write_comment(sheet_row_idx, col_idx, comment_text)
                    try:
                        cell_value = df.iat[sheet_row_idx - 1, col_idx]
                    except Exception:
                        cell_value = None
                    worksheet.write(sheet_row_idx, col_idx, cell_value, red_format)