Execute qualquer Skill no Manus
com um clique

Execute qualquer Skill no Manus com um clique

automating-excel

Estrelas63

Forks12

Atualizado9 de abril de 2026 às 10:10

Automates Microsoft Excel on macOS via JXA with AppleScript dictionary discovery. Use when asked to "automate Excel spreadsheets", "JXA Excel scripting", "Excel macOS automation", or "bulk Excel data operations". Focuses on workbooks, worksheets, ranges, 2D arrays, performance toggles, and VBA escape hatches.

Instalação

Instalar com Codex ou Claude Copie este prompt, cole no Codex, Claude ou outro assistente e deixe que ele revise a página da skill e instale para você.

Executar no Manus

Fonte

iBz-04

iBz-04/gloamy

Abrir repositório GitHub Ver repositórios do creator

Download

Executar no Manus

Ocupações relacionadasSOC

Baseado na classificação ocupacional SOC

Desenvolvedores de softwareInformática e Matemática·SOC 15-1252

Explorador de arquivos

13 arquivos

SKILL.md

readonly

name	automating-excel
description	Automates Microsoft Excel on macOS via JXA with AppleScript dictionary discovery. Use when asked to "automate Excel spreadsheets", "JXA Excel scripting", "Excel macOS automation", or "bulk Excel data operations". Focuses on workbooks, worksheets, ranges, 2D arrays, performance toggles, and VBA escape hatches.
allowed-tools	["Bash","Read","Write"]

Automating Excel (JXA-first, AppleScript discovery)

Relationship to the macOS automation skill

Standalone for Excel, but aligned with automating-mac-apps patterns.
Use automating-mac-apps for permissions, shell, and UI scripting guidance.
PyXA Installation: To use PyXA examples in this skill, see the installation instructions in automating-mac-apps skill (PyXA Installation section).

Core Framing

Excel AppleScript dictionary is AppleScript-first; use Script Editor for discovery.
JXA is the production language for logic and data processing.
Collections are specifiers; read via methods, set via assignments.
Handle errors from Excel operations using try/catch blocks and Application error checking.

Workflow (default)

Discover dictionary terms in Script Editor (Excel).
Prototype a minimal AppleScript command.
Port to JXA and add defensive checks.
Use bulk read/write (2D arrays) for performance.
Use VBA run() when dictionary coverage is missing.

Validation Steps

Test with empty documents to verify error handling
Verify data integrity after batch operations
Check Excel UI responsiveness after automation runs
Log errors with specific Excel object paths for debugging

Examples

Basic workbook read:

const Excel = Application('Microsoft Excel');
const workbook = Excel.workbooks[0];
const worksheet = workbook.worksheets['Sheet1'];
const range = worksheet.ranges['A1:B10'];
const data = range.value();  // Returns 2D array

Bulk write with performance toggle:

Excel.screenUpdating = false;
Excel.calculation = 'manual';
try {
  const range = worksheet.ranges['C1:D100'];
  range.value = my2DArray;
} finally {
  Excel.calculate();
  Excel.screenUpdating = true;
}

VBA escape hatch:

Excel.run('MyMacro', {arg1: 'value', arg2: 123});  // Calls VBA subroutine

When Not to Use

For general macOS automation without Excel involvement
When AppleScript alone suffices (no JXA logic needed)
For Excel tasks requiring complex UI interactions (use automating-mac-apps for that)
When cross-platform compatibility is required

What to load

JXA Excel basics: automating-excel/references/excel-basics.md
Recipes (ranges, 2D arrays, formatting): automating-excel/references/excel-recipes.md
Advanced patterns (performance toggles, VBA bridge): automating-excel/references/excel-advanced.md
Pivot table guidance: automating-excel/references/excel-pivots.md
Charting guidance: automating-excel/references/excel-charts.md
Dictionary translation table: automating-excel/references/excel-dictionary.md
PyXA (Python) alternative: automating-excel/references/excel-pyxa.md

Mais deste repositório

mesmo repositório

automating-powerpoint

iBz-04/gloamy

Automates Microsoft PowerPoint via JXA (osascript). Use when asked to "make a PowerPoint", "create a presentation", "open PowerPoint and make slides", "turn this into a deck", "make slides from this text", "create a PowerPoint on this", "automate PowerPoint presentations", "create slides programmatically", "JXA PowerPoint scripting", or "export PowerPoint to PDF". Covers presentations, slides, shapes, text, tables, export enums, and interop with Excel. ALWAYS use JXA via osascript — never use Python pptx or pip to create PowerPoint files.

2026-04-1763

pptx

