Learn R Programming

vanddraabe (version 1.1.1)

oxAlignOverlapSheet: Align Overlap Data Sheet

Description

Constructs the openxlsx worksheet for the AlignOverlap() results.

Usage

oxAlignOverlapSheet(wb.name, sheet.name = "AlignOverlap", df)

Arguments

wb.name

Name of the workbook for the results; e.g., results.wb

sheet.name

Name of the worksheet being formatted; default: "AlignOverlap"

df

data.frame containing the summary of AlignOverlap(); e.g., df.results

Value

The workbook containing the indicated and newly formatted worksheet.

Details

This function is to ONLY be used with the results of AlignOverlap(). Specific aspects of how the returned data.frame will be formatted are hard-coded into this function.

Notable formatting:

  • Top row frozen

  • Column widths are set based on column content

  • Structures passing the AlignOverlap() evaluation are hightlighted lime green

  • Structures failing the AlignOverlap() evaluation are hightlighted pink

This openxlsx function is NOT exported.

See Also

Other "openxlsx functions": openxlsxCellStyles, oxClusterStatsSheet, oxClusterSummarySheet, oxInitWaterDataSheet, oxPDBcleanedSummarySheet, oxPlainDataSheet, oxRCSBinfoSheet, oxWaterOccurrenceSheet