public ExistingFileAndSheetControl(ConnectToExcelConfiguration configuration) { InitializeComponent(); this.DataContext = this.configuration = configuration; if (String.IsNullOrEmpty(configuration.FilePath) == false) { InitializeConnection(configuration.FilePath); } if (String.IsNullOrEmpty(configuration.SheetName) == false) { ddSheetsInWorkbook.SelectedItem = ddSheetsInWorkbook.Items.Cast <string>(). Where(t => t == configuration.SheetName).FirstOrDefault(); } }
public void GeneralLoadTestExcel() { ConnectToExcelConfiguration configuration = new ConnectToExcelConfiguration(); configuration.FilePath = @"TestData\LoadFromExcel\TestData.xlsx"; configuration.SheetName = "Contacts"; IConnection excelConnection = new ConnectToExcel() { Configuration = configuration }; IDataSource loadFromExcel = new LoadFromExcel(); IDatastore dataObject = DataStoreFactory.GetDatastore(); loadFromExcel.LoadData(excelConnection, dataObject, ReportProgressMethod); }
public static IDatastore LoadExcelsheet(string sheetPath, string sheetName) { ConnectToExcelConfiguration configuration = new ConnectToExcelConfiguration(); configuration.FilePath = sheetPath; configuration.SheetName = sheetName; IConnection excelConnection = new ConnectToExcel() { Configuration = configuration }; IDataSource loadFromExcel = new LoadFromExcel(); IDatastore dataStore = DataStoreFactory.GetDatastore(); loadFromExcel.LoadData(excelConnection, dataStore, ReportProgressMethod); return(dataStore); }
public NewFileAndSheetControl(ConnectToExcelConfiguration configuration) { InitializeComponent(); this.DataContext = this.configuration = configuration; }