Skip to main content

Microsoft Excel (Windows)

The Microsoft Excel package provides comprehensive automation capabilities for working with Excel files on Windows. This package uses the Microsoft Office Interop library to interact with Excel applications, enabling you to automate complex spreadsheet operations.

Platform Requirement

This package is available only on Windows platforms and requires Microsoft Excel to be installed.

Key Features​

  • File Management - Open, create, save, and close Excel files with password protection support
  • Sheet Operations - Create, delete, copy, and activate worksheets
  • Cell Manipulation - Read, write, and modify individual cells with format support
  • Range Operations - Work with ranges of cells for bulk data operations
  • Row & Column Management - Insert, delete, and retrieve rows and columns
  • Formulas & Functions - Get and set Excel formulas
  • Advanced Features - Run macros, search sheets, export charts and ranges to images
  • Hyperlink Support - Extract and work with hyperlinks in cells

Common Workflow​

A typical Excel automation workflow follows this pattern:

  1. Open Excel - Use the Open Excel node to open an existing file or Create Excel to create a new file
  2. Manipulate Data - Use various nodes to read, write, or modify data
  3. Save Changes - Use Save Excel to persist changes
  4. Close Excel - Use Close Excel to release resources

File Descriptor​

Most nodes in this package require a File Descriptor input. This is a unique identifier returned by the Open Excel or Create Excel nodes and used to reference the opened Excel file throughout your automation flow.