错误处理最佳实践¶
使用异常处理¶
from symphra_excel.utils.exceptions import WorksheetNotFoundError
try:
sheet = wb.get_worksheet("数据")
except WorksheetNotFoundError:
sheet = wb.create_worksheet("数据")
验证输入¶
from symphra_excel.utils import validate_cell_address
if validate_cell_address(cell):
sheet.set_cell_value(cell, value)
else:
raise ValueError(f"无效地址: {cell}")