<< Click to Display Table of Contents >> Navigation:  Nodes > Tasks > Spreadsheets > Concat XLS

 

Purpose

 

This node permits to join several .XLS spreadsheet files into a single one, which is a common need when trying to automate workflows based on user production spreadsheets.

This node is written on Python, and the source code is provided for user convenience (Code property). It is meant to serve as a simple example about how to interact with external production spreadsheets within Mistika Workflows.

 

Standard properties

 

Object Name

Color

Bypass

Lock

 

Inputs

 

xls: xls files coming from another node.

 

 

Outputs

 

xls: create a single xls file with all the inputs concatenated.

 

 

Node Properties

 

Dst. Folder: Where to store the output xls file.

 

 

Python standard properties

code

Schema name

 

NOTE: An introduction to all the Python tools in Mistika Workflows is available in the Python scripting tools section.

 

 

 

 

 

 

 

 

Developer reference (Python - ConcatXLS.[Property ID], API Rest - node/ConcatXLS/property/[Property ID])