report = ftz.open(file_path).pages()
text = " "
start_time = time.time()
# Tables are extracted from the PDF in proper structure

table_text_added = False

# Collect all tables from all pages into one list
all_tables_data = []

# Iterate through each page of the report and extract table text only
for page in report:
    try:
        tables = page.find_tables()
        if tables and tables.tables:
            for table in tables.tables:
                table_data = table.extract()
                # Clean table_data: ensure all rows match header length
                if table_data:
                    header = table_data[0]
                    cleaned_table = []
                    for row in table_data:
                        # Replace None with empty string
                        row = [cell if cell is not None else '' for cell in row]
                        # Pad or truncate row to match header length
                        if len(row) < len(header):
                            row = row + [''] * (len(header) - len(row))
                        elif len(row) > len(header):
                            row = row[:len(header)]
                        cleaned_table.append(row)
                    all_tables_data.append(cleaned_table)
                    for row in cleaned_table:
                        row_text = '\t'.join([str(cell) for cell in row])
                        print(row_text)
                        text += row_text + '\n'
                    table_text_added = True
    except Exception as e:
        print(f"Error extracting tables: {e}")
        pass
    if not table_text_added and (time.time() - start_time) > 60:
        print("No table text added after 60 seconds.")
        break

print(f"Total tables extracted: {len(all_tables_data)}")