private void MontarCabecalho(IXLWorksheet worksheet, ConselhoClasseAtaFinalCabecalhoDto dadosCabecalho, int totalColunas)
{
worksheet.AddPicture(ObterLogo())
.MoveTo(worksheet.Cell(2, 2))
.Scale(0.15);
int indiceColunaTitulo = (int)(totalColunas * 0.8) + 1;
worksheet.Row(2).Cell(indiceColunaTitulo).Value = "SGP - Sistema de Gestão Pedagógica";
worksheet.Range(2, indiceColunaTitulo, 2, totalColunas).Merge().Style.Font.Bold = true;
worksheet.Range(2, indiceColunaTitulo, 2, totalColunas).Style.Font.FontSize = 10;
worksheet.Range(2, indiceColunaTitulo, 2, totalColunas).Style.Font.FontName = "Arial";
worksheet.Row(3).Cell(indiceColunaTitulo).Value = "ATA DE RESULTADOS FINAIS";
worksheet.Range(3, indiceColunaTitulo, 3, totalColunas).Merge().Style.Font.FontSize = 10;
worksheet.Range(3, indiceColunaTitulo, 3, totalColunas).Style.Font.FontName = "Arial";
int indiceFinal = SetarItemCabecalho(worksheet, $"DRE: {dadosCabecalho.Dre}", 0.4, LINHA_CABECALHO_DRE, 1, totalColunas);
indiceFinal = SetarItemCabecalho(worksheet, $"Unidade Escolar (UE): {dadosCabecalho.Ue}", 0.4, LINHA_CABECALHO_DRE, indiceFinal, totalColunas);
SetarItemCabecalho(worksheet, $"Turma: {dadosCabecalho.Turma}", 0.2, LINHA_CABECALHO_DRE, indiceFinal, totalColunas);
indiceFinal = SetarItemCabecalho(worksheet, $"Ciclo: {dadosCabecalho.Ciclo}", 0.4, LINHA_CABECALHO_CICLO, 1, totalColunas);
indiceFinal = SetarItemCabecalho(worksheet, $"Ano Letivo: {dadosCabecalho.AnoLetivo}", 0.4, LINHA_CABECALHO_CICLO, indiceFinal, totalColunas);
SetarItemCabecalho(worksheet, $"Data: {dadosCabecalho.Data}", 0.2, LINHA_CABECALHO_CICLO, indiceFinal, totalColunas);
}
public static void AddHeaderToWorkSheet(this IXLWorksheet worksheet, string title, string logo, int tableLength = 5)
{
worksheet.Row(1).InsertRowsAbove(5);
var mergeRangeColumn = 'E';
if (tableLength != 5)
{
mergeRangeColumn = NumberToLetter(tableLength);
}
if (!string.IsNullOrEmpty(logo))
{
using (var memoryStream = new MemoryStream(File.ReadAllBytes(logo)))
{
worksheet.AddPicture(memoryStream).MoveTo(worksheet.Cell("A1")).WithSize(60, 60);
}
}
worksheet.Cell(2, 1).Value = ConstantHelpers.PROJECT.ToUpper();
worksheet.Cell(2, 1).Style.Font.FontSize = 12;
worksheet.Cell(2, 1).Style.Font.Bold = true;
worksheet.Cell(2, 1).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;
worksheet.Cell(2, 1).Style.Alignment.Vertical = XLAlignmentVerticalValues.Center;
worksheet.Range($"A2:{mergeRangeColumn}2").Merge();
worksheet.Cell(3, 1).Value = title;
worksheet.Cell(3, 1).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;
worksheet.Cell(3, 1).Style.Alignment.Vertical = XLAlignmentVerticalValues.Center;
worksheet.Range($"A3:{mergeRangeColumn}3").Merge();
}
private void importPicture(IXLWorksheet ws, string startRowName, int startIndex, string imagePath)
{
Bitmap bm = new Bitmap(imagePath);
var image = ws.AddPicture(bm)
.MoveTo(ws.Cell(startRowName + startIndex.ToString()))
.Scale(0.1);
}
private static void createSummarySheet(XLWorkbook workbook, TECBid bid, TECEstimator estimate)
{
IXLWorksheet worksheet = workbook.Worksheets.Add("Summary");
createProjectInfoSection(worksheet, bid, 1);
createCostSummarySection(worksheet, estimate, 7);
createLaborSummarySection(worksheet, estimate, 20, 1);
createSalesSummarySection(worksheet, estimate, 20, 4);
var image = worksheet.AddPicture(createPlotImage(estimate));
image.MoveTo(worksheet.Cell(28, 1).Address);
//image.Scale(.7);
worksheet.Columns().AdjustToContents();
worksheet.PageSetup.PageOrientation = XLPageOrientation.Portrait;
worksheet.PageSetup.FitToPages(1, 1);
}
public static async Task AddImage(IXLWorksheet ws, string imageUrl, int row, int col)
{
if (imageUrl == null)
{
return;
}
try
{
using var strm = await GetImageStream(imageUrl);
ws.AddPicture(strm)
.MoveTo(ws.Cell(row, col))
.WithSize(100, 100)
;
}
catch
{
Console.WriteLine($"Error finding image: {imageUrl}");
}
}