public void Border_should_have_default_values()
{
Border target = new Border();
Assert.AreEqual(BorderLocation.None, target.Location);
Assert.AreEqual(BorderStyle.None, target.Style);
Assert.AreEqual(Color.Black, target.Color);
}
static void Main(string[] args)
{
Console.WriteLine("Please enter the cell values, separated by commas.");
Console.WriteLine("To create merged cells, add : and col span value after cell value");
Console.WriteLine("For a new row press Enter.");
Console.WriteLine("To exit data entry mode, press Esc.");
var data = new List<List<Cell>>();
string row;
do
{
row = Console.ReadLine();
if (row != null)
{
var cellValues = row.Split(',');
var basicRow = new List<Cell>();
foreach (string cellValue in cellValues)
{
if (cellValue.Contains(":"))
{
string[] cellData = cellValue.Split(':');
string value = cellData[0];
string colSpanString = cellData[1];
int colSpan = Int32.Parse(colSpanString);
Border border = new Border
{
Color = Color.Red,
Location = BorderLocation.Bottom,
Style = BorderStyle.Thick
};
List<Border> borders = new List<Border>();
borders.Add(border);
basicRow.Add(new Cell()
{
Value = value,
ColumnSpan = colSpan,
BackgroundColor = Color.LightGray,
Borders = borders
});
}
else
{
basicRow.Add(new Cell { Value = cellValue });
}
}
data.Add(basicRow);
}
} while (row != String.Empty);
var export = new ExcelExport();
export.WriteDataToExport(data, new CellFormatter(), ExcelFileType.XLS);
using (var stream = new FileStream(@"C:\temp\export.xls", FileMode.Create))
{
export.ExportToStream(stream);
}
Console.WriteLine(@"File exported to: C:\temp\export.xls");
Console.ReadLine();
}
