ETLBox ETLBox ETLBox Buy
API
Try Buy

ExcelSource

Class ExcelSource

Reads data from a excel source. While reading the data from the file, data is also asnychronously posted into the targets. You can define a sheet name and a range - only the data in the specified sheet and range is read. Otherwise, all data in all sheets will be processed.

Inheritance
object
LoggableTask
DataFlowComponent
DataFlowSource<ExpandoObject>
DataFlowExecutableSource<ExpandoObject>
DataFlowStreamSource<ExpandoObject>
ExcelSource<ExpandoObject>
ExcelSource
Implements
Inherited Members
Namespace: ETLBox.Excel
Assembly: ETLBox.Excel.dll
Syntax
    public class ExcelSource : ExcelSource<ExpandoObject>, IDataFlowStreamSource<ExpandoObject>, IDataFlowExecutableSource<ExpandoObject>, IDataFlowSource<ExpandoObject>, IDataFlowStreamSource, IDataFlowExecutableSource, IDataFlowSource, IDataFlowComponent, ILoggableTask
Examples
ExcelSource<ExcelData> source = new ExcelSource<ExcelData>("src/DataFlow/ExcelDataFile.xlsx") {
        Range = new ExcelRange(2, 4, 5, 9),
        SheetName = "Sheet2"
 };

Constructors

ExcelSource()

Declaration
    public ExcelSource()

ExcelSource(string)

Declaration
    public ExcelSource(string uri)
Parameters
TypeNameDescription
stringuri

The source excel file name or uri

Implements