public IBorderSpecification WithDiagonal(BorderStyle style, IBuilderSpecification <Color> colorSpecification, BorderDiagonal diagonal)
{
return(new BorderSpecification(this)
{
Diagonal = new Tuple <BorderStyle, IBuilderSpecification <Color>, BorderDiagonal>(style, colorSpecification, diagonal)
});
}
public ISpreadsheetWriter WithSheet(IBuilderSpecification <Sheet> specification)
{
return(new SpreadsheetWriter
{
WorkSheets = WorkSheets.Append(specification)
});
}
public IExpectCellFormat WithContent(DateTime value)
{
DefaultCellFormat = Specification.CellFormat()
.WithNumberFormat(Specification.NumberFormat().WithFormat(StandardNumberFormat.ShortDate));
return(WithContent(value.ToOADate().ToString(CultureInfo.InvariantCulture), CellType.Date));
}
public IBorderSpecification WithRight(BorderStyle style, IBuilderSpecification <Color> colorSpecification)
{
return(new BorderSpecification(this)
{
Right = new Tuple <BorderStyle, IBuilderSpecification <Color> >(style, colorSpecification)
});
}
private CellSpecification(CellSpecification cellSpecification)
{
Row = cellSpecification.Row;
Column = cellSpecification.Column;
CellType = cellSpecification.CellType;
Content = cellSpecification.Content;
CellFormat = cellSpecification.CellFormat;
DefaultCellFormat = cellSpecification.DefaultCellFormat;
}
public IBuilderSpecification <Border> WithOutline(BorderStyle style, IBuilderSpecification <Color> colorSpecification)
{
var tuple = new Tuple <BorderStyle, IBuilderSpecification <Color> >(style, colorSpecification);
return(new BorderSpecification(this)
{
Top = tuple,
Bottom = tuple,
Left = tuple,
Right = tuple
});
}
private CellFormatSpecification(CellFormatSpecification specification)
{
if (specification == null)
{
throw new ArgumentNullException(nameof(specification));
}
AlignmentSpecification = specification.AlignmentSpecification;
BorderSpecification = specification.BorderSpecification;
FillSpecification = specification.FillSpecification;
FontSpecification = specification.FontSpecification;
NumberFormatSpecification = specification.NumberFormatSpecification;
}
public IBuildingCellFormatSpecification WithBorder(IBuilderSpecification <Border> borderSpecification)
=> new CellFormatSpecification(this)
{
BorderSpecification = borderSpecification
};
public IExpectFontOptions WithColor(IBuilderSpecification <Color> colorSpecification)
=> new FontSpecification(this)
{
ColorSpecification = colorSpecification
};
public IFillSpecification WithForegroundColor(IBuilderSpecification <Color> colorSpecification)
=> new FillSpecification
{
PatternType = PatternType, BackgroundColor = BackgroundColor, ForegroundColor = colorSpecification
};
public IBuildingCellFormatSpecification WithNumberFormat(IBuilderSpecification <NumberFormat> numberFormatSpecification)
=> new CellFormatSpecification(this)
{
NumberFormatSpecification = numberFormatSpecification
};
public IBuildingCellFormatSpecification WithFont(IBuilderSpecification <Font> fontSpecification)
=> new CellFormatSpecification(this)
{
FontSpecification = fontSpecification
};
public IBuildingCellFormatSpecification WithFill(IBuilderSpecification <Fill> fillSpecification)
=> new CellFormatSpecification(this)
{
FillSpecification = fillSpecification
};
public IExpectCellRow WithStyle(IBuilderSpecification <CellFormat> formatSpecification)
=> new CellSpecification(this)
{
CellFormat = formatSpecification
};
public IBuildingCellFormatSpecification WithAlignment(IBuilderSpecification <Alignment> alignmentSpecification)
=> new CellFormatSpecification(this)
{
AlignmentSpecification = alignmentSpecification
};
public IExpectSheetContent WithMergedCell(IBuilderSpecification <MergeCell> specification)
{
var merge = mergeCellSpecifications.Append(specification);
return(new SheetSpecification(name, columnSpecifications, rowSpecifications, merge));
}
public IExpectSheetContent WithRow(IBuilderSpecification <Row> rowSpecification)
{
var rows = rowSpecifications.Append(rowSpecification);
return(new SheetSpecification(name, columnSpecifications, rows, mergeCellSpecifications));
}
public IExpectSheetContent WithColumn(IBuilderSpecification <Column> columnSpecification)
{
var cols = columnSpecifications.Append(columnSpecification);
return(new SheetSpecification(name, cols, rowSpecifications, mergeCellSpecifications));
}