private void formateCells(ClosedXML.Excel.IXLRange rang)
{
GC.Collect();
GC.WaitForPendingFinalizers();
GC.Collect();
rang.Style.Border.SetOutsideBorder(ClosedXML.Excel.XLBorderStyleValues.Thin);
rang.Style.Border.SetOutsideBorderColor(ClosedXML.Excel.XLColor.Black);
rang.Style.Border.SetInsideBorder(ClosedXML.Excel.XLBorderStyleValues.Thin);
rang.Style.Alignment.Horizontal = ClosedXML.Excel.XLAlignmentHorizontalValues.Center;
rang.Style.Alignment.Vertical = ClosedXML.Excel.XLAlignmentVerticalValues.Center;
}
public ExcelRange(ClosedXML.Excel.IXLRange range)
{
Range = range;
}