import pandas as pd
from tqdm import tqdm
from tqdm.notebook import tqdm as tqdm_notebook
# Function to save DataFrame to Excel with a progress bar
def save_to_excel_with_progress(df, file_path):
    try:
        # Determine the appropriate tqdm function based on the environment
        tqdm_func = tqdm_notebook if "ipykernel" in sys.modules else tqdm
        # Create a progress bar for the saving process
        with tqdm_func(total=1, desc="Saving to Excel") as pbar:
            # Save the DataFrame to Excel
            df.to_excel(file_path, index=False)
            pbar.update(1)  # Update the progress bar when the saving is complete
            print(f"Saved to {file_path}")
    except Exception as e:
        print(f"Error: {e}")
# Example usage:
data = {'Name': ['Alice', 'Bob', 'Charlie'],
        'Age': [25, 30, 35]}
df = pd.DataFrame(data)
save_to_excel_with_progress(df, 'example.xlsx')