Absolutely! You can absolutely package your Flask app into a standalone executable while ensuring your templates, static files, and Excel database work seamlessly. Let’s walk through exactly how to do this for your specific file structure:

Step 1: Update Your Flask App Paths (Critical!) #

When PyInstaller packages your app, it extracts files to a temporary directory at runtime. Hardcoded relative paths won’t work anymore, so you need to adjust your app.py to use dynamic paths based on whether the app is running as a script or a packaged executable.

Here’s the modified app.py code:

from flask import Flask, render_template, request
from openpyxl import load_workbook
import webbrowser
import sys
import os

def get_resource_path(relative_path):
    # Get absolute path to resource, works for dev and for PyInstaller
    try:
        # PyInstaller creates a temp folder and stores path in _MEIPASS
        base_path = sys._MEIPASS
    except Exception:
        base_path = os.path.abspath(".")

    return os.path.join(base_path, relative_path)

# Initialize Flask with dynamic paths for templates and static files
app = Flask(
    __name__,
    template_folder=get_resource_path('templates'),
    static_folder=get_resource_path('static')
)

# Example route to test template and static file loading
@app.route('/')
def index():
    # Load your Excel database using the dynamic path
    wb = load_workbook(get_resource_path('database.xlsx'))
    # Do something with the workbook if needed
    return render_template('Templates.html')

if __name__ == '__main__':
    # Open browser automatically after starting the app
    webbrowser.open('http://127.0.0.1:5000')
    app.run(debug=False)  # Disable debug mode for packaging!

Step 2: Create a PyInstaller Spec File (For Precise Configuration) #

PyInstaller uses spec files to define exactly what to include in the package. First, generate a basic spec file by running this command in your Main_Folder:

pyinstaller --name FlaskApp app.py

This will create a FlaskApp.spec file. Open it and modify the datas section to include your templates, static files, and Excel database. Here’s how the updated spec file should look:

# FlaskApp.spec
block_cipher = None

a = Analysis(
    ['app.py'],
    pathex=[],
    binaries=[],
    # Add all your non-code resources here
    datas=[
        ('templates', 'templates'),
        ('static', 'static'),
        ('database.xlsx', '.')
    ],
    hiddenimports=['openpyxl.styles', 'openpyxl.worksheet'],  # Fixes openpyxl import issues
    hookspath=[],
    hooksconfig={},
    runtime_hooks=[],
    excludes=[],
    win_no_prefer_redirects=False,
    win_private_assemblies=False,
    cipher=block_cipher,
    noarchive=False,
)
pyz = PYZ(a.pure, a.zipped_data, cipher=block_cipher)

exe = EXE(
    pyz,
    a.scripts,
    a.binaries,
    a.zipfiles,
    a.datas,
    [],
    name='FlaskApp',
    debug=False,
    bootloader_ignore_signals=False,
    strip=False,
    upx=True,  # Optional: Compress the executable
    upx_exclude=[],
    runtime_tmpdir=None,
    console=True,  # Set to False if you don't want a command prompt window
    disable_windowed_traceback=False,
    argv_emulation=False,
    target_arch=None,
    codesign_identity=None,
    entitlements_file=None,
)

Step 3: Package the App with PyInstaller #

Run this command to build your executable using the spec file:

pyinstaller --onefile FlaskApp.spec

Once it finishes, you’ll find the executable in the dist folder inside your Main_Folder.

Key Notes to Avoid Issues #

• Disable Debug Mode: Always set debug=False in app.run() when packaging—debug mode can cause crashes in the executable.
• Test the Executable: After building, run the exe and check if:
  • The template loads correctly (you see your HTML page)
  • The static image (Files.png) displays properly
  • The Excel database is read without errors
• OpenPyXL Hidden Imports: The hiddenimports in the spec file ensures PyInstaller includes all parts of openpyxl that aren’t automatically detected.

That’s it! Your standalone executable will now have access to all your templates, static files, and Excel database just like the original script.

内容的提问来源于stack exchange，提问作者Abdul Hadi Bharara