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.

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