mirror of
https://github.com/NanmiCoder/MediaCrawler.git
synced 2026-02-06 23:21:33 +08:00
Features: - Excel export with formatted multi-sheet workbooks (Contents, Comments, Creators) - Professional styling: blue headers, auto-width columns, borders, text wrapping - Smart export: empty sheets automatically removed - Support for all platforms (xhs, dy, ks, bili, wb, tieba, zhihu) Testing: - Added pytest framework with asyncio support - Unit tests for Excel store functionality - Unit tests for store factory pattern - Shared fixtures for test data - Test coverage for edge cases Documentation: - Comprehensive Excel export guide (docs/excel_export_guide.md) - Updated README.md and README_en.md with Excel examples - Updated config comments to include excel option Dependencies: - Added openpyxl>=3.1.2 for Excel support - Added pytest>=7.4.0 and pytest-asyncio>=0.21.0 for testing This contribution adds immediate value for users who need data analysis capabilities and establishes a testing foundation for future development.
31 lines
501 B
Plaintext
31 lines
501 B
Plaintext
httpx==0.28.1
|
|
Pillow==9.5.0
|
|
playwright==1.45.0
|
|
tenacity==8.2.2
|
|
typer>=0.12.3
|
|
opencv-python
|
|
aiomysql==0.2.0
|
|
redis~=4.6.0
|
|
pydantic==2.5.2
|
|
aiofiles~=23.2.1
|
|
fastapi==0.110.2
|
|
uvicorn==0.29.0
|
|
python-dotenv==1.0.1
|
|
jieba==0.42.1
|
|
wordcloud==1.9.3
|
|
matplotlib==3.9.0
|
|
requests==2.32.3
|
|
parsel==1.9.1
|
|
pyexecjs==1.5.1
|
|
pandas==2.2.3
|
|
aiosqlite==0.21.0
|
|
pyhumps==3.8.0
|
|
cryptography>=45.0.7
|
|
alembic>=1.16.5
|
|
asyncmy>=0.2.10
|
|
sqlalchemy>=2.0.43
|
|
motor>=3.3.0
|
|
xhshow>=0.1.3
|
|
openpyxl>=3.1.2
|
|
pytest>=7.4.0
|
|
pytest-asyncio>=0.21.0 |