Skip to main content

Excel

Read, write, and manipulate Excel files (.xlsx, .xls) in your automation workflows without requiring Microsoft Excel.

Overview​

The Excel package provides comprehensive spreadsheet manipulation capabilities. Unlike the Microsoft Excel package which requires Excel installed, this package works directly with Excel file formats. Use it for processing Excel files on any system, regardless of Office installation.

Key Features​

  • Read/Write Files - Open, create, and save Excel workbooks
  • Cell Operations - Read and write individual cells
  • Range Operations - Work with ranges of cells
  • Row/Column Operations - Insert, delete, get rows and columns
  • Sheet Management - Add, copy, switch between sheets
  • Formatting - Apply cell styles
  • Conversion - Export Excel to CSV

Available Nodes​

  • Create Excel - Create a new workbook
  • Open Excel - Open an existing Excel file
  • Save Excel - Save workbook changes
  • Close Excel - Close the workbook
  • Get Cell Value / Set Cell Value - Read/write individual cells
  • Get Range / Set Range - Read/write cell ranges
  • Get Row / Get Column - Read entire rows or columns
  • Insert Row / Insert Column - Add new rows or columns
  • Delete Row / Delete Column / Delete Cell - Remove data
  • Get Sheets - List all worksheets
  • Create Sheet / Copy Sheet - Manage worksheets
  • Switch to Sheet - Change active sheet
  • Set Active Cell - Position the active cell
  • Set Formula - Add formulas to cells
  • Set Style - Apply formatting
  • Find and Replace - Search and replace text
  • Append Excel - Add data to end of sheet
  • Merge Excel - Combine multiple workbooks
  • Excel to CSV - Export to CSV format

When to Use This Package​

  • Data Processing: Process Excel reports and exports
  • Report Generation: Create Excel reports from data
  • Data Import/Export: Convert Excel data for other systems
  • Template Filling: Fill Excel templates with data
  • Batch Processing: Process multiple Excel files

Excel vs Microsoft Excel Package​

Use Excel package when:

  • Microsoft Excel is not installed
  • Running on Linux/Mac servers
  • Need lightweight file manipulation

Use Microsoft Excel package when:

  • Need advanced Excel features (macros, charts)
  • Require exact Excel formatting
  • Working with complex Excel formulas