About: This article introduces the Fix Excel node, an Add In node within Construct.
Location: Rapid Insight Collaborative Cloud
Table of Contents
Feature Overview
Excel offers many formatting options for data. However, certain formatting features within Excel extracts make it difficult for Construct to identify the file schema required to read in the data. The Fix Excel node is used to remove header rows, and drop leading columns so that the file is readable by Construct. When the reformatting (fixing) is complete, a new Excel file is written, which can then be used within Construct as normal.
The Fix Excel node requires two inputs and has three optional fields.
Note: The Header Rows, Drop Rows, and Drop Columns fill with default values, however 0 is an acceptable input if not rows or columns should be dropped.
Required Inputs:
- The Source Excel File field should contain the file path to the Excel file that needs to be fixed by using the ellipsis [...] to browse to the file.
- The Fixed Excel File should also contain a file path by using the ellipsis, however this should be the file path of the location the fixed version of the file will be written to.
Optional Fields:
- The Header Rows field should contain the number of header rows that exist in the file.
- The Drop Rows field should contain the number of header rows that need to be removed.
- Note: in most circumstances all headers are removed, so these two numbers are often the same.
- The Drop Columns field should contain the number of columns that need to be removed.
As an example, here is an Excel document with a single header row that needs to be removed.
The configuration for this file would be Header Rows: 1, Drop Rows: 1, Drop Columns: 0.
Note: This node uses Excel automation, so Excel must be installed. Also, Microsoft limits automation of Excel to foreground applications. So this node only works interactively, and doesn't work in Construct Pro or Construct Enterprise.
Comments
0 comments
Article is closed for comments.