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
ExcelSource
Implements
Inherited Members
Namespace: ETLBox.Excel
Assembly: ETLBox.Excel.dll
Syntax
public class ExcelSource : ExcelSource<ExpandoObject>, IDataFlowLogging, 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
Type | Name | Description |
---|---|---|
string | uri | The source excel file name or uri |