/// <summary> /// Exports the data supplied to an excel workbook /// </summary> /// <param name="rowData">The data to be exported to the workbook</param> /// <param name="formatter"></param> public void WriteDataToExport(IEnumerable<IEnumerable<Cell>> rowData, CellFormatter formatter, ExcelFileType excelFileType) { if (excelFileType == ExcelFileType.XLS) { ExcelExporter = new ExcelXlsExporter(); } ExcelExporter.WriteDataToExport(rowData, formatter, "Sheet 1"); }
public void Should_return_stream_with_data() { MemoryStream outputStream = new MemoryStream(); ExcelExport target = new ExcelExport(); CellFormatter formatter = new CellFormatter(); target.WriteDataToExport(sampleData, formatter,ExcelFileType.XLS); target.ExportToStream(outputStream); Assert.IsTrue(outputStream.Length > 0); }
public void Setup() { target = new CellFormatter(); workBook = Helper.CreateWorkBookWithSheet(); sampleData = new List<List<Cell>> { new List<Cell> { new Cell {Value = "1"}, new Cell {Value = "2", IsBold = true}, new Cell {Value = "a"}, new Cell {Value = "b", IsBold = true}, } }; }
public void Setup() { sut = new ExcelExport(); formatter = new CellFormatter(); workBook = Helper.CreateWorkBookWithSheet(); sampleData = new List<List<Cell>> { new List<Cell> { new Cell {Value = "1"}, new Cell {Value = "2"}, new Cell {Value = "a"}, new Cell {Value = "b"}, } }; }