Browse plugins

plugin-export-workbook

A plugin for exporting data in Flatfile to Workbooks.

Install
npm i @flatfile/plugin-export-workbook
Source:
View source
Package:
@flatfile/plugin-export-workbook 149 installs
Dependencies
@flatfile/api@^1.7.4, @flatfile/util-common@^1.1.1 (+2 more)

The @flatfile/plugin-export-workbook plugin exports data in a Flatfile Workbook to a downloadable .xlsx file.

Event Type: listener.on('job:ready')

Supported file types: .xlsx

When embedding Flatfile, this plugin should be deployed in a server-side listener. Learn more

Parameters

debug - boolean - (optional)

The debug parameter lets you toggle on/off helpful debugging messages for development purposes.

jobName - string - (optional)

The name of job that the plugin will fire on. If not provided, workbook:downloadWorkbook will be used.

excludedSheets - string[] - (optional)

An array of sheets to be excluded from the export

excludeFields - string[] - (optional)

An array of fields to be excluded from the export

recordFilter - Flatfile.Filter - (optional)

Allows filtering exported records to valid or error. By default all records will be exported

includeRecordIds - boolean - (optional)

Includes the record's ID

Usage

An action with the operation name of "downloadWorkbook" must be configured on a Workbook (not a Sheet) in order for the plugin to be triggered.

Install

npm i @flatfile/plugin-export-workbook

Import

import { exportWorkbookPlugin } from "@flatfile/plugin-export-workbook";

workbook.config.json

  // ... inside Workbook configuration
  "actions": [
    {
      "operation": "downloadWorkbook",
      "mode": "foreground",
      "label": "Download Excel Workbook",
      "description": "Downloads Excel Workbook of Data",
      "primary": true
    }
  ]
  // ...

listener.js

listener.use(exportWorkbookPlugin());