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 static void InitTest(TestContext cnt) { _dataTable = new DataTable(); _dataTable.Columns.Add("column1"); _dataTable.Columns.Add("column2"); _dataTable.Columns.Add("column3"); _dataTable.Columns.Add("column4"); addRow(_dataTable, new object[] { 1, 2, 3, 4 }); addRow(_dataTable, new object[] { 1, 2 }); for (int i = 0; i < 197; i++) { addRow(_dataTable, new object[] { 1, 2, 3, 4 }); } _workbook = new Workbook(); //workbook.Worksheets.Add("Sheet1"); _workbook.Worksheets[SheetName].SetCellValue(1, 1, "column1"); _workbook.Worksheets[SheetName][1, 1].Style.Color = Color.DarkRed; _workbook.Worksheets[SheetName].SetCellValue(1, 2, "column2"); _workbook.Worksheets[SheetName].SetCellValue(1, 4, "column3"); _workbook.Worksheets[SheetName].SetCellValue(1, 5, "column5"); _defaultSpreadsheetExporter = new DefaultSpreadsheetExporter(); _data = new StubExportData(_dataTable, null); _template = new StubSpreadsheetTemplate(_workbook, new Dictionary <string, int> { ["column1"] = 1, ["column2"] = 2, ["column3"] = 4 }, null); using (MemoryStream stream = new MemoryStream()) { _wk = new Workbook(); _defaultSpreadsheetExporter.ExportSpreadsheet(_data, _template, stream); _wk.LoadFromStream(stream); _wk.Version = ExcelVersion.Version2013; } }