Man pages for ianmoran11/locatr
Easier Tidying of Data from Spreadsheets
| add_h_border_groups | Create horizontal border group variable |
| add_variable_if_missing | Add a variable to a tidyxl data frame if that variable is... |
| add_v_border_groups | Create vertical border group variable |
| append_fmt | Add a format variable |
| append_fmt_single | Add a format variable |
| append_name_to_quosure | Give quosure a name |
| arrange_fmt | Select keeping formats |
| create_h_border_groups | Create horizontal border groups |
| create_v_border_groups | Create vertical border groups |
| direction_plot_interactive | Matches directions to unicode arrows for an interative chart |
| direction_plot_noninteractive | Matches directions to unicode arrows for an interative chart |
| fill_blanks_in_col_headers | Unmerge and fill in blanks for col headers. |
| fill_blanks_in_headers | Unmerge and fill in blanks for headers |
| fill_blanks_in_row_headers | Unmerge and fill in blanks for row headers. |
| filter_fmt | Filter keeping formats |
| fmt_alignment_horizontal | Add formatting information from the fmt_alignment_horizontal... |
| fmt_alignment_indent | Add formatting information from the fmt_alignment_indent... |
| fmt_alignment_justifyLastLine | Add formatting information from the... |
| fmt_alignment_readingOrder | Add formatting information from the... |
| fmt_alignment_shrinkToFit | Add formatting information from the fmt_alignment_shrinkToFit... |
| fmt_alignment_textRotation | Add formatting information from the... |
| fmt_alignment_vertical | Add formatting information from the fmt_alignment_vertical... |
| fmt_alignment_wrapText | Add formatting information from the fmt_alignment_wrapText... |
| fmt_border_bottom_color_indexed | Add formatting information from the... |
| fmt_border_bottom_color_rgb | Add formatting information from the... |
| fmt_border_bottom_color_theme | Add formatting information from the... |
| fmt_border_bottom_color_tint | Add formatting information from the... |
| fmt_border_bottom_style | Add formatting information from the fmt_border_bottom_style... |
| fmt_border_diagonal_color_indexed | Add formatting information from the... |
| fmt_border_diagonal_color_rgb | Add formatting information from the... |
| fmt_border_diagonal_color_theme | Add formatting information from the... |
| fmt_border_diagonal_color_tint | Add formatting information from the... |
| fmt_border_diagonalDown | Add formatting information from the fmt_border_diagonalDown... |
| fmt_border_diagonal_style | Add formatting information from the fmt_border_diagonal_style... |
| fmt_border_diagonalUp | Add formatting information from the fmt_border_diagonalUp... |
| fmt_border_end_color_indexed | Add formatting information from the... |
| fmt_border_end_color_rgb | Add formatting information from the fmt_border_end_color_rgb... |
| fmt_border_end_color_theme | Add formatting information from the... |
| fmt_border_end_color_tint | Add formatting information from the fmt_border_end_color_tint... |
| fmt_border_end_style | Add formatting information from the fmt_border_end_style... |
| fmt_border_horizontal_color_indexed | Add formatting information from the... |
| fmt_border_horizontal_color_rgb | Add formatting information from the... |
| fmt_border_horizontal_color_theme | Add formatting information from the... |
| fmt_border_horizontal_color_tint | Add formatting information from the... |
| fmt_border_horizontal_style | Add formatting information from the... |
| fmt_border_left_color_indexed | Add formatting information from the... |
| fmt_border_left_color_rgb | Add formatting information from the fmt_border_left_color_rgb... |
| fmt_border_left_color_theme | Add formatting information from the... |
| fmt_border_left_color_tint | Add formatting information from the... |
| fmt_border_left_style | Add formatting information from the fmt_border_left_style... |
| fmt_border_outline | Add formatting information from the fmt_border_outline format... |
| fmt_border_right_color_indexed | Add formatting information from the... |
| fmt_border_right_color_rgb | Add formatting information from the... |
| fmt_border_right_color_theme | Add formatting information from the... |
| fmt_border_right_color_tint | Add formatting information from the... |
| fmt_border_right_style | Add formatting information from the fmt_border_right_style... |
| fmt_border_start_color_indexed | Add formatting information from the... |
| fmt_border_start_color_rgb | Add formatting information from the... |
| fmt_border_start_color_theme | Add formatting information from the... |
| fmt_border_start_color_tint | Add formatting information from the... |
| fmt_border_start_style | Add formatting information from the fmt_border_start_style... |
| fmt_border_top_color_indexed | Add formatting information from the... |
| fmt_border_top_color_rgb | Add formatting information from the fmt_border_top_color_rgb... |
| fmt_border_top_color_theme | Add formatting information from the... |
| fmt_border_top_color_tint | Add formatting information from the fmt_border_top_color_tint... |
| fmt_border_top_style | Add formatting information from the fmt_border_top_style... |
| fmt_border_vertical_color_indexed | Add formatting information from the... |
| fmt_border_vertical_color_rgb | Add formatting information from the... |
| fmt_border_vertical_color_theme | Add formatting information from the... |
| fmt_border_vertical_color_tint | Add formatting information from the... |
| fmt_border_vertical_style | Add formatting information from the fmt_border_vertical_style... |
| fmt_fill_gradientFill_bottom | Add formatting information from the... |
| fmt_fill_gradientFill_degree | Add formatting information from the... |
| fmt_fill_gradientFill_left | Add formatting information from the... |
| fmt_fill_gradientFill_right | Add formatting information from the... |
| fmt_fill_gradientFill_stop1_color_indexed | Add formatting information from the... |
| fmt_fill_gradientFill_stop1_color_rgb | Add formatting information from the... |
| fmt_fill_gradientFill_stop1_color_theme | Add formatting information from the... |
| fmt_fill_gradientFill_stop1_color_tint | Add formatting information from the... |
| fmt_fill_gradientFill_stop1_position | Add formatting information from the... |
| fmt_fill_gradientFill_stop2_color_indexed | Add formatting information from the... |
| fmt_fill_gradientFill_stop2_color_rgb | Add formatting information from the... |
| fmt_fill_gradientFill_stop2_color_theme | Add formatting information from the... |
| fmt_fill_gradientFill_stop2_color_tint | Add formatting information from the... |
| fmt_fill_gradientFill_stop2_position | Add formatting information from the... |
| fmt_fill_gradientFill_top | Add formatting information from the fmt_fill_gradientFill_top... |
| fmt_fill_gradientFill_type | Add formatting information from the... |
| fmt_fill_patternFill_bgColor_indexed | Add formatting information from the... |
| fmt_fill_patternFill_bgColor_rgb | Add formatting information from the... |
| fmt_fill_patternFill_bgColor_theme | Add formatting information from the... |
| fmt_fill_patternFill_bgColor_tint | Add formatting information from the... |
| fmt_fill_patternFill_fgColor_indexed | Add formatting information from the... |
| fmt_fill_patternFill_fgColor_rgb | Add formatting information from the... |
| fmt_fill_patternFill_fgColor_theme | Add formatting information from the... |
| fmt_fill_patternFill_fgColor_tint | Add formatting information from the... |
| fmt_fill_patternFill_patternType | Add formatting information from the... |
| fmt_font_bold | Add formatting information from the fmt_font_bold format... |
| fmt_font_color_indexed | Add formatting information from the fmt_font_color_indexed... |
| fmt_font_color_rgb | Add formatting information from the fmt_font_color_rgb format... |
| fmt_font_color_theme | Add formatting information from the fmt_font_color_theme... |
| fmt_font_color_tint | Add formatting information from the fmt_font_color_tint... |
| fmt_font_family | Add formatting information from the fmt_font_family format... |
| fmt_font_italic | Add formatting information from the fmt_font_italic format... |
| fmt_font_name | Add formatting information from the fmt_font_name format... |
| fmt_font_scheme | Add formatting information from the fmt_font_scheme format... |
| fmt_font_size | Add formatting information from the fmt_font_size format... |
| fmt_font_strike | Add formatting information from the fmt_font_strike format... |
| fmt_font_underline | Add formatting information from the fmt_font_underline format... |
| fmt_font_vertAlign | Add formatting information from the fmt_font_vertAlign format... |
| fmt_functions_test | Data frame used for testing fmt_* functions |
| fmt_numFmt | Add formatting information from the fmt_numFmt format object... |
| fmt_protection_hidden | Add formatting information from the fmt_protection_hidden... |
| fmt_protection_locked | Add formatting information from the fmt_protection_locked... |
| get_corner_cell_refs | Get the corner references of a tidyxl data frame. |
| get_header_groups | Get column groups |
| get_header_index | The the current names of header groups. |
| get_tabledata | get_tabledata |
| get_value_references | Get table references |
| groupings | Groupings |
| hook | Supply an expression to identify which header groups are... |
| hook_if | Supply an expression to identify which header groups are... |
| locate | Add direction annations to tidyxl data frame |
| locate_data | Locates data cells |
| locate_data_test | Data frame used for testing locate_data() |
| locate_groups | Locate multiple header groups |
| locate_groups_if | Locate multiple header groups |
| locate_groups_test | Data frame used for testing locate_groups() |
| locate_if | Conditionally adds direction annotations to tidyxl data frame |
| locate_test | Data frame used for testing locate |
| locatr_example | Get path to example data locatr comes bundled with some... |
| migrate | Reshape a tidyxl data frame such that each header group has... |
| migrate_test | Data frame used for testing migrate() |
| mutate_fmt | Select keeping formats |
| name_language_expressions | Get name from a language object |
| name_string_expressions | Get name from a vector of spreadsheet range strings |
| name_symbol_expressions | Get name from a vector of symbols |
| paste3 | paste3 |
| plot_cells | Plots tidyxl data frame in a grid layout |
| reduce_mutated | Add a set of variables based on a list of formulae |
| reexports | Objects exported from other packages |
| select_fmt | Select keeping formats |
| string_expressions_to_quosures | Convert range to a filtering quosure |
| string_range_to_filter_vars | Create a filtering variable based on a excel string range. |
| string_to_range | Convert spreadsheet range to a vector of row-col strings. |
| symbol_expressions_to_quosures | Convert symbol to a filtering quosure |
| unmerge_cells | Fill in blanks |
| xlsx_cells_fmt | Produce dataframe from excel file, storing formats as an... |
