Up: Component summary Component

Excel2CSV

Converts a Microsoft Excel sheet to a CSV file.

Version 1.0
Bundle tools
Categories Convert Excel
Authors Julia Casado (julia.casado@helsinki.fi)
Issue tracker View/Report issues
Requires R ; xlsx (R-package)
Source files component.xml Excel2CSV.R
Usage Example with default values

Inputs

Name Type Mandatory Description
in Excel or Array<Excel> Mandatory An Excel (.xls or .xlsx) file or array of Excel files

Outputs

Name Type Description
out CSVList Folder containing the CSV file/s corresponding to the specified sheet of the input XLSX file/s.

Parameters

Name Type Default Description
header boolean true Indicate whether the first row contains the column names.
onlyCompleteRows boolean false If false, filters out rows with missing values.
sheet string "1" Number or name of sheet to extract, starts couting from 1.

Test cases

Test case Parameters IN
in
OUT
out
filter_NA properties in out

sheet = Descriptive name,
onlyCompleteRows = true

old_xls properties in out

sheet = Descriptive name

read_array (missing) in out
sheet_with_no_header properties in out

sheet = 2,
header = false

simple_case properties in out

sheet=1


Generated 2018-12-16 07:42:14 by Anduril 2.0.0