qol (version 1.2.0)

style_options: Set Global Styling Options For Excel Workbooks

Description

Modify Styling options for Excel workbooks. Available parameters can be seen in excel_output_style() or number_format_style().

set_style_options() sets the styling options for Excel workbooks globally.These options are used by all tabulation and output functions, which are capable of exporting styled outputs.

reset_style_options() resets global style options to the default parameters.

get_style_options() prints out the currently set global styling options.

close_file() is a simple, more readable wrapper for setting file parameter to NULL.

set_variable_labels(): Can set variable labels globally so that they don't have to be provided in every output function separately.

get_variable_labels(): Get the globally stored variable labels.

set_stat_labels(): Can set statistic labels globally so that they don't have to be provided in every output function separately.

get_stat_labels(): Get the globally stored statistic labels.

reset_qol_options() resets global options to the default parameters.

Usage

set_style_options(...)
reset_style_options()
get_style_options()
close_file()
set_variable_labels(...)
get_variable_labels()
set_stat_labels(...)
get_stat_labels()
reset_qol_options()

Value

set_style_options(): Returns modified global styling options.

reset_style_options(): Returns default global styling options.

get_style_options(): List of global styling options.

close_file(): List of global styling options with file = NULL.

set_variable_labels(): List of variable labels.

get_variable_labels(): List of variable labels.

set_stat_labels(): List of statistic labels.

get_stat_labels(): List of statistic labels.

reset_qol_options(): Returns default global options.

Arguments

...

Put in any styling option from excel_output_style() or number_format_style() with the new value.

See Also

Functions that use global styling optionss: any_table(), frequencies(), crosstabs().

Functions that also use global variable labels: export_with_style().

Functions that use global variable and statistic labels: any_table(), frequencies(), crosstabs().

Functions that also use global variable labels: export_with_style().

Examples

set_style_options(save_path    = "C:/My Projects/",
                  sum_decimals = 8)

reset_style_options()

get_style_options()

close_file()

set_variable_labels(age_gr = "Group of ages",
                    status = "Current status")

get_variable_labels()

set_stat_labels(pct  = "%",
                freq = "Count")

get_stat_labels()

reset_qol_options()