skills.rest
filimorniga-ux
filimorniga-uxCOMMUNITY
Explore all skills by this author →
GitHub

excel-reports-vallenar

Generate branded Excel reports from transactional pharmacy data with exceljs.

Updated Nov 25, 2025
Search Tags:#automation#branding#reporting#excel#xlsx#bi#exceljs
One-click install
npx skills add https://github.com/filimorniga-ux/farmacias-vallenar-suit --skill excel-reports-vallenar
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: excel-reports-vallenar
Source: https://github.com/filimorniga-ux/farmacias-vallenar-suit/tree/main/.agent/skills/excel-reports-vallenar
Command: npx skills add https://github.com/filimorniga-ux/farmacias-vallenar-suit --skill excel-reports-vallenar

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Provides an automated, production-grade process to produce executive-level Excel exports from transactional pharmacy systems so that management receives clean, branded, and analysis-ready workbooks instead of raw CSV dumps.

Core Features & Use Cases

  • Branding & Visual Identity: Apply corporate colors, header styles, and zebra striping to every workbook for consistent presentation.
  • Contextual Metadata & Layout: Reserve top rows for report title and metadata (branch, user, generation timestamp) with the table beginning on a fixed row.
  • Excel UX & Native Types: Auto-fit columns, enable auto-filters, freeze header panes, format CLP currency, dates, numbers, and present totals with styled summary rows for cash closings, inventory reports, and managerial dashboards.
  • Integration: Designed to be implemented with exceljs in Next.js/TypeScript backends and extendable via a shared ExcelService class.

Quick Start

Generate an executive Excel report for the "Cierre de Caja" of branch "Vallenar Centro" including branded headers, metadata rows, currency formatting, auto-filters, freeze panes, and a totals row.

Frequently Asked Questions about excel-reports-vallenar

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

FAQPage Schema
How do I generate branded Excel reports from transactional data in Next.js?▼

Format CLP currency in Excel exports by applying exceljs number formatting rules to specific columns. The Skill configures peso formatting alongside dates and numbers to ensure financial summaries display correctly.

Can I add auto-filters and freeze panes to xlsx files using exceljs?▼

Yes, you can add auto-filters and freeze panes to xlsx files using exceljs. The Skill configures these Excel UX features automatically, alongside auto-fit columns and styled totals rows, to improve navigation for large datasets.

What is the best way to automate cash closing reports for pharmacy branches?▼

Automate cash closing reports by processing branch-level transactional data into a formatted xlsx workbook with corporate styling. The Skill reserves top rows for branch metadata and adds summary totals for managerial review.

Does this reporting approach support inventory FEFO summaries and managerial dashboards?▼

Yes, this reporting approach supports inventory FEFO summaries and managerial dashboards. It transforms transactional pharmacy data into consolidated workbooks with zebra striping, auto-filters, and embedded contextual metadata.

How do I include corporate branding and metadata in automated Excel exports?▼

Include corporate branding and metadata in Excel exports by defining header styles and reserving top rows for report titles, branch names, and generation timestamps. The Skill applies this layout consistently across generated workbooks.

Related Skills

Explore More Data & Analytics Skills→
joshka0joshka0
3

foxctl JQ

Filter, transform, and extract fields from JSON or YAML using jq queries.

Community
Basic
L-LesterYuL-LesterYu
51

markdown-converter-zh

Convert PDF, DOCX, XLSX, PPTX, HTML, images, audio, and ZIP files to Markdown.

Community
Basic
filimorniga-uxfilimorniga-ux

input-behavior-chile

Format RUT, CLP currency, and +56 phone numbers in React/Next.js forms.

Community
Intermediate
rezosndrezosnd

excel-generator

Generate styled Excel workbooks with formulas, charts, and data validation.

Community
Intermediate