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