iBz-04/gloamy

Handle presentation decks with deliberate layout, reusable structure, and quality checks that catch visual regressions.

2026-04-1763

automating-notes

iBz-04/gloamy

Automates Apple Notes via JXA (osascript). Use when asked to "create notes programmatically", "automate Notes app", "JXA notes scripting", or "organize notes with automation". Covers accounts/folders/notes, HTML bodies, queries, moves, and Objective-C/UI fallbacks for Notes.app automation on macOS. ALWAYS use JXA via osascript as the primary method — PyXA silently fails on note creation and must NOT be used as the first approach.

2026-04-1563

automating-calendar

iBz-04/gloamy

Automates macOS Calendar via JXA with AppleScript dictionary discovery. Use when asked to "create calendar events", "automate calendar", "JXA calendar scripting", "EventKit automation", or "PyXA calendar automation". Covers events, calendars, recurrence, time zones, batch operations, and EventKit ObjC bridge.

2026-04-0963

automating-chrome

iBz-04/gloamy

Automates Google Chrome and Chromium-based browsers via JXA with AppleScript dictionary discovery. Use when asked to "automate Chrome tabs", "control browser with JXA", "Chrome AppleScript automation", "Chromium browser scripting", or "browser tab management". Covers windows, tabs, execute(), tunneling patterns, and permissions.

2026-04-0963

automating-contacts

iBz-04/gloamy

Automates macOS Contacts via JXA with AppleScript dictionary discovery. Use when asked to "automate contacts", "JXA contacts automation", "macOS address book scripting", "AppleScript contacts", or "Contacts app automation". Covers querying, CRUD, multi-value fields, groups, images, and ObjC bridge fallbacks.

2026-04-0963

name	automating-excel
description	Automates Microsoft Excel on macOS via JXA with AppleScript dictionary discovery. Use when asked to "automate Excel spreadsheets", "JXA Excel scripting", "Excel macOS automation", or "bulk Excel data operations". Focuses on workbooks, worksheets, ranges, 2D arrays, performance toggles, and VBA escape hatches.
allowed-tools	["Bash","Read","Write"]

Automating Excel (JXA-first, AppleScript discovery)

Relationship to the macOS automation skill

Standalone for Excel, but aligned with automating-mac-apps patterns.
Use automating-mac-apps for permissions, shell, and UI scripting guidance.
PyXA Installation: To use PyXA examples in this skill, see the installation instructions in automating-mac-apps skill (PyXA Installation section).

Core Framing

Excel AppleScript dictionary is AppleScript-first; use Script Editor for discovery.
JXA is the production language for logic and data processing.
Collections are specifiers; read via methods, set via assignments.
Handle errors from Excel operations using try/catch blocks and Application error checking.

Workflow (default)

Discover dictionary terms in Script Editor (Excel).
Prototype a minimal AppleScript command.
Port to JXA and add defensive checks.
Use bulk read/write (2D arrays) for performance.
Use VBA run() when dictionary coverage is missing.

Validation Steps

Test with empty documents to verify error handling
Verify data integrity after batch operations
Check Excel UI responsiveness after automation runs
Log errors with specific Excel object paths for debugging

Examples

Basic workbook read:

const Excel = Application('Microsoft Excel');
const workbook = Excel.workbooks[0];
const worksheet = workbook.worksheets['Sheet1'];
const range = worksheet.ranges['A1:B10'];
const data = range.value();  // Returns 2D array

Bulk write with performance toggle:

Excel.screenUpdating = false;
Excel.calculation = 'manual';
try {
  const range = worksheet.ranges['C1:D100'];
  range.value = my2DArray;
} finally {
  Excel.calculate();
  Excel.screenUpdating = true;
}

VBA escape hatch:

Excel.run('MyMacro', {arg1: 'value', arg2: 123});  // Calls VBA subroutine

When Not to Use

For general macOS automation without Excel involvement
When AppleScript alone suffices (no JXA logic needed)
For Excel tasks requiring complex UI interactions (use automating-mac-apps for that)
When cross-platform compatibility is required

What to load

JXA Excel basics: automating-excel/references/excel-basics.md
Recipes (ranges, 2D arrays, formatting): automating-excel/references/excel-recipes.md
Advanced patterns (performance toggles, VBA bridge): automating-excel/references/excel-advanced.md
Pivot table guidance: automating-excel/references/excel-pivots.md
Charting guidance: automating-excel/references/excel-charts.md
Dictionary translation table: automating-excel/references/excel-dictionary.md
PyXA (Python) alternative: automating-excel/references/excel-pyxa.md