{"id":"72f1a518-2fd7-4ac6-a1bb-e73899973ccc","entityType":"agent","slug":"clawhub-ivangdavila-excel-xlsx-2","name":"Excel / XLSX","canonicalUrl":"https://www.xpersona.co/agent/clawhub-ivangdavila-excel-xlsx-2","canonicalPath":"/agent/clawhub-ivangdavila-excel-xlsx-2","generatedAt":"2026-10-09T20:01:28.044Z","source":"CLAWHUB","claimStatus":"UNCLAIMED","verificationTier":"NONE","summary":{"evidence":{"source":"editorial-content","verified":true,"confidence":"high","updatedAt":"2026-05-22T06:56:16.508Z","emptyReason":null},"description":"Create, inspect, and edit Microsoft Excel workbooks and XLSX files with reliable formulas, dates, types, formatting, recalculation, and template preservation... Skill: Excel / XLSX Owner: ivangdavila Summary: Create, inspect, and edit Microsoft Excel workbooks and XLSX files with reliable formulas, dates, types, formatting, recalculation, and template preservation... Tags: latest:1.0.2 Version history: v1.0.2 | 2026-03-11T15:32:46.499Z | user Tightened formula anchoring, recalculation, and model traceability after a stricter external spreadsheet audit. v1.0.1 | 2026-02-23T11","descriptionLabel":"Technical summary","evidenceSummary":"Capability contract not published. No trust telemetry is available yet. 68.8K downloads reported by the source. Last updated 5/22/2026.","installCommand":"clawhub skill install s178jdk12x4qj3gs2se3etxf3h83h7ft:excel-xlsx","sourceUrl":"https://clawhub.ai/ivangdavila/excel-xlsx","homepage":"https://clawhub.ai/ivangdavila/excel-xlsx","primaryLinks":[{"label":"View on ClawHub","url":"https://clawhub.ai/ivangdavila/excel-xlsx","kind":"source"}],"safetyScore":84,"overallRank":62,"popularityScore":96,"trustScore":null,"claimedByName":null,"isOwner":false,"seoDescription":"Create, inspect, and edit Microsoft Excel workbooks and XLSX files with reliable formulas, dates, types, formatting, recalculation, and template preservation..."},"coverage":{"evidence":{"source":"public-profile","verified":false,"confidence":"medium","updatedAt":"2026-05-22T06:56:16.508Z","emptyReason":null},"protocols":[{"protocol":"OPENCLEW","label":"OpenClaw","status":"self-declared","notes":"Declared in the public agent profile."}],"capabilities":[],"verifiedCount":0,"selfDeclaredCount":1,"capabilityMatrix":{"rows":[{"key":"OPENCLEW","type":"protocol","support":"unknown","confidenceSource":"profile","notes":"Listed on profile"}],"flattenedTokens":"protocol:OPENCLEW|unknown|profile"}},"adoption":{"evidence":{"source":"CLAWHUB","verified":false,"confidence":"medium","updatedAt":"2026-05-22T06:56:16.508Z","emptyReason":null},"stars":null,"forks":null,"downloads":68846,"packageName":null,"latestVersion":"1.0.2","tractionLabel":"68.8K downloads"},"release":{"evidence":{"source":"CLAWHUB","verified":false,"confidence":"medium","updatedAt":"2026-05-22T06:56:16.484Z","emptyReason":null},"lastUpdatedAt":"2026-05-22T06:56:16.508Z","lastCrawledAt":"2026-05-22T06:56:16.484Z","lastIndexedAt":null,"nextCrawlAt":"2026-05-23T06:56:16.484Z","lastVerifiedAt":null,"highlights":[{"version":"1.0.2","createdAt":"2026-03-11T15:32:46.499Z","changelog":"Tightened formula anchoring, recalculation, and model traceability after a stricter external spreadsheet audit.","fileCount":2,"zipByteSize":3497},{"version":"1.0.1","createdAt":"2026-02-23T11:48:02.734Z","changelog":"Added Core Rules and modern skill structure","fileCount":4,"zipByteSize":4933},{"version":"1.0.0","createdAt":"2026-02-10T01:20:33.325Z","changelog":"Initial release","fileCount":2,"zipByteSize":1780}]},"execution":{"evidence":{"source":"CLAWHUB","verified":false,"confidence":"low","updatedAt":null,"emptyReason":"No published capability contract is available yet."},"installCommand":"clawhub skill install s178jdk12x4qj3gs2se3etxf3h83h7ft:excel-xlsx","setupComplexity":"low","setupSteps":["Setup complexity is LOW. This package is likely designed for quick installation with minimal external side-effects.","Final validation: Expose the agent to a mock request payload inside a sandbox and trace the network egress before allowing access to real customer data."],"contract":{"contractStatus":"missing","authModes":[],"requires":[],"forbidden":[],"supportsMcp":false,"supportsA2a":false,"supportsStreaming":false,"inputSchemaRef":null,"outputSchemaRef":null,"dataRegion":null,"contractUpdatedAt":null,"sourceUpdatedAt":null,"freshnessSeconds":null},"invocationGuide":{"preferredApi":{"snapshotUrl":"https://www.xpersona.co/api/v1/agents/clawhub-ivangdavila-excel-xlsx-2/snapshot","contractUrl":"https://www.xpersona.co/api/v1/agents/clawhub-ivangdavila-excel-xlsx-2/contract","trustUrl":"https://www.xpersona.co/api/v1/agents/clawhub-ivangdavila-excel-xlsx-2/trust"},"curlExamples":["curl -s \"https://www.xpersona.co/api/v1/agents/clawhub-ivangdavila-excel-xlsx-2/snapshot\"","curl -s \"https://www.xpersona.co/api/v1/agents/clawhub-ivangdavila-excel-xlsx-2/contract\"","curl -s \"https://www.xpersona.co/api/v1/agents/clawhub-ivangdavila-excel-xlsx-2/trust\""],"jsonRequestTemplate":{"query":"summarize this repo","constraints":{"maxLatencyMs":2000,"protocolPreference":["OPENCLEW"]}},"jsonResponseTemplate":{"ok":true,"result":{"summary":"...","confidence":0.9},"meta":{"source":"CLAWHUB","generatedAt":"2026-10-09T20:01:28.044Z"}},"retryPolicy":{"maxAttempts":3,"backoffMs":[500,1500,3500],"retryableConditions":["HTTP_429","HTTP_503","NETWORK_TIMEOUT"]}},"endpoints":{"dossierUrl":"https://www.xpersona.co/api/v1/agents/clawhub-ivangdavila-excel-xlsx-2/dossier","snapshotUrl":"https://www.xpersona.co/api/v1/agents/clawhub-ivangdavila-excel-xlsx-2/snapshot","contractUrl":"https://www.xpersona.co/api/v1/agents/clawhub-ivangdavila-excel-xlsx-2/contract","trustUrl":"https://www.xpersona.co/api/v1/agents/clawhub-ivangdavila-excel-xlsx-2/trust"}},"reliability":{"evidence":{"source":"runtime-metrics","verified":false,"confidence":"low","updatedAt":null,"emptyReason":"No trust, reliability, or runtime telemetry is available."},"trust":{"status":"unavailable","handshakeStatus":"UNKNOWN","verificationFreshnessHours":null,"reputationScore":null,"p95LatencyMs":null,"successRate30d":null,"fallbackRate":null,"attempts30d":null,"trustUpdatedAt":null,"trustConfidence":"unknown","sourceUpdatedAt":null,"freshnessSeconds":null},"decisionGuardrails":{"doNotUseIf":["Contract metadata is missing or unavailable for deterministic execution."],"safeUseWhen":[],"riskFlags":["missing_or_unavailable_contract","trust_data_unavailable","schema_references_missing"],"operationalConfidence":"low"},"executionMetrics":{"observedLatencyMsP50":null,"observedLatencyMsP95":null,"estimatedCostUsd":null,"uptime30d":null,"rateLimitRpm":null,"rateLimitBurst":null,"lastVerifiedAt":null,"verificationSource":null},"runtimeMetrics":{"successRate":null,"avgLatencyMs":null,"avgCostUsd":null,"hallucinationRate":null,"retryRate":null,"disputeRate":null,"p50Latency":null,"p95Latency":null,"lastUpdated":null}},"benchmarks":{"evidence":{"source":"no-benchmark-data","verified":false,"confidence":"low","updatedAt":null,"emptyReason":"No benchmark suites or observed failure patterns are available."},"suites":[],"failurePatterns":[]},"artifacts":{"evidence":{"source":"CLAWHUB","verified":false,"confidence":"high","updatedAt":"2026-05-22T06:56:16.508Z","emptyReason":null},"readme":"Skill: Excel / XLSX\n\nOwner: ivangdavila\n\nSummary: Create, inspect, and edit Microsoft Excel workbooks and XLSX files with reliable formulas, dates, types, formatting, recalculation, and template preservation...\n\nTags: latest:1.0.2\n\nVersion history:\n\nv1.0.2 | 2026-03-11T15:32:46.499Z | user\n\nTightened formula anchoring, recalculation, and model traceability after a stricter external spreadsheet audit.\n\nv1.0.1 | 2026-02-23T11:48:02.734Z | user\n\nAdded Core Rules and modern skill structure\n\nv1.0.0 | 2026-02-10T01:20:33.325Z | user\n\nInitial release\n\nArchive index:\n\nArchive v1.0.2: 2 files, 3497 bytes\n\nFiles: SKILL.md (6960b), _meta.json (129b)\n\nFile v1.0.2:SKILL.md\n\n---\nname: Excel / XLSX\nslug: excel-xlsx\nversion: 1.0.2\nhomepage: https://clawic.com/skills/excel-xlsx\ndescription: \"Create, inspect, and edit Microsoft Excel workbooks and XLSX files with reliable formulas, dates, types, formatting, recalculation, and template preservation. Use when (1) the task is about Excel, `.xlsx`, `.xlsm`, `.xls`, `.csv`, or `.tsv`; (2) formulas, formatting, workbook structure, or compatibility matter; (3) the file must stay reliable after edits.\"\nchangelog: Tightened formula anchoring, recalculation, and model traceability after a stricter external spreadsheet audit.\nmetadata: {\"clawdbot\":{\"emoji\":\"📗\",\"requires\":{\"bins\":[]},\"os\":[\"linux\",\"darwin\",\"win32\"]}}\n---\n\n## When to Use\n\nUse when the main artifact is a Microsoft Excel workbook or spreadsheet file, especially when formulas, dates, formatting, merged cells, workbook structure, or cross-platform behavior matter.\n\n## Core Rules\n\n### 1. Choose the workflow by job, not by habit\n\n- Use `pandas` for analysis, reshaping, and CSV-like tasks.\n- Use `openpyxl` when formulas, styles, sheets, comments, merged cells, or workbook preservation matter.\n- Treat CSV as plain data exchange, not as an Excel feature-complete format.\n- Reading values, preserving a live workbook, and building a model from scratch are different spreadsheet jobs.\n\n### 2. Dates are serial numbers with legacy quirks\n\n- Excel stores dates as serial numbers, not real date objects.\n- The 1900 date system includes the false leap-day bug, and some workbooks use the 1904 system.\n- Time is fractional day data, so formatting and conversion both matter.\n- Date correctness is not enough if the number format still displays the wrong thing to the user.\n\n### 3. Keep calculations in Excel when the workbook should stay live\n\n- Write formulas into cells instead of hardcoding derived results from Python.\n- Use references to assumption cells instead of magic numbers inside formulas.\n- Cached formula values can be stale, so do not trust them blindly after edits.\n- Check copied formulas for wrong ranges, wrong sheets, and silent off-by-one drift before delivery.\n- Absolute and relative references are part of the logic, so copied formulas can be wrong even when they still \"work\".\n- Test new formulas on a few representative cells before filling them across a whole block.\n- Verify denominators, named ranges, and precedent cells before shipping formulas that depend on them.\n- A workbook should ship with zero formula errors, not with known `#REF!`, `#DIV/0!`, `#VALUE!`, `#NAME?`, or circular-reference fallout left for the user to fix.\n- For model-style work, document non-obvious hardcodes, assumptions, or source inputs in comments or nearby notes.\n\n### 4. Protect data types before Excel mangles them\n\n- Long identifiers, phone numbers, ZIP codes, and leading-zero values should usually be stored as text.\n- Excel silently truncates numeric precision past 15 digits.\n- Mixed text-number columns need explicit handling on read and on write.\n- Scientific notation, auto-parsed dates, and stripped leading zeros are common corruption, not cosmetic issues.\n\n### 5. Preserve workbook structure before changing content\n\n- Existing templates override generic styling advice.\n- Only the top-left cell of a merged range stores the value.\n- Hidden rows, hidden columns, named ranges, and external references can still affect formulas and outputs.\n- Shared strings, defined names, and sheet-level conventions can matter even when the visible cells look simple.\n- Match styles for newly filled cells instead of quietly introducing a new visual system.\n- If the workbook is a template, preserve sheet order, widths, freezes, filters, print settings, validations, and visual conventions unless the task explicitly changes them.\n- Conditional formatting, filters, print areas, and data validation often carry business meaning even when users only mention the numbers.\n- If there is no existing style guide and the file is a model, keep editable inputs visually distinguishable from formulas, but never override an established template to force a generic house style.\n\n### 6. Recalculate and review before delivery\n\n- Formula strings alone are not enough if the recipient needs current values.\n- `openpyxl` preserves formulas but does not calculate them.\n- Verify no `#REF!`, `#DIV/0!`, `#VALUE!`, `#NAME?`, or circular-reference fallout remains.\n- If layout matters, render or visually review the workbook before calling it finished.\n- Be careful with read modes: opening a workbook for values only and then saving can flatten formulas into static values.\n- If assumptions or hardcoded overrides must stay, make them obvious enough that the next editor can audit the workbook.\n\n### 7. Scale the workflow to the file size\n\n- Large workbooks can fail for boring reasons: memory spikes, padded empty rows, and slow full-sheet reads.\n- Use streaming or chunked reads when the file is big enough that loading everything at once becomes fragile.\n- Large-file workflows also need narrower reads, explicit dtypes, and sheet targeting to avoid accidental damage.\n\n## Common Traps\n\n- Type inference on read can leave numbers as text or convert IDs into damaged numeric values.\n- Column indexing varies across tools, so off-by-one mistakes are common in generated formulas.\n- Newlines in cells need wrapping to display correctly.\n- External references break easily when source files move.\n- Password protection in old Excel workflows is not serious security.\n- `.xlsm` can contain macros, and `.xls` remains a tighter legacy format.\n- Large files may need streaming reads or more careful memory handling.\n- Google Sheets and LibreOffice can reinterpret dates, formulas, or styling differently from Excel.\n- Dynamic array or newer Excel functions like `FILTER`, `XLOOKUP`, `SORT`, or `SEQUENCE` may fail or degrade in older viewers.\n- A workbook can look fine while still carrying stale cached values from a prior recalculation.\n- Saving the wrong workbook view can replace formulas with cached values and quietly destroy a live model.\n- Copying formulas without checking relative references can push one bad range across an entire block.\n- Hidden sheets, named ranges, validations, and merged areas often keep business logic that is invisible in a quick skim.\n- A workbook can appear numerically correct while still failing because filters, conditional formats, print settings, or data validation were stripped.\n- A workbook can be numerically correct and still fail visually because wrapped text, clipped labels, or narrow columns were never reviewed.\n\n## Related Skills\nInstall with `clawhub install <slug>` if user confirms:\n- `csv` — Plain-text tabular import and export workflows.\n- `data` — General data handling patterns before spreadsheet output.\n- `data-analysis` — Higher-level analysis that can feed workbook deliverables.\n\n## Feedback\n\n- If useful: `clawhub star excel-xlsx`\n- Stay updated: `clawhub sync`\n\nFile v1.0.2:_meta.json\n\n{\n  \"ownerId\": \"kn73vp5rarc3b14rc7wjcw8f8580t5d1\",\n  \"slug\": \"excel-xlsx\",\n  \"version\": \"1.0.2\",\n  \"publishedAt\": 1773243166499\n}\n\nArchive v1.0.1: 4 files, 4933 bytes\n\nFiles: memory-template.md (1881b), setup.md (2642b), SKILL.md (3828b), _meta.json (129b)\n\nFile v1.0.1:SKILL.md\n\n---\nname: Excel / XLSX\nslug: excel-xlsx\nversion: 1.0.1\nhomepage: https://clawic.com/skills/excel-xlsx\ndescription: Read, write, and generate Excel files with correct types, dates, formulas, and cross-platform compatibility.\nchangelog: Added Core Rules and modern skill structure\nmetadata: {\"clawdbot\":{\"emoji\":\"📗\",\"requires\":{\"bins\":[]},\"os\":[\"linux\",\"darwin\",\"win32\"]}}\n---\n\n## Setup\n\nOn first use, read `setup.md` for integration guidelines. Ask user preferences naturally during conversation.\n\n## When to Use\n\nUser needs to read, write, or generate Excel files (.xlsx, .xls, .xlsm). Agent handles type coercion, date serialization, formula evaluation, and cross-platform quirks.\n\n## Architecture\n\nMemory lives in `~/excel-xlsx/`. See `memory-template.md` for structure.\n\n```\n~/excel-xlsx/\n└── memory.md     # Preferences, tools, pain points\n```\n\n## Quick Reference\n\n| Topic | File |\n|-------|------|\n| Setup | `setup.md` |\n| Memory template | `memory-template.md` |\n\n## Core Rules\n\n### 1. Dates Are Serial Numbers\nExcel stores dates as days since 1900-01-01 (Windows) or 1904-01-01 (Mac legacy). Check workbook date system before converting. Time is fractional: 0.5 = noon, 0.25 = 6 AM.\n\n### 2. The 1900 Leap Year Bug\nExcel incorrectly treats 1900 as a leap year. Serial 60 represents Feb 29, 1900 (invalid date). Account for this when calculating dates before March 1, 1900.\n\n### 3. 15-Digit Precision Limit\nNumbers beyond 15 digits silently truncate. Use TEXT format for: phone numbers, IDs, credit cards, any long numeric identifiers. Leading zeros also require TEXT.\n\n### 4. Formulas vs Cached Values\nCells may contain both formula and cached result. Some readers return formula string, others return cached value. Force recalculation if cached values might be stale.\n\n### 5. Merged Cells Are Traps\nOnly the top-left cell of a merged range holds the value. Reading other cells in the merge returns empty. Hidden rows/columns still contain data.\n\n### 6. Cross-Platform Testing Required\nWindows vs Mac Excel can differ in date system. LibreOffice/Google Sheets may not support all features. Always test roundtrip compatibility when generating files for unknown consumers.\n\n### 7. Use Streaming for Large Files\nLoading large files fully into RAM causes memory issues. Use streaming readers (row-by-row) for files with 100K+ rows. Empty rows at end may be padded by some writers.\n\n## Common Traps\n\n- **Type inference on read** → Numbers stored as text stay text; explicit conversion needed\n- **Column index confusion** → A=0 or A=1 varies by library; always verify convention\n- **Newlines in cells** → `\\n` works but cell needs \"wrap text\" format to display\n- **External references** → `[Book.xlsx]Sheet!A1` breaks when source file moves\n- **Password protection** → Trivial to break; not real security; encrypt file externally if needed\n- **XLSM files** → Contain macros (security risk); XLSB is binary (faster but less compatible)\n- **Shared strings** → Large files reuse text indices; libraries handle this, but be aware\n\n## Format Limits\n\n| Format | Rows | Columns | Notes |\n|--------|------|---------|-------|\n| XLSX | 1,048,576 | 16,384 (XFD) | Modern default |\n| XLS | 65,536 | 256 | Legacy, avoid |\n| CSV | Unlimited | Unlimited | No formatting |\n\n## Security & Privacy\n\n**Data that stays local:**\n- All file processing happens locally\n- User preferences stored in `~/excel-xlsx/memory.md` with consent\n- No external services called\n\n**This skill does NOT:**\n- Send data to external endpoints\n- Require network access\n\n## Related Skills\nInstall with `clawhub install <slug>` if user confirms:\n- `csv` — CSV parsing and generation\n- `data` — Data processing patterns\n- `data-analysis` — Analysis workflows\n\n## Feedback\n\n- If useful: `clawhub star excel-xlsx`\n- Stay updated: `clawhub sync`\n\nFile v1.0.1:_meta.json\n\n{\n  \"ownerId\": \"kn73vp5rarc3b14rc7wjcw8f8580t5d1\",\n  \"slug\": \"excel-xlsx\",\n  \"version\": \"1.0.1\",\n  \"publishedAt\": 1771847282734\n}\n\nFile v1.0.1:memory-template.md\n\n# Memory Template — Excel / XLSX\n\nCreate `~/excel-xlsx/memory.md` with this structure:\n\n```markdown\n# Excel / XLSX Memory\n\n## Status\nstatus: ongoing\nlast: YYYY-MM-DD\nintegration: pending | done | declined\n\n## Environment\nplatform: windows | mac | linux | mixed\nlibraries: [openpyxl, pandas, xlsxwriter, SheetJS, etc.]\n\n## Preferences\ndate_system: 1900 | 1904 | auto\ndate_format: DD/MM/YYYY | MM/DD/YYYY | YYYY-MM-DD | none\nnumeric_ids: always_text | when_needed | none\nlarge_files: suggest_streaming | handle_normally\n\n## Pain Points\n<!-- Things they've mentioned struggling with -->\n- [e.g., \"dates always break when opening on Mac\"]\n- [e.g., \"phone numbers lose leading zeros\"]\n\n## Common Tasks\n<!-- What they typically do with Excel -->\n- [e.g., \"export reports for finance team\"]\n- [e.g., \"import CSVs from legacy system\"]\n\n## Notes\n<!-- Other observations -->\n\n---\n*Updated: YYYY-MM-DD*\n```\n\n## Status Values\n\n| Value | Meaning | Behavior |\n|-------|---------|----------|\n| `ongoing` | Still learning | Gather context as they work |\n| `complete` | Has enough context | Work normally |\n| `paused` | User said \"not now\" | Don't ask, work with what you have |\n\n## Preference Defaults\n\nIf no preference specified, use these sensible defaults:\n- **date_system:** auto (detect from workbook)\n- **date_format:** ISO (YYYY-MM-DD) when generating, preserve when reading\n- **numeric_ids:** when_needed (warn for >15 digits or leading zeros)\n- **large_files:** suggest_streaming (mention for 100K+ rows)\n\n## What to Track Over Time\n\nAs you help them:\n- Note which warnings actually helped vs annoyed them\n- Remember which libraries they use\n- Track recurring issues (same mistake = add to pain points)\n- Update preferences when they express them\n\n## Integration Note\n\nAfter user confirms their preferences:\n- Save when to activate this skill\n- Save key preferences for future sessions\n\nFile v1.0.1:setup.md\n\n# Setup — Excel / XLSX\n\nRead this on first use to understand user preferences. Ask questions naturally during conversation.\n\n## Your Attitude\n\nYou're helping someone who works with Excel files. They might be frustrated with date bugs, precision issues, or cross-platform headaches. Show that you understand these pains and will help them avoid them.\n\n**Use natural language:** Talk about Excel pitfalls and best practices, not about \"memory files\" or \"config\". The user cares about getting their spreadsheets right.\n\n## Priority Order\n\n### 1. First: Integration (most important)\n\nBefore anything else, figure out WHEN this skill should activate.\n\nHelp the user understand what this enables:\n- \"I can help whenever you're working with Excel files — reading, writing, or generating them. Should I jump in automatically when you mention spreadsheets, or only when you ask directly?\"\n\n**Wait for their answer.** Once they say yes, confirm: \"Got it, I'll help whenever you're working with Excel.\" Then save their preference.\n\n### 2. Then: Understand Their Situation\n\nAsk open questions to understand how they work with Excel:\n- What do they use Excel for? (reports, data import/export, analysis, templates?)\n- What tools/libraries do they use? (openpyxl, pandas, SheetJS, xlsxwriter, manual?)\n- What platforms? (Windows, Mac, Linux, or mixed?)\n- Any recurring pain points? (dates, encoding, large files?)\n\nStart broad, then narrow based on what matters to them.\n\n### 3. Finally: Preferences (only if they want)\n\nSome users have strong preferences about:\n- Date system (1900 vs 1904)\n- Date format (DD/MM/YYYY vs MM/DD/YYYY vs ISO)\n- How to handle numeric IDs (always text, or only when needed)\n- Large file handling (when to suggest streaming)\n\nAdapt to them. Don't push for details they don't care about.\n\n## Feedback After Each Response\n\nAfter the user shares something:\n1. Reflect back what you understood (\"So you're using pandas to export CSVs to Excel for clients on Windows...\")\n2. Connect it to how you'll help (\"I'll make sure dates convert correctly and IDs don't lose precision\")\n3. Then continue\n\n## What You're Saving (with consent)\n\nOnly save after the user shares it:\n- Integration preference (when to activate)\n- Tools/libraries they use\n- Primary platform (Windows/Mac/Linux)\n- Date preferences (if mentioned)\n- Known pain points to watch for\n\nAlways confirm what you understood: \"Got it, I'll warn you about the 1900 date bug when working with older files.\"\n\n## When Setup is \"Done\"\n\nOnce you know:\n1. When to activate\n2. What tools/platform they use\n\n...you're ready to help. Preferences build over time through normal use.\n\nArchive v1.0.0: 2 files, 1780 bytes\n\nFiles: SKILL.md (2577b), _meta.json (129b)\n\nFile v1.0.0:SKILL.md\n\n---\nname: XLSX\ndescription: Read and generate Excel files with correct types, dates, and cross-platform compatibility.\nmetadata: {\"clawdbot\":{\"emoji\":\"📗\",\"os\":[\"linux\",\"darwin\",\"win32\"]}}\n---\n\n## Dates\n\n- Excel dates are serial numbers—days since 1900-01-01 (Windows) or 1904-01-01 (Mac legacy)\n- 1900 leap year bug: Excel incorrectly treats 1900 as leap year—serial 60 is Feb 29, 1900 (invalid)\n- Date vs number ambiguous without cell format—always check number format code, not just value\n- Times are fractional days: 0.5 = 12:00 noon; 0.25 = 06:00\n\n## Numbers\n\n- 15-digit precision limit—larger numbers silently truncate; use text format for IDs, phone numbers\n- Leading zeros stripped from numbers—format as text or use custom format `00000`\n- Scientific notation triggers automatically—`1E10` becomes number; quote if literal text\n- Currency/percentage stored as numbers—formatting is display-only, raw value differs\n\n## Text & Encoding\n\n- Shared strings table stores unique text once—large files reuse indices; libraries handle this\n- 32,767 character limit per cell\n- Newlines in cells: `\\n` works but cell needs wrap text format to display\n- Unicode fully supported in XLSX—but legacy XLS has codepage issues\n\n## Structure\n\n- Row limit: 1,048,576; column limit: 16,384 (XFD)—XLS limit is 65,536 × 256\n- Merged cells: only top-left cell holds value—reading others returns empty\n- Hidden rows/columns still contain data—don't assume hidden means excluded\n- Sheet names max 31 chars; forbidden: `\\ / ? * [ ]`\n\n## Formulas\n\n- Cell may contain formula and cached result—some readers return formula, others cached value\n- Formulas recalculate on open—cached values may be stale; force recalc or read formula\n- Array formulas (CSE/dynamic) have different behavior across Excel versions\n- External references `[Book.xlsx]Sheet!A1` break when file moves\n\n## Cross-Platform\n\n- Windows vs Mac Excel: date system (1900 vs 1904) can differ—check workbook setting\n- LibreOffice/Google Sheets: some Excel features unsupported—test roundtrip\n- XLSM contains macros (security risk); XLSB is binary (faster, less compatible)\n- Password protection is trivial to break—not real security; encrypt file externally\n\n## Common Library Issues\n\n- Empty rows at end: some writers pad to fixed size—trim when reading\n- Type inference on read: numbers-as-text stay text; explicit conversion needed\n- Memory: loading large files fully into RAM—use streaming reader for big files\n- Column letters vs indices: A=0 or A=1 varies by library—verify convention\n\nFile v1.0.0:_meta.json\n\n{\n  \"ownerId\": \"kn73vp5rarc3b14rc7wjcw8f8580t5d1\",\n  \"slug\": \"excel-xlsx\",\n  \"version\": \"1.0.0\",\n  \"publishedAt\": 1770686433325\n}","readmeExcerpt":"Skill: Excel / XLSX Owner: ivangdavila Summary: Create, inspect, and edit Microsoft Excel workbooks and XLSX files with reliable formulas, dates, types, formatting, recalculation, and template preservation... Tags: latest:1.0.2 Version history: v1.0.2 | 2026-03-11T15:32:46.499Z | user Tightened formula anchoring, recalculation, and model traceability after a stricter external spreadsheet audit. v1.0.1 | 2026-02-23T11","codeSnippets":[],"executableExamples":[{"language":"text","snippet":"~/excel-xlsx/\n└── memory.md     # Preferences, tools, pain points"},{"language":"markdown","snippet":"# Excel / XLSX Memory\n\n## Status\nstatus: ongoing\nlast: YYYY-MM-DD\nintegration: pending | done | declined\n\n## Environment\nplatform: windows | mac | linux | mixed\nlibraries: [openpyxl, pandas, xlsxwriter, SheetJS, etc.]\n\n## Preferences\ndate_system: 1900 | 1904 | auto\ndate_format: DD/MM/YYYY | MM/DD/YYYY | YYYY-MM-DD | none\nnumeric_ids: always_text | when_needed | none\nlarge_files: suggest_streaming | handle_normally\n\n## Pain Points\n<!-- Things they've mentioned struggling with -->\n- [e.g., \"dates always break when opening on Mac\"]\n- [e.g., \"phone numbers lose leading zeros\"]\n\n## Common Tasks\n<!-- What they typically do with Excel -->\n- [e.g., \"export reports for finance team\"]\n- [e.g., \"import CSVs from legacy system\"]\n\n## Notes\n<!-- Other observations -->\n\n---\n*Updated: YYYY-MM-DD*"}],"parameters":null,"dependencies":[],"permissions":[],"extractedFiles":[{"path":"SKILL.md","content":"---\nname: Excel / XLSX\nslug: excel-xlsx\nversion: 1.0.2\nhomepage: https://clawic.com/skills/excel-xlsx\ndescription: \"Create, inspect, and edit Microsoft Excel workbooks and XLSX files with reliable formulas, dates, types, formatting, recalculation, and template preservation. Use when (1) the task is about Excel, `.xlsx`, `.xlsm`, `.xls`, `.csv`, or `.tsv`; (2) formulas, formatting, workbook structure, or compatibility matter; (3) the file must stay reliable after edits.\"\nchangelog: Tightened formula anchoring, recalculation, and model traceability after a stricter external spreadsheet audit.\nmetadata: {\"clawdbot\":{\"emoji\":\"📗\",\"requires\":{\"bins\":[]},\"os\":[\"linux\",\"darwin\",\"win32\"]}}\n---\n\n## When to Use\n\nUse when the main artifact is a Microsoft Excel workbook or spreadsheet file, especially when formulas, dates, formatting, merged cells, workbook structure, or cross-platform behavior matter.\n\n## Core Rules\n\n### 1. Choose the workflow by job, not by habit\n\n- Use `pandas` for analysis, reshaping, and CSV-like tasks.\n- Use `openpyxl` when formulas, styles, sheets, comments, merged cells, or workbook preservation matter.\n- Treat CSV as plain data exchange, not as an Excel feature-complete format.\n- Reading values, preserving a live workbook, and building a model from scratch are different spreadsheet jobs.\n\n### 2. Dates are serial numbers with legacy quirks\n\n- Excel stores dates as serial numbers, not real date objects.\n- The 1900 date system includes the false leap-day bug, and some workbooks use the 1904 system.\n- Time is fractional day data, so formatting and conversion both matter.\n- Date correctness is not enough if the number format still displays the wrong thing to the user.\n\n### 3. Keep calculations in Excel when the workbook should stay live\n\n- Write formulas into cells instead of hardcoding derived results from Python.\n- Use references to assumption cells instead of magic numbers inside formulas.\n- Cached formula values can be stale, so do not trust them blindly after edits.\n- Check copied formulas for wrong ranges, wrong sheets, and silent off-by-one drift before delivery.\n- Absolute and relative references are part of the logic, so copied formulas can be wrong even when they still \"work\".\n- Test new formulas on a few representative cells before filling them across a whole block.\n- Verify denominators, named ranges, and precedent cells before shipping formulas that depend on them.\n- A workbook should ship with zero formula errors, not with known `#REF!`, `#DIV/0!`, `#VALUE!`, `#NAME?`, or circular-reference fallout left for the user to fix.\n- For model-style work, document non-obvious hardcodes, assumptions, or source inputs in comments or nearby notes.\n\n### 4. Protect data types before Excel mangles them\n\n- Long identifiers, phone numbers, ZIP codes, and leading-zero values should usually be stored as text.\n- Excel silently truncates numeric precision past 15 digits.\n- Mixed text-number columns need explicit handling on read and on write.\n"},{"path":"_meta.json","content":"{\n  \"ownerId\": \"kn73vp5rarc3b14rc7wjcw8f8580t5d1\",\n  \"slug\": \"excel-xlsx\",\n  \"version\": \"1.0.2\",\n  \"publishedAt\": 1773243166499\n}"}],"languages":[],"docsSourceLabel":"CLAWHUB","editorialOverview":"Create, inspect, and edit Microsoft Excel workbooks and XLSX files with reliable formulas, dates, types, formatting, recalculation, and template preservation... Skill: Excel / XLSX Owner: ivangdavila Summary: Create, inspect, and edit Microsoft Excel workbooks and XLSX files with reliable formulas, dates, types, formatting, recalculation, and template preservation... Tags: latest:1.0.2 Version history: v1.0.2 | 2026-03-11T15:32:46.499Z | user Tightened formula anchoring, recalculation, and model traceability after a stricter external spreadsheet audit. v1.0.1 | 2026-02-23T11","editorialQuality":{"score":100,"threshold":65,"status":"ready","wordCount":834,"uniquenessScore":58,"reasons":[]}},"media":{"evidence":{"source":"no-media","verified":false,"confidence":"low","updatedAt":"2026-05-22T06:56:16.508Z","emptyReason":"No screenshots, media assets, or demo links are available."},"primaryImageUrl":null,"mediaAssetCount":0,"assets":[],"demoUrl":null},"ownerResources":{"evidence":{"source":"unclaimed","verified":false,"confidence":"low","updatedAt":"2026-05-22T06:56:16.508Z","emptyReason":"This page has not been claimed by the agent owner."},"hasCustomPage":false,"customPageUpdatedAt":null,"customLinks":[],"structuredLinks":{"docsUrl":null,"demoUrl":null,"supportUrl":null,"pricingUrl":null,"statusUrl":null},"customPage":null},"relatedAgents":{"evidence":{"source":"protocol-neighbors","verified":false,"confidence":"medium","updatedAt":"2026-10-09T20:01:28.044Z","emptyReason":null},"items":[{"id":"8ebccd8e-3863-4187-8355-c3f14e1f9edf","entityType":"agent","canonicalPath":"/agent/iofficeai-aionui","slug":"iofficeai-aionui","name":"AionUi","description":"Free, local, open-source 24/7 Cowork app and OpenClaw for Gemini CLI, Claude Code, Codex, OpenCode, Qwen Code, Goose CLI, Auggie, and more | 🌟 Star if you like it!","url":"https://github.com/iOfficeAI/AionUi","homepage":"https://www.aionui.com","source":"GITHUB_REPOS","protocols":["MCP","OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-10-09T19:11:12.944Z","createdAt":"2026-02-25T03:38:16.584Z","downloads":null},{"id":"b917f68a-ebff-438e-84f8-3f4b2494c0bc","entityType":"agent","canonicalPath":"/agent/activepieces-activepieces","slug":"activepieces-activepieces","name":"activepieces","description":"AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents","url":"https://github.com/activepieces/activepieces","homepage":"https://www.activepieces.com","source":"GITHUB_REPOS","protocols":["OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-04-15T02:22:12.426Z","createdAt":"2026-02-25T03:38:12.412Z","downloads":null},{"id":"5cb26759-3a39-483f-94cf-276a98c13bb8","entityType":"agent","canonicalPath":"/agent/cherryhq-cherry-studio","slug":"cherryhq-cherry-studio","name":"cherry-studio","description":"AI productivity studio with smart chat, autonomous agents, and 300+ assistants. Unified access to frontier LLMs","url":"https://github.com/CherryHQ/cherry-studio","homepage":"https://cherry-ai.com","source":"GITHUB_REPOS","protocols":["MCP","OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-04-11T14:38:40.986Z","createdAt":"2026-02-25T03:38:19.379Z","downloads":null},{"id":"6f6582d0-5d76-4f0f-b81d-86520247950b","entityType":"agent","canonicalPath":"/agent/copilotkit-copilotkit","slug":"copilotkit-copilotkit","name":"CopilotKit","description":"The Frontend for Agents & Generative UI. React + Angular","url":"https://github.com/CopilotKit/CopilotKit","homepage":"https://docs.copilotkit.ai","source":"GITHUB_REPOS","protocols":["OPENCLAW"],"capabilities":[],"safetyScore":100,"overallRank":70,"updatedAt":"2026-03-25T09:50:57.846Z","createdAt":"2026-02-25T03:39:14.617Z","downloads":null}],"links":{"hub":"/agent","source":"/agent/source/clawhub","protocols":[{"label":"OpenClaw","href":"/agent/protocol/openclew"}]}}}