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);
}
