Man pages for moj-analytical-services/xltabr
Automatically write beautifully formatted cross tabulations/contingency tables to Excel from R

add_bodyAdd a table body (a df) to the tab.
add_footerAdd footers to the tab. Footer text is provided as a...
add_titleAdd titles to the tab. Title text is provided as a character...
add_top_headersAdd top headers to the tab. The top headers are provided as...
auto_crosstab_to_tabTake a cross tabulation produced by 'reshape2::dcast' and...
auto_crosstab_to_wbTake a cross tabulation produced by 'reshape2::dcast' and...
auto_detect_body_title_levelAutodetect the 'title level' of each row in the cross...
auto_detect_left_headersUses the presence of '(all)' in the leftmost columns of data...
auto_df_to_wbTake a data.frame in r and output an openxlsx wb objet
auto_merge_footer_cellsTake a tab and merge the footer rows
auto_merge_title_cellsTake a tab and merge the title rows
auto_style_indentConsolidate the header columns into one, taking the rightmost...
auto_style_number_formattingUse the data type of the columns to choose an automatic Excel...
body_get_bottom_wb_rowCompute the bottom (lowest) row of the workbook occupied by...
body_get_cell_styles_tableCreate table with columns |row|col|style name| containing the...
body_get_rightmost_wb_colCompute the rightmost column of the workbook which is...
body_get_wb_colsCompute the columns of the workbook which are occupied by the...
body_get_wb_left_header_colsCompute the columns of the workbook which are occupied by the...
body_get_wb_rowsCompute the rows of the workbook which are occupied by the...
body_initialiseInitialise the body element of the tab, creating all the...
body_write_rowsWrite all the body data to the workbook (but do not write...
get_cell_format_pathGet cell formats path
get_num_format_pathGet number formats path
get_style_pathGet style sheet path
initialiseCreate a new xltabr object for cross tabulation
set_cell_format_pathSet cell format path
set_num_format_pathSet number format path
set_style_pathSet style sheet path
set_wb_widthsSet column widths to tab workbook
style_catalogue_add_excel_num_formatManually add an Excel num format to the style catalogue
style_catalogue_add_openxlsx_styleManually add an openxlsx s4 style the style catalogue
title_get_bottom_wb_rowGet the bottom row which the titles occupy in the workbook If...
title_get_cell_styles_tableCreate table with columns |row|col|style name| that contains...
title_get_rightmost_wb_colGet the rightmost column occupied by the titles in the...
title_get_wb_colsGet the columns occupied by the title in the workbook
title_get_wb_rowsGet the rows occupied by the title in the workbook
title_initialiseCreate all the required properties for the title on the tab...
title_write_rowsWrite all the title data to the workbook (but do not write...
top_headers_get_bottom_wb_rowCompute the bottom (lowest) row of the workbook occupied by...
top_headers_get_cell_styles_tableCreate table with columns |row|col|style name| containing the...
top_headers_get_rightmost_wb_colCompute the rightmost column of the workbook which is...
top_headers_get_wb_colsCompute the columns of the workbook which are occupied by the...
top_headers_get_wb_rowsCompute the rows of the workbook which are occupied by the...
top_headers_initialiseCreate all the required properties for the top headers on the...
top_headers_write_rowsWrite all the top header data to the workbook (but do not...
write_data_and_styles_to_wbWrite the styles and data contained in tab object to the...
moj-analytical-services/xltabr documentation built on Oct. 21, 2017, 9:14 p.m.