public SpreadsheetManagementService(ISqlConnectionProvider connectionProvider) { _connectionProvider = connectionProvider; var exporter = new DefaultSpreadsheetExporter(); var importer = new DefaultSpreadsheetImporter(connectionProvider, "InsertIntoFees2SP"); var template = new TestTemplate(); _service = new SpreadsheetService(exporter, importer, new AlwaysTrueSpreadsheetValidator(), template); }
public void Init() { _workbook = new Workbook(); _workbook.Worksheets["Sheet1"]["A1"].Value = "column1"; _workbook.Worksheets["Sheet1"]["A2"].Value = "column2"; _workbook.Worksheets["Sheet1"]["A3"].Value = "column3"; _template = new StubSpreadsheetTemplate(_workbook, null, new Dictionary <int, string> { [1] = "column1", [2] = "column2", [3] = "column3" }); _connectionProvider = new DefaultSqlConnectionProvider("main"); _importer = new DefaultSpreadsheetImporter(_connectionProvider, "dummy"); _table = _importer.StripExcelData(_workbook, _template); }