Package: xldiff 0.2.0
Collin Edwards
xldiff: Compare excel sheets
`xldiff` provides tools to compare excel sheets, broadly inspired by "diff"-type functions. Provided functions can read sheets of two excel files and produce a third file that highlights cells that have changed. In the case of numeric changes, the direction of change is highlighted. These tools do not account for structural changes in the sheets (e.g., the addition of a column), but are useful in tracking changed values in tables or parameter files. Utility functions developed to streamline formatting output files are also more broadly useful in programmatically formatting excel files using openxlsx.
Authors:
xldiff_0.2.0.tar.gz
xldiff_0.2.0.zip(r-4.7-any)xldiff_0.2.0.zip(r-4.6-any)xldiff_0.2.0.zip(r-4.5-any)
xldiff_0.2.0.tgz(r-4.6-any)xldiff_0.2.0.tgz(r-4.5-any)
xldiff_0.2.0.tar.gz(r-4.7-any)xldiff_0.2.0.tar.gz(r-4.6-any)
xldiff_0.2.0.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
xldiff/json (API)
| # Install 'xldiff' in R: |
| install.packages('xldiff', repos = c('https://framverse.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/framverse/xldiff/issues
Pkgdown/docs site:https://cbedwards-dfw.github.io
Last updated from:cfebb1a9cf. Checks:9 OK. Indexed: yes.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel | OK | 126 | ||
| source / vignettes | OK | 246 | ||
| linux-release | OK | 128 | ||
| macos-release | OK | 106 | ||
| macos-oldrel | OK | 100 | ||
| windows-devel | OK | 80 | ||
| windows-release | OK | 79 | ||
| windows-oldrel | OK | 76 | ||
| wasm-release | OK | 205 |
Exports:add_cell_bordersadd_changed_formatscell_range_translatecells_stylizediff_to_tableexcel_diffexcel_diff_tableexcel_diff_tibbleformula_diffmat_to_a1present_rows_changedsheet_compwb_get_col_widths
Dependencies:askpassbase64encbslibcachemcellrangerclicpp11crayondata.tabledigestdplyrevaluatefastmapflextablefontawesomefontBitstreamVerafontLiberationfontquiverfsgdtoolsgenericsgluehighrhmshtmltoolsjquerylibjsonliteknitrlifecyclemagrittrmemoisemimeofficeropensslopenxlsx2pillarpitonpkgconfigprettyunitsprogresspurrrR6raggrappdirsRcppreadxlrematchrlangrmarkdownsassstringistringrsyssystemfontstextshapingtibbletidyrtidyselecttidyxltinytexutf8uuidvctrswithrxfunxml2yamlzip
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| *[Deprecated]* Adds cell borders to openxlsx spreadsheet | add_cell_borders |
| Format 'openxlsx2' worksheet based on changes | add_changed_formats |
| Translates from excel cell address to rows and columns | cell_range_translate |
| *[Deprecated]* Apply style to worksheet based on one or more excel-style cell ranges | cells_stylize |
| Compares two dataframes and returns diff as flextable | diff_to_table |
| Minimal spreadsheet comparison function | excel_diff |
| Diff excel sheets and show table | excel_diff_table |
| Diff excel sheet and return tibble | excel_diff_tibble |
| Compare two sheets to see if formula use changed | formula_diff |
| Provide Excel addresses from matrix of logicals | mat_to_a1 |
| Summarize the rows changed between two dataframes | present_rows_changed |
| Compare two dataframes of spreadsheets | sheet_comp |
| Stripped down version of sheet_comp | sheet_comp_basic |
| *[Experimental]* Get column widths of openxlsx2 Workbook sheet | wb_get_col_widths |