# Hucre Best Practices

> Use when working with hucre to read/write spreadsheets, choose format-specific imports, stream large data, validate schemas, and preserve round-trip content.

- Skill: `lazuee/hucre-best-practices` (Agent Skill, multi-file: 7 files)
- Install (CLI): `npx skillmds@latest add lazuee/hucre-best-practices`
- Raw SKILL.md: https://api.skillmd.com/api/skills/lazuee/hucre-best-practices/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: lazuee (https://skillmd.com/u/lazuee)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/lazuee/hucre-best-practices

---


# Hucre Best Practices

Practical rules for using hucre's read/write APIs, streaming, and schema validation. Contains 6 rules across 5 categories.

## When to Apply

- Reading or writing XLSX, CSV, ODS, JSON, or XML with hucre
- Choosing between the unified API and format-specific entry points
- Handling large datasets or memory-sensitive workflows
- Preserving charts, VBA, or unknown workbook parts
- Applying styles, dates, or validation rules

## Rules Summary

### Imports & Formats (HIGH)

#### tree-shaking-imports - @rules/tree-shaking-imports.md

Use format-specific entry points when the file type is known to keep bundles small.

### Data Integrity (HIGH)

#### object-io-and-schema - @rules/object-io-and-schema.md

Prefer object-based reads plus schema validation over positional column parsing.

### Scale (HIGH)

#### stream-large-sheets - @rules/stream-large-sheets.md

Stream rows or write incrementally to avoid loading full workbooks.

### Preservation & Styling (MEDIUM)

#### round-trip-preservation - @rules/round-trip-preservation.md

Use `openXlsx` and `saveXlsx` when you need to keep unknown parts.

#### sparse-cell-overrides - @rules/sparse-cell-overrides.md

Use `cells: Map` for targeted styling or formulas instead of rebuilding full rows.

### Dates & Numbers (MEDIUM)

#### explicit-date-system - @rules/explicit-date-system.md

Set `dateSystem` and `numFmt` explicitly when working with dates.