public void GivenResponseDataContainsCell_WhenConvertingToSheet_CellShouldHaveCorrectRowNumber()
        {
            var csvData = new CsvDataBuilder()
                          .WithRow(new List <string> {
                "myValue"
            })
                          .Build();

            var converter = new CsvToSheetConverter();

            var result = converter.Convert(csvData);

            result.Rows.Single().Cells.Should().NotBeEmpty();
            result.Rows.Single().Cells.Should().Contain(c => c.RowIndex == 0);
        }
        public void GivenResponseDataContainsRow_WhenConvertingToSheet_CellsInRowAreCreated()
        {
            var rowZeroColumnAValue = "row";
            var rowZeroColumnBValue = "0";
            var rowZeroColumnCValue = "text";

            var csvData = new CsvDataBuilder()
                          .WithRow(new List <string> {
                rowZeroColumnAValue, rowZeroColumnBValue, rowZeroColumnCValue
            })
                          .Build();

            var converter = new CsvToSheetConverter();

            var result = converter.Convert(csvData);

            result.Rows.Should().NotBeEmpty();
            result.Rows.Single().Cells.Should().Contain(c => c.Value.ToString() == rowZeroColumnAValue);
            result.Rows.Single().Cells.Should().Contain(c => c.Value.ToString() == rowZeroColumnBValue);
            result.Rows.Single().Cells.Should().Contain(c => c.Value.ToString() == rowZeroColumnCValue);
        }