createXlsxFile

Generate Excel files from workflow data with professional formatting

The createXlsxFile function enables Vibes to generate Excel files from workflow data, providing a powerful way to export, format, and share structured information. This function transforms arrays of data into professionally formatted Excel spreadsheets with customizable styling, headers, and layouts.

overview

The createXlsxFile function is designed to convert structured workflow data into professional Excel files that can be shared, analyzed, and used across different applications. It provides comprehensive formatting options and handles various data types automatically.

Function Purpose

Convert workflow data into Excel files with comprehensive formatting options, custom headers, and professional styling for data export and sharing.

When to Use createXlsxFile

Financial Reporting

Generate financial reports and analyses for stakeholders and management

  • Quarterly revenue reports
  • Budget variance analyses
  • Expense tracking summaries

Inventory Management

Export inventory data for analysis and sharing with teams

  • Stock level reports
  • Product catalog exports
  • Supplier data files

Customer Analytics

Create customer data exports for analysis and business intelligence

  • Customer behavior analysis
  • Sales performance metrics
  • Survey response data

Data Processing Capabilities

Object Arrays

Most common use case with structured data objects

[
  { "name": "John Doe", "email": "john@example.com", "age": 30, "active": true },
  { "name": "Jane Smith", "email": "jane@example.com", "age": 25, "active": false }
]

Primitive Arrays

Simple lists converted to single-column format

["Apple", "Banana", "Orange", "Grape"]

Mixed Data Types

Automatically handles strings, numbers, booleans, dates, and objects

[
  {
    "product_name": "Widget A",
    "price": 29.99,
    "in_stock": true,
    "launch_date": "2024-01-15",
    "metadata": { "category": "electronics", "weight": "1.2kg" }
  }
]