FlowPro Docs
  • What is FlowPro?
  • Guides
    • Installing FlowPro
    • Creating your first script
    • Managing Settings
    • Exporting a script
    • Environment and World
    • System Variables
    • Examples and Samples
      • Simple Calculator
    • Extras
      • Readme
      • Audit Check
  • FlowBlocks
    • Common terms
    • General
      • Start
      • End Block
      • Comment
      • Variable
      • File Function
      • Include File
      • Wait a little
      • Bulk Assign
      • Open a File
      • Unique String ID
      • Play a File
      • Break Execution
      • Parse Markdown
      • Parse String as Object
    • Builder
      • Form Settings
      • Readme
      • Render Label
      • User Simple Input
      • User Simple Input (2)
      • User Long Text Input
      • User Simple Number Input
      • User Dropdown
      • User Checkbox
      • User Date Input
      • User Date/Time Input
      • User Time Input
      • User Filename Input
      • User Button Action
      • User Button Build Form
      • Clear Form
      • View
    • Inputs
      • Short Text Input
      • Long Text Input
      • Numerical Input
      • Fetch as HTML/Json
      • Read Excel as Array
      • Read XML file
      • Parse XML Data
      • Read File As String
      • Read Dir
    • Output
      • Send Email
      • Save to Excel
      • Write to file
      • Pipe Output
      • Output in Window
      • Echo Message
      • Output Results to View
      • Display Data Table
      • Print World
    • Arrays and Objects
      • Filter an Array
      • Get Value by index
      • Get Value by key
      • Create an Object
      • Unpackage Object/Array
      • Create an Array
      • Array Push
      • Add to object
      • Object/Array Length
    • Strings
      • Split Text
      • Find and Replace
      • Character Count
      • String Length
      • Prepend / Append
      • Concat
      • Concat and Assign
      • Right Trim
      • Left Trim
      • Trim
      • To Lowercase
      • To Uppercase
      • Left (Before String)
      • Right (Before String)
      • Matches by Regex
      • Split Text By Line
      • To String
      • Line Break
      • Join Strings
      • Template String
    • Loops
      • Loop by number
      • Loop by Input
      • End Loop
      • While Do
    • Conditionals
      • If Do
      • If Else
      • If Null
      • If Not Null
      • If Exists in World
      • Multiple IF Do
      • If String Contains
      • End If
    • Numeric
      • Add Values
      • Subtract Values
      • Multiply values
      • Divide Values
      • Sum of Numbers
      • Round Number
      • Ceil
      • Random Number
      • Increment Number
      • Decrement Number
      • Modulus
    • Math
      • POW
      • Math.Ceil
      • Square Root
      • Sin
      • Cos
      • PI
      • Math Constants
    • HTML
      • Paragraph
      • Create Simple HTML Table
      • ImageListView Widget
      • Display Data Table
    • Files
      • Read File
      • File Base Name
      • IF File Exists
      • IF Path is File
      • IF Path is directory
      • Copy File
      • Move File
      • File Attributes
      • Create a Folder
    • Commands
      • Basic Command
      • Long Command
    • Database
      • MySQL Query
      • MySQL Query with Params
      • SQL Server
      • SQLITE Query
    • File Transfer
      • FTP Upload
      • FTP Download
      • FTP List Files
      • SFTP List Files
      • SFTP Upload
      • SFTP Download
  • Use Cases
    • For Programmers
      • Connection to an API
    • For the Office
      • Creating an Simple Report
  • Extras
    • Special Variables
    • Keyboard Shortcuts
Powered by GitBook
On this page
  • Description
  • Properties
  • Returns
  • NPM Package
  1. FlowBlocks
  2. Output

Save to Excel

Save to Excel

PreviousSend EmailNextWrite to file

Last updated 3 years ago

Description

Saving input as an excel file

Properties

Headers

The headers of the excel file. This is a query string with the header format for the excel file. This is required or the block would work correctly.

Data

This is an array of objects or an array. The block takes all the values from the array or object an adds them as a row in the excel file

Filename

This is the full path of the new file to be created and the correct extension.

Returns

Outputs an excel file if all conditions are met.

NPM Package

This block works using the json-as-xlsx package on npm. Check out the link here

https://www.npmjs.com/package/json-as-xlsx