This module has a single function listed below which implements the DataStream interface for Excel files. Note that this modules uses Taro which is dependent upon Java.
ExcelDataStreams.ExcelDataStream
— Method.ExcelDataStream( filename::AbstractString; kwargs... )
Constructor for type which gives access to an Excel file as a DataStream
Arguments
filename::AbstractString
: the name of the Excel file to stream
Keyword Arguments
columnindices::Vector{Int}
– The indices of columns to use as fields. Defaults to empty.names::Vector{Symbol}
– The names to use for the fields. Defaults to empty.eltypes::Vector{DataTypes}
– The types expected for each field. Conversion will be attemped. Defaults to empty.sheet::String
– Which sheet of the Excel file contains the data of interest. Defaults tosheet1
.skipstart::Int
– How many initial rows of the Excel file to skip. Defaults to0
.nastrings::Vector{String}
– Strings to consider to be missing data. Defaults to empty.