Skip to contents

All functions

add_cell_borders()
[Deprecated] Adds cell borders to openxlsx spreadsheet
add_changed_formats()
Format openxlsx2 worksheet based on changes
cell_range_translate()
Translates from excel cell address to rows and columns
cells_stylize() deprecated
[Deprecated] Apply style to worksheet based on one or more excel-style cell ranges
diff_to_table()
Compares two dataframes and returns diff as flextable
excel_diff()
Minimal spreadsheet comparison function
excel_diff_table()
Diff excel sheets and show table
excel_diff_tibble()
Diff excel sheet and return tibble
formula_diff()
Compare two sheets to see if formula use changed
mat_to_a1()
Provide Excel addresses from matrix of logicals
present_rows_changed()
Summarize the rows changed between two dataframes
sheet_comp()
Compare two dataframes of spreadsheets
sheet_comp_basic()
Stripped down version of sheet_comp
wb_get_col_widths()
[Experimental] Get column widths of openxlsx2 Workbook sheet