private void setHeaderStyle(ClosedXML.Excel.IXLWorksheet sheet, int startCellRow, int startCellCol, int endCellRow, int endCellCol)
{
var rang = sheet.Range(startCellRow, startCellCol, endCellRow, endCellCol);
rang.Style.Font.Bold = true;
rang.Style.Font.FontColor = ClosedXML.Excel.XLColor.White;
rang.Style.Fill.BackgroundColor = ClosedXML.Excel.XLColor.LightGray;
formateCells(rang);
}
private void setBorder(ClosedXML.Excel.IXLWorksheet sheet, int startCellRow, int startCellCol, int endCellRow, int endCellCol)
{
var rang = sheet.Range(startCellRow, startCellCol, endCellRow, endCellCol);
formateCells(rang);
}
private void RipulisciFoglio(ClosedXML.Excel.IXLWorksheet meseSheet)
{
meseSheet.Range("A3:Z100").Clear(ClosedXML.Excel.XLClearOptions.Contents);
}