如何用Python无路径打开Excel表格？跨设备运行代码方法咨询

Great questions! Let's break this down clearly—there's no truly "path-free" way to open a file (since operating systems need a way to locate it), but we can make path handling invisible or ensure your code works across computers easily.

1. "Path-less" approaches to open Excel in Python #

While you can't avoid the OS needing to find the file, you can eliminate hardcoded absolute paths to make it feel "path-free":

• Use relative paths with co-located files: If your Python script and Excel file are in the same folder, just use the filename directly. For example:

  import pandas as pd
  # No full path needed—script and Excel are in the same directory
  df = pd.read_excel("your_file.xlsx")
  

• Dynamically get the script's directory: Use __file__ to auto-detect where your script is running, then build the path to the Excel file. This works even if you move the entire folder to another location:

  import pandas as pd
  import os
  
  # Get the folder where your script lives
  script_dir = os.path.dirname(os.path.abspath(__file__))
  # Build path to Excel file (same folder as script)
  excel_path = os.path.join(script_dir, "your_file.xlsx")
  df = pd.read_excel(excel_path)
  

2. Make your code work on other computers (e.g., via email) #

There are three reliable methods to ensure your code opens the Excel file on a target machine:

Method 1: Package script + Excel into a standalone executable #

Use PyInstaller to bundle your Python code and Excel file into a single .exe (Windows) or .app (Mac)—the recipient doesn't need Python installed at all.

1. Install PyInstaller:

   pip install pyinstaller
   

2. Place your script and Excel file in the same folder, using the dynamic path method above in your script.
3. Run the packaging command:
   • Windows:

     pyinstaller --onefile --add-data "your_file.xlsx;." your_script.py
     

   • Mac/Linux:

     pyinstaller --onefile --add-data "your_file.xlsx:." your_script.py
     

4. Send the generated .exe (from the dist folder) to the recipient—they just double-click it to run.

Method 2: Embed the Excel file directly in your script #

For small Excel files, convert the file to a Base64 string and embed it in your code. The script will decode it to a temporary file when running:

import base64
import tempfile
import pandas as pd
import os

# Replace this with your Excel file's Base64 string (use an online Base64 encoder for your file)
EXCEL_BASE64 = """<paste your Base64 string here>"""

# Decode and create a temporary Excel file
decoded_excel = base64.b64decode(EXCEL_BASE64)
with tempfile.NamedTemporaryFile(suffix=".xlsx", delete=False) as temp_file:
    temp_file.write(decoded_excel)
    temp_path = temp_file.name

# Open and use the Excel file
df = pd.read_excel(temp_path)
print("Successfully opened Excel file:")
print(df.head())

# Clean up the temporary file (optional but tidy)
os.unlink(temp_path)

Now you only need to send the single script file—no separate Excel needed. Note: Base64 encoding makes the script larger, so this is best for small files.

Method 3: Send script + Excel as a zip folder #

If you don't want to package, just:

• Keep your script and Excel file in the same folder
• Zip the folder and email it to the recipient
• Instruct them to extract the folder without separating the script and Excel file
• Use the relative path or dynamic directory method in your script (as shown earlier)
• Ensure the recipient has Python installed along with required libraries (e.g., pandas, openpyxl for .xlsx files)

Bonus: Opening the Excel desktop app (not just reading data) #

If you want to launch the actual Excel application (not just read data into Python), use win32com.client (Windows-only, requires Excel installed on the target machine):

import win32com.client as win32
import os

script_dir = os.path.dirname(os.path.abspath(__file__))
excel_path = os.path.join(script_dir, "your_file.xlsx")

# Launch Excel and open the file
excel_app = win32.gencache.EnsureDispatch('Excel.Application')
excel_app.Visible = True  # Make Excel window visible
workbook = excel_app.Workbooks.Open(excel_path)

内容的提问来源于stack exchange，提问作者Eve M