mark-rejected
npx machina-cli add skill Mahashwetha/Job-search-email-system-claude/mark-rejected --openclawMark Company as Rejected
Update List.xlsx for a company that rejected you: set column D to Rejected and apply strikethrough formatting across columns A–F.
Steps
Run the bundled script at .claude/skills/mark-rejected/scripts/mark_rejected.py with the company name as the argument, from the project root.
The script finds all rows where column A contains the company name (case-insensitive substring match), sets column D to Rejected, applies strikethrough to columns A–F while preserving existing font properties, and saves the file. It handles PermissionError automatically via a temp copy if the file is open in Excel.
After running
Check the output — it reports the row number and company name for each row updated. If multiple unexpected rows matched, the company name was too broad. Revert any wrong rows manually in Excel (remove strikethrough, restore the original status).
The daily email will automatically show ❌ Rejected for that company on the next run.
If the script fails
Open List.xlsx manually, find the company row, type Rejected in column D, select cells A–F, open Format Cells (Ctrl+1), go to the Font tab, and check Strikethrough.
Source
git clone https://github.com/Mahashwetha/Job-search-email-system-claude/blob/main/.claude/skills/mark-rejected/SKILL.mdView on GitHub Overview
Mark-rejected updates your Excel job tracker by marking a company as Rejected. It locates rows where column A contains the company name (case-insensitive) and sets column D to Rejected, while applying a strikethrough across columns A–F.
How This Skill Works
You run the bundled Python script with the company name as the argument from the project root. The script searches List.xlsx for matches in column A (case-insensitive substring), updates column D to Rejected, applies strikethrough formatting to A–F, and saves. If the file is open in Excel, it uses a temporary copy to avoid PermissionError. The daily email will show ❌ Rejected for that company on the next run.
When to Use It
- You want to mark a company as Rejected in List.xlsx after an interview or rejection email
- A company rejected you and you need to reflect it in the tracker
- You find multiple matches for a company name and must verify which rows updated
- You want a visual strikethrough across A–F to clearly indicate rejection
- You are updating your job-search progress so the next daily report shows the Rejected status
Quick Start
- Step 1: Run the script at .claude/skills/mark-rejected/scripts/mark_rejected.py with the company name as the only argument
- Step 2: Script finds matching rows in List.xlsx, sets D to Rejected, and applies strikethrough to A–F
- Step 3: Check the output report for updated rows and manually correct any incorrect matches in Excel if needed
Best Practices
- Use exact or unique company names to minimize broad matches
- Review the output message for updated row numbers and company name
- If wrong rows update, revert in Excel by removing strikethrough and restoring D to Rejected as needed
- Close or save List.xlsx after changes to ensure the update sticks
- Rely on the temp-copy fallback when List.xlsx is open to avoid data loss
Example Use Cases
- Mark Acme Corp as Rejected in List.xlsx after receiving a rejection email
- Update BetaTech to Rejected in the tracker following an interview denial
- Apply strikethrough to Gamma LLC rows where the match was found
- If Delta matches multiple rows, verify and correct the updated rows manually
- Daily report shows ❌ Rejected for Acme Corp after running the script
