tanji-list-enrichment

Enriches Excel company lists with web-researched business descriptions and generates xlsx files via zipfile.

Updated Jul 3, 2026
One-click install
npx skills add https://github.com/CHENHUI-X/toolbox --skill tanji-list-enrichment-chenhui-x
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: tanji-list-enrichment
Source: https://github.com/CHENHUI-X/toolbox/tree/main/custom-skills/productivity/tanji-list-enrichment
Command: npx skills add https://github.com/CHENHUI-X/toolbox --skill tanji-list-enrichment-chenhui-x

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve? When you receive a Tanji (探迹) prospect list in Excel or CSV format containing company names, legal representatives, and phone numbers, manually researching each company's business scope and filling in the 经营内容 (business content) column is slow and repetitive. This Skill automates per-company web research and writes structured findings back into the spreadsheet. ## Core Features & Use Cases - Per-company web research: Searches each company for its business scope, industry position, key contacts, and a tailored sales pitch angle for the 易盘点 fixed-asset management product. - Single-column enrichment: Preserves all original columns and packs company overview, main business, industry standing, contacts, and outreach talking points into the 经营内容 column with line-break-separated sections. - Dependency-free xlsx generation: Builds valid xlsx files using Python's built-in zipfile module, avoiding openpyxl which is unavailable in the sandbox, and delivers results via Telegram, WeChat, or temporary file-hosting links. - Use Case: Your mom sends a 30-company prospect list over WeChat; the Skill researches each company, fills the 经营内容 column, and returns a downloadable xlsx link. ## Quick Start Fill in the 经营内容 column for every company in the attached Tanji Excel list using web research, then send me back the completed xlsx file.

Frequently Asked Questions about tanji-list-enrichment

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I fill in business content for companies in an Excel list?

Read the xlsx or csv file, identify the company name column, then run a web search per company for its business scope and industry position. Write the summarized findings into the 经营内容 column and regenerate the xlsx file.

How to create xlsx files in Python without openpyxl?

Use the built-in zipfile module to write the raw OOXML parts: sharedStrings.xml, workbook.xml, worksheet XML, relationships, and content types. The included make_xlsx.py script implements this and accepts headers and rows as JSON input.

Why is openpyxl not working in my sandbox environment?

openpyxl is unavailable in the Hermes sandbox, so xlsx files must be constructed manually with zipfile. The provided script template generates a valid single-sheet workbook without any third-party packages.

How do I send an Excel file through WeChat when file transfer fails?

If direct file sending fails due to iLink limitations, upload the file to a temporary host such as file.io, 0x0.st, or transfer.sh using curl, then send the download link. Avoid retry loops when rate-limited.

What happens when no public information exists for a company?

The 经营内容 cell is filled with a warning marker indicating no public business information was found, rather than fabricating content. All other rows continue to be researched and filled normally.