![](\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2026\/09\/20260911133330-6aa4032a23ef6.png\")
<\/p>\n<\/p>\n
\u00a0\u4e00\u3001\u524d\u7f6e\u51c6\u5907<\/p>\n
\u00a0<\/p>\n
1. \u73af\u5883<\/p>\n
\u00a0<\/p>\n
– Python 3.8+（\u63a8\u8350 3.10\/3.11，\u907f\u514d\u592a\u65b0\u7684\u7248\u672c\u5e93\u517c\u5bb9\u95ee\u9898）<\/p>\n
– IDE：VSCode（\u63a8\u8350） \/ PyCharm \u793e\u533a\u7248<\/p>\n
– \u5fc5\u5907\u5de5\u5177：\u00a0pip\u00a0，\u5efa\u8bae\u4f7f\u7528\u865a\u62df\u73af\u5883，\u9632\u6b62\u5305\u7248\u672c\u6df7\u4e71<\/p>\n
\u00a0<\/p>\n
bash<\/p>\n
# \u521b\u5efa\u865a\u62df\u73af\u5883（\u9879\u76ee\u76ee\u5f55\u6267\u884c）<\/p>\n
python -m venv venv<\/p>\n
\u00a0<\/p>\n
# Windows\u6fc0\u6d3b<\/p>\n
venv\\\\Scripts\\\\activate<\/p>\n
# Mac\/Linux\u6fc0\u6d3b<\/p>\n
source venv\/bin\/activate<\/p>\n
\u00a0<\/p>\n
# \u9000\u51fa\u865a\u62df\u73af\u5883：deactivate<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u597d\u4e60\u60ef：\u6bcf\u4e2a\u72ec\u7acb\u811a\u672c\u9879\u76ee\u5355\u72ec\u5efa\u865a\u62df\u73af\u5883，\u9879\u76ee\u6839\u76ee\u5f55\u4fdd\u5b58\u4f9d\u8d56\u6e05\u5355<\/p>\n
\u00a0<\/p>\n
bash<\/p>\n
pip freeze > requirements.txt # \u5bfc\u51fa<\/p>\n
pip install -r requirements.txt # \u6062\u590d<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
2. \u9ad8\u9891\u5e38\u7528\u5e93（\u65e5\u5e38\u81ea\u52a8\u5316）<\/p>\n
\u00a0<\/p>\n
\u53ea\u5217\u5b89\u5168\u3001\u901a\u7528\u3001\u5b98\u65b9\/\u4e3b\u6d41\u5e93，\u4e0d\u63a8\u8350\u7070\u8272\u5de5\u5177<\/p>\n
\u00a0<\/p>\n
– \u6587\u4ef6\/\u8def\u5f84：\u00a0os\u00a0\u3001\u00a0pathlib\u00a0（\u6807\u51c6\u5e93，\u4f18\u5148\u7528 pathlib）\u3001\u00a0shutil\u00a0<\/p>\n
– Excel\/CSV：\u00a0pandas\u00a0\u3001\u00a0openpyxl\u00a0（\u8bfb\u5199xlsx）\u3001\u00a0csv\u00a0(\u6807\u51c6\u5e93)<\/p>\n
– \u7f51\u7edc\u8bf7\u6c42：\u00a0requests\u00a0（http）；\u26a0\ufe0f\u9075\u5b88\u7f51\u7ad9robots.txt，\u4e0d\u8981\u9ad8\u9891\u66b4\u529b\u8bf7\u6c42<\/p>\n
– \u7f51\u9875\u6a21\u62df\u64cd\u4f5c：\u00a0selenium\u00a0 \/ \u00a0playwright\u00a0（\u6d4f\u89c8\u5668\u771f\u5b9e\u64cd\u4f5c，\u9002\u5408\u6709JS\u6e32\u67d3\u7684\u9875\u9762，\u4ec5\u64cd\u4f5c\u81ea\u5df1\u6709\u6743\u9650\u7684\u7cfb\u7edf\/\u5b98\u7f51）<\/p>\n
– \u5b9a\u65f6：\u00a0schedule\u00a0（\u7b80\u5355\u5b9a\u65f6）；\u590d\u6742\u7528\u7cfb\u7edf\u8ba1\u5212\u4efb\u52a1（Windows\u4efb\u52a1\u8ba1\u5212\u7a0b\u5e8f \/ Linux crontab），\u4e0d\u5efa\u8bae\u811a\u672c\u5e38\u9a7b\u5faa\u73af<\/p>\n
– \u53d1\u6d88\u606f\u901a\u77e5：\u00a0smtplib\u00a0(\u90ae\u4ef6，\u6807\u51c6\u5e93)\u3001\u4f01\u4e1a\u5fae\u4fe1\/\u9489\u9489\u673a\u5668\u4ebawebhook<\/p>\n
– \u914d\u7f6e\u6587\u4ef6：\u00a0python-dotenv\u00a0，\u628a\u5bc6\u94a5\u3001\u8d26\u53f7\u653e \u00a0.env\u00a0，\u4e0d\u8981\u786c\u7f16\u7801\u5230\u4ee3\u7801\u91cc！<\/p>\n
\u00a0<\/p>\n
\u5b89\u88c5\u793a\u4f8b：<\/p>\n
\u00a0<\/p>\n
bash<\/p>\n
pip install requests openpyxl pandas schedule python-dotenv playwright<\/p>\n
# playwright\u989d\u5916\u5b89\u88c5\u6d4f\u89c8\u5668\u9a71\u52a8<\/p>\n
playwright install chrome<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u26a0\ufe0f\u7ea2\u7ebf：\u4e0d\u8981\u7528\u811a\u672c\u505a：\u672a\u6388\u6743\u722c\u53d6\u3001\u6279\u91cf\u6ce8\u518c\u3001\u5237\u5355\u3001\u7206\u7834\u3001\u53d1\u9001\u5783\u573e\u6d88\u606f\u3001\u8d8a\u6743\u64cd\u4f5c\u516c\u53f8\u7cfb\u7edf\u3002\u811a\u672c\u53ea\u80fd\u7528\u4e8e\u4f60\u6709\u6743\u64cd\u4f5c\u7684\u4e1a\u52a1\u3002<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u4e8c\u3001\u811a\u672c\u6807\u51c6\u5f00\u53d1\u6d41\u7a0b（\u975e\u5e38\u91cd\u8981，\u907f\u514d\u5199\u51fa\u201c\u4e00\u6b21\u6027\u4e71\u7801\u811a\u672c\u201d）<\/p>\n
\u00a0<\/p>\n
\u6d41\u7a0b：\u660e\u786e\u76ee\u6807 \u2192 \u62c6\u89e3\u6b65\u9aa4 \u2192 \u624b\u52a8\u8dd1\u901a\u6d41\u7a0b \u2192 \u7f16\u5199\u811a\u672c \u2192 \u5f02\u5e38\u5904\u7406 \u2192 \u65e5\u5fd7 \u2192 \u914d\u7f6e\u5206\u79bb \u2192 \u6d4b\u8bd5 \u2192 \u90e8\u7f72\u5b9a\u65f6 \u2192 \u7ef4\u62a4<\/p>\n
\u00a0<\/p>\n
1. \u660e\u786e\u76ee\u6807（\u5148\u5199\u4e0b\u6765！）<\/p>\n
\u00a0<\/p>\n
\u56de\u7b544\u4e2a\u95ee\u9898：<\/p>\n
\u00a0<\/p>\n
1.\u00a0\u811a\u672c\u505a\u4ec0\u4e48？（\u4e00\u53e5\u8bdd，\u4e0d\u8981\u6a21\u7cca）<\/p>\n
\u574f\u4f8b\u5b50：\u5904\u7406\u6570\u636e<\/p>\n
\u597d\u4f8b\u5b50：\u00a0\u81ea\u52a8\u8bfb\u53d6downloads\u6587\u4ef6\u5939\u91cc\u7684\u9500\u552eexcel，\u6c47\u603b\u540e\u751f\u6210report.csv\u4fdd\u5b58\u5230.\/output，\u5e76\u901a\u8fc7\u9489\u9489\u673a\u5668\u4eba\u53d1\u901a\u77e5\u00a0<\/p>\n
2.\u00a0\u8f93\u5165\u662f\u4ec0\u4e48：\u6587\u4ef6\u8def\u5f84？\u63a5\u53e3？\u7f51\u9875？<\/p>\n
3.\u00a0\u8f93\u51fa\u662f\u4ec0\u4e48：\u751f\u6210\u6587\u4ef6？\u53d1\u9001\u6d88\u606f？\u4fee\u6539\u6587\u4ef6？<\/p>\n
4.\u00a0\u8fb9\u754c & \u7981\u6b62\u884c\u4e3a：\u54ea\u4e9b\u60c5\u51b5\u4e0d\u8981\u6267\u884c？\u4e0d\u8981\u5220\u9664\u6e90\u6587\u4ef6！\u4e0d\u8981\u8986\u76d6\u91cd\u8981\u6570\u636e！<\/p>\n
\u00a0<\/p>\n
\u539f\u5219：\u4f18\u5148\u53ea\u8bfb，\u4e0d\u5220\u9664\u3001\u4e0d\u4fee\u6539\u539f\u6570\u636e；\u8f93\u51fa\u653e\u72ec\u7acb output \u6587\u4ef6\u5939\u3002<\/p>\n
\u00a0<\/p>\n
2. \u62c6\u89e3\u6b65\u9aa4（\u4f2a\u4ee3\u7801\u5148\u5199，\u518d\u5199\u4ee3\u7801）<\/p>\n
\u00a0<\/p>\n
\u4e0d\u8981\u4e0a\u6765\u5c31\u6572\u4ee3\u7801！\u5148\u7528\u6ce8\u91ca\u5199\u51fa\u6d41\u7a0b\u3002<\/p>\n
\u793a\u4f8b：<\/p>\n
\u00a0<\/p>\n
python<\/p>\n
"""<\/p>\n
\u81ea\u52a8\u5316\u811a\u672c：\u9500\u552e\u6570\u636e\u6c47\u603b<\/p>\n
\u6b65\u9aa4：<\/p>\n
1. \u8bfb\u53d6 .\/download\/*.xlsx<\/p>\n
2. \u6821\u9a8c\u6587\u4ef6\u662f\u5426\u5b58\u5728，\u4e0d\u5b58\u5728\u5219\u65e5\u5fd7\u63d0\u793a\u9000\u51fa<\/p>\n
3. \u9010\u4e2a\u8bfb\u53d6，\u63d0\u53d6\u3010\u65e5\u671f，\u95e8\u5e97，\u9500\u552e\u989d\u3011\u4e09\u5217<\/p>\n
4. \u5408\u5e76\u6240\u6709\u6570\u636e，\u6309\u65e5\u671f\u6c42\u548c<\/p>\n
5. \u8f93\u51fa\u5230 .\/output\/report_yyyyMMdd.csv<\/p>\n
6. \u901a\u8fc7\u9489\u9489webhook\u53d1\u9001\u62a5\u544a\u6458\u8981<\/p>\n
7. \u8bb0\u5f55\u65e5\u5fd7，\u6210\u529f\/\u5931\u8d25\u90fd\u8bb0\u5f55<\/p>\n
"""<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
3. \u624b\u52a8\u5b8c\u6574\u8dd1\u901a\u4e00\u904d<\/p>\n
\u00a0<\/p>\n
\u6bcf\u4e00\u6b65\u624b\u52a8\u64cd\u4f5c\u4e00\u904d，\u786e\u8ba4：<\/p>\n
\u00a0<\/p>\n
– \u6587\u4ef6\u683c\u5f0f\u3001\u5217\u540d\u3001\u63a5\u53e3\u53c2\u6570\u3001\u9875\u9762\u5143\u7d20\u3001\u62a5\u9519\u573a\u666f；<\/p>\n
– \u8bb0\u4e0b\u5bb9\u6613\u51fa\u9519\u70b9：\u7a7a\u6587\u4ef6\u3001\u5217\u7f3a\u5931\u3001\u7f51\u7edc\u8d85\u65f6\u3001\u6587\u4ef6\u88ab\u5360\u7528\u3002<\/p>\n
\u00a0<\/p>\n
4. \u7f16\u7801：\u9075\u5faa\u7b80\u6613\u811a\u672c\u89c4\u8303（\u201c\u53ef\u534a\u5e74\u540e\u81ea\u5df1\u8fd8\u770b\u5f97\u61c2\u201d）<\/p>\n
\u00a0<\/p>\n
📌\u89c4\u83031：\u76ee\u5f55\u7ed3\u6784（\u63a8\u8350）<\/p>\n
\u00a0<\/p>\n
\u5355\u4e2a\u811a\u672c\u9879\u76ee\u4e0d\u8981\u6240\u6709\u6587\u4ef6\u5806\u4e00\u8d77：<\/p>\n
\u00a0<\/p>\n
plaintext<\/p>\n
my_auto\/<\/p>\n
\u251c\u2500 main.py # \u4e3b\u811a\u672c\u5165\u53e3<\/p>\n
\u251c\u2500 .env # \u914d\u7f6e：\u5bc6\u94a5\u3001webhook\u3001\u8def\u5f84（\u4e0d\u8981\u63d0\u4ea4git！）<\/p>\n
\u251c\u2500 .gitignore # \u5ffd\u7565 venv\u3001.env\u3001output\u3001log<\/p>\n
\u251c\u2500 requirements.txt<\/p>\n
\u251c\u2500 input\/ # \u5f85\u5904\u7406\u8f93\u5165（\u6e90\u6587\u4ef6，\u811a\u672c\u53ea\u8bfb\u4e0d\u5220）<\/p>\n
\u251c\u2500 output\/ # \u751f\u6210\u7ed3\u679c，\u811a\u672c\u8f93\u51fa\u5230\u6b64<\/p>\n
\u2514\u2500 logs\/ # \u65e5\u5fd7<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u00a0.gitignore\u00a0\u53c2\u8003：<\/p>\n
\u00a0<\/p>\n
plaintext<\/p>\n
venv\/<\/p>\n
.env<\/p>\n
output\/<\/p>\n
logs\/<\/p>\n
*.xlsx<\/p>\n
*.csv<\/p>\n
__pycache__\/<\/p>\n
*.pyc<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
📌\u89c4\u83032：\u914d\u7f6e\u5206\u79bb，\u7981\u6b62\u786c\u7f16\u7801\u5bc6\u94a5\u3001\u8def\u5f84<\/p>\n
\u00a0<\/p>\n
\u4f7f\u7528 \u00a0python-dotenv\u00a0<\/p>\n
\u00a0<\/p>\n
\u00a0.env\u00a0 \u6587\u4ef6：<\/p>\n
\u00a0<\/p>\n
env<\/p>\n
DINGDING_WEBHOOK=https:\/\/xxx<\/p>\n
INPUT_DIR=".\/input"<\/p>\n
OUTPUT_DIR=".\/output"<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u00a0main.py\u00a0<\/p>\n
\u00a0<\/p>\n
python<\/p>\n
from dotenv import load_dotenv<\/p>\n
import os<\/p>\n
\u00a0<\/p>\n
load_dotenv() # \u52a0\u8f7d.env<\/p>\n
\u00a0<\/p>\n
DINGDING_WEBHOOK = os.getenv("DINGDING_WEBHOOK")<\/p>\n
INPUT_DIR = os.getenv("INPUT_DIR", ".\/input")<\/p>\n
OUTPUT_DIR = os.getenv("OUTPUT_DIR", ".\/output")<\/p>\n
\u00a0<\/p>\n
# \u81ea\u52a8\u521b\u5efa\u76ee\u5f55，\u907f\u514d\u4e0d\u5b58\u5728\u62a5\u9519<\/p>\n
os.makedirs(INPUT_DIR, exist_ok=True)<\/p>\n
os.makedirs(OUTPUT_DIR, exist_ok=True)<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u274c\u7981\u6b62：\u00a0webhook="https:\/\/\u5371\u9669\u786c\u7f16\u7801\u7684\u5730\u5740"\u00a0，\u4e00\u65e6\u4e0a\u4f20\u4ee3\u7801\u4ed3\u5e93，\u5bc6\u94a5\u6cc4\u9732\u4f1a\u88ab\u6ee5\u7528！<\/p>\n
\u00a0<\/p>\n
📌\u89c4\u83033：\u52a0\u4e0a\u65e5\u5fd7，\u4e0d\u8981\u53ea\u7528print<\/p>\n
\u00a0<\/p>\n
\u00a0print\u00a0 \u8c03\u8bd5\u53ef\u4ee5，\u6b63\u5f0f\u811a\u672c\u7528\u6807\u51c6\u5e93 \u00a0logging\u00a0，\u652f\u6301\u65f6\u95f4\u3001\u7ea7\u522b\u3001\u5199\u5165\u6587\u4ef6\u3002<\/p>\n
\u00a0<\/p>\n
\u65e5\u5fd7\u6a21\u677f\u76f4\u63a5\u590d\u5236：<\/p>\n
\u00a0<\/p>\n
python<\/p>\n
import logging<\/p>\n
from pathlib import Path<\/p>\n
\u00a0<\/p>\n
LOG_PATH = Path(".\/logs\/run.log")<\/p>\n
Path(".\/logs").mkdir(exist_ok=True)<\/p>\n
\u00a0<\/p>\n
logging.basicConfig(<\/p>\n
\u00a0 \u00a0 level=logging.INFO,<\/p>\n
\u00a0 \u00a0 format="%(asctime)s – %(levelname)s – %(message)s",<\/p>\n
\u00a0 \u00a0 handlers=[<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 logging.FileHandler(LOG_PATH, encoding="utf-8"),<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 logging.StreamHandler() # \u540c\u65f6\u63a7\u5236\u53f0\u8f93\u51fa<\/p>\n
\u00a0 \u00a0 ]<\/p>\n
)<\/p>\n
logger = logging.getLogger(__name__)<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u4f7f\u7528：<\/p>\n
\u00a0<\/p>\n
python<\/p>\n
logger.info("\u811a\u672c\u5f00\u59cb\u6267\u884c")<\/p>\n
logger.warning("\u672a\u627e\u5230\u6570\u636e\u6587\u4ef6")<\/p>\n
logger.error("\u8bfb\u53d6\u6587\u4ef6\u5f02\u5e38", exc_info=True) # exc_info=True\u6253\u5370\u5f02\u5e38\u5806\u6808<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u65e5\u5fd7\u539f\u5219：\u8bb0\u5f55\u505a\u4e86\u4ec0\u4e48\u3001\u8f93\u5165\u8f93\u51fa\u8def\u5f84\u3001\u5f02\u5e38\u539f\u56e0；\u4e0d\u8981\u5728\u65e5\u5fd7\u6253\u5370\u5bc6\u7801\u3001token\u3002<\/p>\n
\u00a0<\/p>\n
📌\u89c4\u83034：\u5fc5\u987b\u505a\u5f02\u5e38\u6355\u83b7，\u9632\u6b62\u811a\u672c\u4e2d\u9014\u9759\u9ed8\u5d29\u6e83<\/p>\n
\u00a0<\/p>\n
\u4e0d\u8981\u8d85\u5927try\u5305\u88f9\u5168\u90e8\u4ee3\u7801，\u5c3d\u91cf\u7ec6\u7c92\u5ea6\u6355\u83b7，\u533a\u5206\u4e0d\u540c\u9519\u8bef\u3002<\/p>\n
\u00a0<\/p>\n
\u793a\u4f8b\u8303\u5f0f：<\/p>\n
\u00a0<\/p>\n
python<\/p>\n
try:<\/p>\n
\u00a0 \u00a0 df = pd.read_excel(file_path)<\/p>\n
except FileNotFoundError:<\/p>\n
\u00a0 \u00a0 logger.error(f"\u6587\u4ef6\u4e0d\u5b58\u5728：{file_path}")<\/p>\n
except PermissionError:<\/p>\n
\u00a0 \u00a0 logger.error(f"\u6587\u4ef6\u88ab\u5360\u7528，\u65e0\u6cd5\u8bfb\u53d6：{file_path}")<\/p>\n
except Exception as e:<\/p>\n
\u00a0 \u00a0 logger.error(f"\u8bfb\u53d6\u5f02\u5e38 {file_path}", exc_info=True)<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u5e38\u89c1\u9700\u8981\u6355\u83b7：\u7f51\u7edc\u8d85\u65f6\u3001\u6587\u4ef6\u4e0d\u5b58\u5728\u3001\u6743\u9650\u4e0d\u8db3\u3001key\u7f3a\u5931\u3001\u5217\u4e0d\u5b58\u5728\u3002<\/p>\n
\u00a0<\/p>\n
\u4e0d\u63a8\u8350：<\/p>\n
\u00a0<\/p>\n
python<\/p>\n
try:<\/p>\n
\u00a0 \u00a0 \u4e00\u5927\u5768\u4ee3\u7801<\/p>\n
except:<\/p>\n
\u00a0 \u00a0 pass # \u541e\u6389\u6240\u6709\u9519\u8bef，\u4ec0\u4e48\u90fd\u4e0d\u8bb0\u5f55！\u707e\u96be！！<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
📌\u89c4\u83035：\u51fd\u6570\u5316，\u4e0d\u8981\u5199\u201c\u9762\u6761\u4ee3\u7801\u201d<\/p>\n
\u00a0<\/p>\n
\u5373\u4f7f\u5c0f\u811a\u672c，\u4e5f\u4e0d\u8981\u6240\u6709\u903b\u8f91\u5e73\u94fa\u3002\u5355\u4e00\u804c\u8d23\u51fd\u6570，\u4e00\u4e2a\u51fd\u6570\u53ea\u505a\u4e00\u4ef6\u4e8b\u3002<\/p>\n
\u00a0<\/p>\n
\u793a\u4f8b\u7ed3\u6784：<\/p>\n
\u00a0<\/p>\n
python<\/p>\n
def read_sales_file(filepath):<\/p>\n
\u00a0 \u00a0 """\u8bfb\u53d6\u5355\u4e2a\u9500\u552eExcel，\u8fd4\u56de\u6e05\u6d17\u540e\u7684DataFrame"""<\/p>\n
\u00a0 \u00a0 …<\/p>\n
\u00a0<\/p>\n
def merge_data(file_list):<\/p>\n
\u00a0 \u00a0 """\u5408\u5e76\u6570\u636e\u5e76\u6c47\u603b"""<\/p>\n
\u00a0 \u00a0 …<\/p>\n
\u00a0<\/p>\n
def save_report(df, out_path):<\/p>\n
\u00a0 \u00a0 """\u4fdd\u5b58\u62a5\u544a"""<\/p>\n
\u00a0 \u00a0 …<\/p>\n
\u00a0<\/p>\n
def send_ding_msg(webhook, content):<\/p>\n
\u00a0 \u00a0 """\u53d1\u9001\u9489\u9489\u901a\u77e5"""<\/p>\n
\u00a0 \u00a0 …<\/p>\n
\u00a0<\/p>\n
def main():<\/p>\n
\u00a0 \u00a0 logger.info("===== \u9500\u552e\u6c47\u603b\u811a\u672c\u542f\u52a8 =====")<\/p>\n
\u00a0 \u00a0 try:<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 # \u4e1a\u52a1\u6d41\u7a0b<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 …<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 logger.info("\u811a\u672c\u6267\u884c\u6210\u529f")<\/p>\n
\u00a0 \u00a0 except Exception as e:<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 logger.error("\u811a\u672c\u6574\u4f53\u6267\u884c\u5931\u8d25", exc_info=True)<\/p>\n
\u00a0<\/p>\n
if __name__ == "__main__":<\/p>\n
\u00a0 \u00a0 main()<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u597d\u5904：\u53ef\u8bfb\u6027\u9ad8，\u4ee5\u540e\u6539\u9700\u6c42\u53ea\u6539\u5bf9\u5e94\u51fd\u6570；\u4e5f\u65b9\u4fbf\u5355\u72ec\u6d4b\u8bd5\u6bcf\u4e2a\u6b65\u9aa4\u3002<\/p>\n
\u00a0<\/p>\n
📌\u89c4\u83036：\u9632\u5fa1\u6027\u7f16\u7a0b（\u81ea\u52a8\u5316\u811a\u672c\u4fdd\u547d\u8981\u70b9）<\/p>\n
\u00a0<\/p>\n
1.\u00a0\u6e90\u6587\u4ef6\u53ea\u8bfb\u53d6，\u7edd\u4e0d\u5220\u9664\/\u8986\u76d6；\u7ed3\u679c\u8f93\u51fa\u5355\u72ec\u653e \u00a0output\u00a0<\/p>\n
2.\u00a0\u751f\u6210\u6587\u4ef6\u6700\u597d\u5e26\u65e5\u671f\u540e\u7f00：\u00a0report_20260908.csv\u00a0，\u907f\u514d\u8986\u76d6\u6628\u5929\u7ed3\u679c<\/p>\n
3.\u00a0\u7f51\u7edc\u8bf7\u6c42\u4e00\u5b9a\u8981\u52a0 \u00a0timeout\u00a0，\u9632\u6b62\u5361\u6b7b：<\/p>\n
python<\/p>\n
res = requests.get(url, timeout=10) # 10\u79d2\u8d85\u65f6<\/p>\n
\u00a0<\/p>\n
4.\u00a0\u5faa\u73af\u8bf7\u6c42\u52a0\u5408\u7406\u95f4\u9694：\u00a0time.sleep(1~3)\u00a0，\u4e0d\u8981\u75af\u72c2\u8bf7\u6c42\u670d\u52a1<\/p>\n
5.\u00a0\u91cd\u8981\u64cd\u4f5c\u524d\u505a\u6821\u9a8c：\u5217\u662f\u5426\u5b58\u5728\u3001\u6570\u636e\u4e0d\u4e3a\u7a7a，\u907f\u514d\u5168\u662fNaN\u7684\u5783\u573e\u8f93\u51fa<\/p>\n
\u00a0<\/p>\n
📌\u89c4\u83037：\u5199\u6587\u6863\u6ce8\u91ca（\u811a\u672c\u5934\u90e8docstring + \u51fd\u6570docstring）<\/p>\n
\u00a0<\/p>\n
\u811a\u672c\u6700\u9876\u90e8\u8bf4\u660e：\u7528\u9014\u3001\u8f93\u5165\u3001\u8f93\u51fa\u3001\u4f5c\u8005\u3001\u6ce8\u610f\u4e8b\u9879\u3002<\/p>\n
\u00a0<\/p>\n
python<\/p>\n
"""<\/p>\n
\u811a\u672c\u540d\u79f0：sales_auto.py<\/p>\n
\u529f\u80fd：\u81ea\u52a8\u6c47\u603binput\u4e0b\u9500\u552eExcel，\u751f\u6210\u65e5\u62a5\u5e76\u9489\u9489\u901a\u77e5<\/p>\n
\u8f93\u5165：input\/*.xlsx，\u5fc5\u987b\u5305\u542b\u5217：\u65e5\u671f,\u95e8\u5e97,\u9500\u552e\u989d<\/p>\n
\u8f93\u51fa：output\/report_YYYYMMDD.csv<\/p>\n
\u6ce8\u610f：\u4e0d\u8981\u76f4\u63a5\u4fee\u6539\u6e90\u6587\u4ef6；\u914d\u7f6e\u5728.env\u4e2d<\/p>\n
"""<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u4e09\u30013\u4e2a\u5165\u95e8\u5b9e\u6218\u5c0f\u811a\u672c（\u53ef\u76f4\u63a5\u6539\u6539\u4f7f\u7528）<\/p>\n
\u00a0<\/p>\n
\u26a0\ufe0f\u4ec5\u4f5c\u4e3a\u5b66\u4e60\u793a\u4f8b，\u4f7f\u7528\u524d\u786e\u8ba4\u4e1a\u52a1\u6743\u9650\u3002<\/p>\n
\u00a0<\/p>\n
\u6848\u4f8b1：\u6587\u4ef6\u6574\u7406 – \u6309\u540e\u7f00\u5206\u7c7b\u4e0b\u8f7d\u6587\u4ef6\u5939（pathlib）<\/p>\n
\u00a0<\/p>\n
python<\/p>\n
"""<\/p>\n
\u529f\u80fd：\u628aDownloads\u91cc\u7684\u6587\u4ef6，\u6309\u540e\u7f00\u5206\u522b\u79fb\u52a8\u5230 image,doc,other<\/p>\n
\u26a0\ufe0f\u5148\u5907\u4efd！\u4e0d\u8981\u76f4\u63a5\u8dd1！\u6d4b\u8bd5\u9636\u6bb5\u5efa\u8bae\u5148\u6ce8\u91cashutil.move，\u53ea\u6253\u5370\u770b\u770b！<\/p>\n
"""<\/p>\n
from pathlib import Path<\/p>\n
import shutil<\/p>\n
import logging<\/p>\n
\u00a0<\/p>\n
logging.basicConfig(level=logging.INFO, format="%(asctime)s – %(message)s")<\/p>\n
logger = logging.getLogger(__name__)<\/p>\n
\u00a0<\/p>\n
def organize_download(download_path: Path):<\/p>\n
\u00a0 \u00a0 rules = {<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 "image": [".jpg",".png",".gif",".jpeg"],<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 "doc": [".pdf",".xlsx",".docx",".csv"]<\/p>\n
\u00a0 \u00a0 }<\/p>\n
\u00a0 \u00a0 for f in download_path.iterdir():<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 if f.is_file():<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 suffix = f.suffix.lower()<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 target_dir = download_path \/ "other"<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 for folder, exts in rules.items():<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 if suffix in exts:<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 target_dir = download_path \/ folder<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 break<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 target_dir.mkdir(exist_ok=True)<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 # logger.info(f"\u79fb\u52a8：{f.name} \u2192 {target_dir}")<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 # shutil.move(str(f), str(target_dir \/ f.name))<\/p>\n
\u00a0<\/p>\n
if __name__ == "__main__":<\/p>\n
\u00a0 \u00a0 organize_download(Path.home() \/ "Downloads")<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u6848\u4f8b2：\u9489\u9489Webhook\u6d88\u606f\u901a\u77e5<\/p>\n
\u00a0<\/p>\n
python<\/p>\n
import requests<\/p>\n
import os<\/p>\n
from dotenv import load_dotenv<\/p>\n
\u00a0<\/p>\n
load_dotenv()<\/p>\n
WEBHOOK = os.getenv("DINGDING_WEBHOOK")<\/p>\n
\u00a0<\/p>\n
def send_ding(text:str):<\/p>\n
\u00a0 \u00a0 if not WEBHOOK:<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 raise ValueError("\u672a\u914d\u7f6eDINGDING_WEBHOOK")<\/p>\n
\u00a0 \u00a0 data = {"msgtype":"text","text":{"content":text}}<\/p>\n
\u00a0 \u00a0 resp = requests.post(WEBHOOK, json=data, timeout=10)<\/p>\n
\u00a0 \u00a0 return resp.json()<\/p>\n
\u00a0<\/p>\n
if __name__ == "__main__":<\/p>\n
\u00a0 \u00a0 send_ding("🤖\u81ea\u52a8\u5316\u811a\u672c：\u4eca\u65e5\u6570\u636e\u6c47\u603b\u5b8c\u6210！")<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u4f7f\u7528\u524d：\u9489\u9489\u7fa4 \u2192 \u7fa4\u673a\u5668\u4eba \u2192 \u81ea\u5b9a\u4e49\u673a\u5668\u4eba，\u62ff\u5230webhook，\u653e\u5230.env\u3002\u4e0d\u8981\u6cc4\u9732webhook！\u522b\u4eba\u53ef\u4ee5\u4e71\u53d1\u6d88\u606f\u5230\u4f60\u7684\u7fa4\u3002<\/p>\n
\u00a0<\/p>\n
\u6848\u4f8b3：Excel\u7b80\u5355\u6c47\u603b（pandas）<\/p>\n
\u00a0<\/p>\n
python<\/p>\n
import pandas as pd<\/p>\n
from pathlib import Path<\/p>\n
import logging<\/p>\n
\u00a0<\/p>\n
logging.basicConfig(level=logging.INFO, format="%(asctime)s – %(message)s")<\/p>\n
logger = logging.getLogger(__name__)<\/p>\n
\u00a0<\/p>\n
INPUT = Path(".\/input")<\/p>\n
OUTPUT = Path(".\/output")<\/p>\n
OUTPUT.mkdir(exist_ok=True)<\/p>\n
\u00a0<\/p>\n
def main():<\/p>\n
\u00a0 \u00a0 dfs = []<\/p>\n
\u00a0 \u00a0 for f in INPUT.glob("*.xlsx"):<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 logger.info(f"\u8bfb\u53d6 {f.name}")<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 df = pd.read_excel(f, usecols=["\u65e5\u671f","\u95e8\u5e97","\u9500\u552e\u989d"])<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 dfs.append(df)<\/p>\n
\u00a0 \u00a0 all_df = pd.concat(dfs)<\/p>\n
\u00a0 \u00a0 summary = all_df.groupby(["\u65e5\u671f","\u95e8\u5e97"])["\u9500\u552e\u989d"].sum().reset_index()<\/p>\n
\u00a0 \u00a0 out_file = OUTPUT \/ f"report_{pd.Timestamp.now().strftime('%Y%m%d')}.csv"<\/p>\n
\u00a0 \u00a0 summary.to_csv(out_file, index=False, encoding="utf_8_sig")<\/p>\n
\u00a0 \u00a0 logger.info(f"\u5df2\u8f93\u51fa {out_file}")<\/p>\n
\u00a0<\/p>\n
if __name__ == "__main__":<\/p>\n
\u00a0 \u00a0 main()<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u56db\u3001\u5b9a\u65f6\u8fd0\u884c（\u4e0d\u63a8\u8350\u811a\u672c\u6b7b\u5faa\u73afsleep！）<\/p>\n
\u00a0<\/p>\n
\u2705Windows：\u4efb\u52a1\u8ba1\u5212\u7a0b\u5e8f<\/p>\n
\u2705Linux：crontab<\/p>\n
\u2705Mac：launchd<\/p>\n
\u00a0<\/p>\n
\u4e0d\u8981\u7528 \u00a0while True: do_job(); time.sleep(86400)\u00a0：\u811a\u672c\u6302\u4e86\u5c31\u4e0d\u4f1a\u518d\u8dd1，\u6ca1\u6709\u5b88\u62a4\u3001\u6ca1\u6709\u65e5\u5fd7\u8f6e\u8f6c\u3001\u5f02\u5e38\u65e0\u6cd5\u544a\u8b66\u3002<\/p>\n
\u00a0schedule\u00a0\u5e93\u9002\u5408\u8c03\u8bd5，\u751f\u4ea7\u4f18\u5148\u7cfb\u7edf\u7ea7\u5b9a\u65f6\u3002<\/p>\n
\u00a0<\/p>\n
Windows\u4efb\u52a1\u8ba1\u5212\u8981\u70b9：<\/p>\n
\u00a0<\/p>\n
– \u7a0b\u5e8f：\u00a0python.exe\u00a0 \u7684\u5b8c\u6574\u8def\u5f84（\u865a\u62df\u73af\u5883\u91cc\u7684python）<\/p>\n
– \u53c2\u6570：\u00a0main.py\u00a0\u5b8c\u6574\u8def\u5f84<\/p>\n
– \u8d77\u59cb\u4e8e：\u811a\u672c\u6240\u5728\u6587\u4ef6\u5939<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u4e94\u3001\u811a\u672c\u907f\u5751\u6e05\u5355（\u9ad8\u9891\u8e29\u5751）<\/p>\n
\u00a0<\/p>\n
1.\u00a0\u274c\u5bc6\u94a5\u3001webhook\u3001\u8d26\u53f7\u786c\u7f16\u7801\u5728\u4ee3\u7801，\u4e0a\u4f20\u5fae\u4fe1\/Git\u5bfc\u81f4\u6cc4\u9732 \u2192 \u2705\u7528 \u00a0.env\u00a0 + .gitignore<\/p>\n
2.\u00a0\u274c\u6ca1\u6709\u65e5\u5fd7，\u51fa\u95ee\u9898\u4e0d\u77e5\u9053\u54ea\u9519\u4e86 \u2192 \u2705\u6807\u51c6logging，\u8f93\u51fa\u6587\u4ef6+\u63a7\u5236\u53f0<\/p>\n
3.\u00a0\u274c\u8d85\u5927try\u2011except + pass，\u541e\u5f02\u5e38 \u2192 \u2705\u7ec6\u7c92\u5ea6\u6355\u83b7，\u6253\u5370\u5806\u6808<\/p>\n
4.\u00a0\u274c\u76f4\u63a5\u64cd\u4f5c\u539f\u6587\u4ef6，\u8bef\u5220\u8bef\u6539 \u2192 \u2705\u53ea\u8bfb\u6e90\u6587\u4ef6，\u8f93\u51fa\u72ec\u7acboutput<\/p>\n
5.\u00a0\u274c\u7f51\u7edc\u8bf7\u6c42\u4e0d\u52a0timeout，\u811a\u672c\u5361\u6b7b \u2192 \u2705\u7edf\u4e00\u8bbe\u7f6etimeout<\/p>\n
6.\u00a0\u274c\u4e0d\u505a\u5ef6\u65f6，\u9ad8\u9891\u8bf7\u6c42\u5185\u90e8\u7cfb\u7edf，\u7ed9\u670d\u52a1\u5668\u9020\u6210\u538b\u529b \u2192 \u2705\u5408\u7406sleep，\u9075\u5faa\u7cfb\u7edf\u4f7f\u7528\u89c4\u8303<\/p>\n
7.\u00a0\u274c\u8def\u5f84\u5199\u6b7b\u7edd\u5bf9\u8def\u5f84 \u00a0C:\\\\xxx\u00a0，\u6362\u7535\u8111\u5c31\u5d29 \u2192 \u2705\u7528\u76f8\u5bf9\u8def\u5f84 + pathlib，\u914d\u7f6e\u5316<\/p>\n
8.\u00a0\u274c\u7f16\u7801\u95ee\u9898：csv\u4e2d\u6587\u4e71\u7801 \u2192 \u2705\u8f93\u51fa\u7528 \u00a0encoding="utf_8_sig"\u00a0<\/p>\n
9.\u00a0\u274c\u4f9d\u8d56\u6ca1\u8bb0\u5f55，\u6362\u73af\u5883\u8dd1\u4e0d\u8d77\u6765 \u2192 \u2705\u7ef4\u62a4\u00a0requirements.txt\u00a0<\/p>\n
10.\u00a0\u274c\u8d8a\u6743\u64cd\u4f5c：\u722c\u53d6\u672a\u6388\u6743\u7f51\u7ad9\u3001\u81ea\u52a8\u64cd\u4f5c\u7cfb\u7edf\u975e\u81ea\u5df1\u7684\u8d26\u53f7 \u2192 \u2705\u53ea\u505a\u4f60\u6709\u6743\u9650\u505a\u7684\u4e8b<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u516d\u3001\u8fdb\u9636\u5b66\u4e60\u8def\u7ebf（\u7531\u6d45\u5165\u6df1）<\/p>\n
\u00a0<\/p>\n
1.\u00a0pathlib，pandas：\u6587\u4ef6\u4e0e\u8868\u683c\u81ea\u52a8\u5316（\u6700\u9ad8\u9891\u573a\u666f）<\/p>\n
2.\u00a0requests + webhook：\u63a5\u53e3\u8c03\u7528\u3001\u6d88\u606f\u901a\u77e5<\/p>\n
3.\u00a0playwright：\u6709\u6743\u9650\u7cfb\u7edf\u7684\u6d4f\u89c8\u5668\u81ea\u52a8\u5316（\u4e1a\u52a1\u540e\u53f0\u586b\u62a5\u3001\u5bfc\u51fa\u7b49）<\/p>\n
4.\u00a0yaml\/toml\u914d\u7f6e\u3001\u547d\u4ee4\u884c\u53c2\u6570（\u00a0argparse\u00a0 \/ \u00a0click\u00a0）：\u8ba9\u811a\u672c\u53ef\u4f20\u53c2\u8fd0\u884c<\/p>\n
5.\u00a0\u7b80\u5355\u6253\u5305：\u00a0pyinstaller\u00a0（\u628a\u811a\u672c\u6253\u5305exe，\u7ed9\u4e0d\u4f1apython\u7684\u540c\u4e8b\u7528，\u4ec5\u5185\u90e8\u4f7f\u7528）<\/p>\n
\u00a0<\/p>\n
pyinstaller\u793a\u4f8b（\u865a\u62df\u73af\u5883\u5185）：<\/p>\n
\u00a0<\/p>\n
bash<\/p>\n
pyinstaller -F -w main.py<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u26a0\ufe0f\u6ce8\u610f：exe\u5206\u53d1\u4ec5\u9650\u5185\u90e8\u5408\u6cd5\u81ea\u7528，\u4e0d\u53ef\u5bf9\u5916\u5206\u53d1\u505a\u5de5\u5177\u3002<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u00a0<\/p>\n
\u4e03\u3001\u811a\u672c\u6a21\u677f（\u7a7a\u767d\u811a\u624b\u67b6，\u76f4\u63a5\u65b0\u5efa\u9879\u76ee\u590d\u5236\u4f7f\u7528）<\/p>\n
\u00a0<\/p>\n
python<\/p>\n
"""<\/p>\n
\u3010\u811a\u672c\u6a21\u677f\u3011<\/p>\n
\u540d\u79f0：xxx.py<\/p>\n
\u7528\u9014：<\/p>\n
\u8f93\u5165：<\/p>\n
\u8f93\u51fa：<\/p>\n
\u6ce8\u610f：<\/p>\n
"""<\/p>\n
import logging<\/p>\n
import os<\/p>\n
from pathlib import Path<\/p>\n
from dotenv import load_dotenv<\/p>\n
\u00a0<\/p>\n
# ———- \u914d\u7f6e\u521d\u59cb\u5316 ———-<\/p>\n
BASE_DIR = Path(__file__).parent<\/p>\n
load_dotenv(BASE_DIR \/ ".env")<\/p>\n
\u00a0<\/p>\n
INPUT_DIR = BASE_DIR \/ "input"<\/p>\n
OUTPUT_DIR = BASE_DIR \/ "output"<\/p>\n
LOG_DIR = BASE_DIR \/ "logs"<\/p>\n
\u00a0<\/p>\n
for d in [INPUT_DIR, OUTPUT_DIR, LOG_DIR]:<\/p>\n
\u00a0 \u00a0 d.mkdir(exist_ok=True)<\/p>\n
\u00a0<\/p>\n
# ———- \u65e5\u5fd7\u521d\u59cb\u5316 ———-<\/p>\n
logging.basicConfig(<\/p>\n
\u00a0 \u00a0 level=logging.INFO,<\/p>\n
\u00a0 \u00a0 format="%(asctime)s – %(levelname)s – %(message)s",<\/p>\n
\u00a0 \u00a0 handlers=[<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 logging.FileHandler(LOG_DIR \/ "run.log", encoding="utf-8"),<\/p>\n
\u00a0 \u00a0 \u00a0 \u00a0 logging.StreamHandler()<\/p>\n
\u00a0 \u00a0 ]<\/p>\n
)<\/p>\n
logger = logging.getLogger(__name__)<\/p>\n","protected":false},"excerpt":{"rendered":"
\u4e00\u3001\u524d\u7f6e\u51c6\u5907 1. \u73af\u5883 – Python 3.8（\u63a8\u8350 3.10\/3.11，\u907f\u514d\u592a\u65b0\u7684\u7248\u672c\u5e93\u517c\u5bb9\u95ee\u9898）
\n– IDE：VSCode（\u63a8\u8350） \/ PyCharm \u793e\u533a\u7248
\n– \u5fc5\u5907\u5de5\u5177：\u00a0pip\u00a0，\u5efa\u8bae\u4f7f\u7528\u865a\u62df\u73af\u5883，\u9632\u6b62\u5305\u7248\u672c\u6df7\u4e71 bash
\n# \u521b\u5efa\u865a\u62df\u73af\u5883（\u9879\u76ee\u76ee\u5f55\u6267\u884c）
\npython -m venv venv # W<\/p>\n","protected":false},"author":2,"featured_media":104119,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[81],"topic":[],"class_list":["post-104120","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-python"],"yoast_head":"\n