Cingulara / openrmf-docs

Documentation on the OpenRMF application, including scripts to run the whole stack as well as just infrastructure with documentation on using the tool.
https://www.openrmf.io/
GNU General Public License v3.0
125 stars 27 forks source link

[FEATURE] Update the POAM export to more match eMASS formats for DoD folks #272

Closed DaleBinghamSoteriaSoft closed 2 years ago

DaleBinghamSoteriaSoft commented 2 years ago

Is your feature request related to a problem? Please describe. The POAM in XLSX is not 100% compatible with eMASS format so we should update that.

Describe the solution you'd like A better format matching eMASS POAM format.

Describe alternatives you've considered n/a

Additional context n/a

Cingulara commented 2 years ago

Need to add in the merged cells for borders and such to work well

MergeCells mergeCells = new MergeCells();
mergeCells.Append(new MergeCell() { Reference = new StringValue("A1:F1") });
mergeCells.Append(new MergeCell() { Reference = new StringValue("A2:F2") });

// save the merged cells
worksheetPart.Worksheet.InsertAfter(mergeCells, worksheetPart.Worksheet.Elements<SheetData>().First());

// Save the new worksheet.
workbookpart.Workbook.Save();