private void AddTableHeaders(WorksheetPart worksheetPart)
{
var headers = new List <string>()
{
"Código", "Título", "Datas de Produção", "Cota", "Guia de Incorporação", "Código de Barras"
};
XLSXExportHelper.InsertValuesInWorksheet(worksheetPart, 1, headers);
}
protected override void FillContentsXLSX()
{
var doc = XLSXExportHelper.CreateDocument(this.GetFileName, this.GetTitle());
var worksheetPart = doc.WorkbookPart.WorksheetParts.First();
AddTableHeaders(worksheetPart);
uint rowIdx = 2;
foreach (var uf in ufs)
{
var values = BuildRow(uf);
XLSXExportHelper.InsertValuesInWorksheet(worksheetPart, rowIdx++, values);
DoRemovedEntries(1);
}
// Save the new worksheet.
worksheetPart.Worksheet.Save();
// Close the document.
doc.Close();
}
private void AddTableHeaders(WorksheetPart worksheetPart)
{
XLSXExportHelper.InsertValuesInWorksheet(worksheetPart, 1, headers);
}
