Python 2.7：保存Excel前检测文件是否被Microsoft Excel打开

Absolutely, this is such a common frustration when automating Excel reports—let’s walk through reliable ways to detect if the file is locked, so you can show a friendly error instead of letting your script crash.

核心思路 #

When Microsoft Excel opens a file on Windows, it does two key things:

• Creates a hidden temporary file (like ~$reportFinal.xlsx) in the same directory
• Locks the original file to prevent concurrent writes

We can leverage either (or both) of these behaviors to detect if the file is in use.

方法1：跨平台文件锁定检测（最可靠） #

This method works on Windows, macOS, and Linux—it tries to open the file in exclusive write mode. If the file is locked (by Excel or any other program), the open operation will throw an error.

import os

def is_file_locked(file_path):
    # 如果文件不存在，直接返回可用
    if not os.path.exists(file_path):
        return False
    
    try:
        # 尝试以独占读写模式打开文件
        with open(file_path, 'r+b') as file_handle:
            return False
    except PermissionError:
        # 权限错误通常意味着文件被占用
        return True
    except OSError as e:
        # 其他系统级错误（比如文件被锁定）
        return True

方法2：检测Excel的临时文件（Windows专属） #

Excel creates a hidden ~$ prefixed file when it opens a document. We can check for this file to specifically detect if Excel has the document open.

def is_excel_file_open(file_path):
    if not os.path.exists(file_path):
        return False
    
    dir_name = os.path.dirname(file_path)
    file_name = os.path.basename(file_path)
    # 构建Excel临时文件路径
    excel_temp_file = os.path.join(dir_name, f"~${file_name}")
    
    return os.path.exists(excel_temp_file)

Heads up about this method: #

• It only works for Microsoft Excel on Windows (LibreOffice/Numbers don’t create these temp files)
• If Excel crashes unexpectedly, the temp file might linger, causing a false positive

整合到你的脚本中 #

Combine both methods for the most accurate detection, and replace your original save logic with this:

from openpyxl import Workbook
import os

def is_file_safe_to_write(file_path):
    if not os.path.exists(file_path):
        return True
    
    # 先检查Excel专属临时文件
    dir_name = os.path.dirname(file_path)
    file_name = os.path.basename(file_path)
    excel_temp_file = os.path.join(dir_name, f"~${file_name}")
    if os.path.exists(excel_temp_file):
        return False
    
    # 再用跨平台锁定检测确认
    try:
        with open(file_path, 'r+b') as file_handle:
            return True
    except (PermissionError, OSError):
        return False

# 你的原有路径设置（建议用os.path.join避免路径拼接错误）
reportsPath = "./your-reports-folder"
excelFilePath = os.path.join(reportsPath, "reportFinal.xlsx")

if is_file_safe_to_write(excelFilePath):
    # 这里是你生成Workbook的代码（示例）
    wb = Workbook()
    ws = wb.active
    ws["A1"] = "Sample Report Data"
    
    # 保存文件
    wb.save(excelFilePath)
    print("✅ 报告已成功保存！")
else:
    print("❌ 错误：目标Excel文件正在被Microsoft Excel打开，请先关闭文件后重试。")

Pro Tips: #

• Always use os.path.join() instead of string concatenation (+ "/...") to avoid path issues across different operating systems
• The combined method gives you the best of both worlds: it detects Excel-specific locks and general file locks from other programs
• You can extend the error message to tell users where to find the file if needed

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