create_valid_excel: Create a formatted Excel file based on validation rules

In One4All: Validate, Share, and Download Data

Create a formatted Excel file based on validation rules

Description

This function creates an Excel file with conditional formatting and data validation based on the given validation rules in a CSV or Excel file. This function is currently compatible with Windows and Linux operating systems. When using a macOS system, the excel file is able to download, but has some bugs with formatting the LOOKUP sheet.

Usage

create_valid_excel(
  file_rules,
  negStyle = createStyle(fontColour = "#9C0006", bgFill = "#FFC7CE"),
  posStyle = createStyle(fontColour = "#006100", bgFill = "#C6EFCE"),
  row_num = 1000
)

Arguments

file_rules	A CSV or Excel file containing validation rules.
negStyle	Style to apply for negative conditions (default is red text on a pink background).
posStyle	Style to apply for positive conditions (default is green text on a light green background).
row_num	Number of rows to create in the output file (default is 1000).

Value

A workbook object containing the formatted Excel file.

Examples

data("test_rules")
create_valid_excel(file_rules = test_rules)

One4All documentation built on July 4, 2024, 1:08 a.m.