Package: xldiff 0.1.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.1.0.tar.gz
xldiff_0.1.0.zip(r-4.5)xldiff_0.1.0.zip(r-4.4)xldiff_0.1.0.zip(r-4.3)
xldiff_0.1.0.tgz(r-4.4-any)xldiff_0.1.0.tgz(r-4.3-any)
xldiff_0.1.0.tar.gz(r-4.5-noble)xldiff_0.1.0.tar.gz(r-4.4-noble)
xldiff_0.1.0.tgz(r-4.4-emscripten)xldiff_0.1.0.tgz(r-4.3-emscripten)
xldiff.pdf |xldiff.html✨
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
Last updated 10 days agofrom:22880b1f3d. Checks:7 OK. Indexed: yes.
| Target | Result | Latest binary |
|---|---|---|
| Doc / Vignettes | OK | Jan 08 2025 |
| R-4.5-win | OK | Jan 08 2025 |
| R-4.5-linux | OK | Jan 08 2025 |
| R-4.4-win | OK | Jan 08 2025 |
| R-4.4-mac | OK | Jan 08 2025 |
| R-4.3-win | OK | Jan 08 2025 |
| R-4.3-mac | OK | Jan 08 2025 |
Exports:add_cell_bordersadd_changed_formatscell_range_translatecells_stylizeexcel_diffpresent_rows_changedsheet_comp
Dependencies:cellrangerclicpp11crayondplyrfansigenericsgluehmslifecyclemagrittropenxlsxpillarpkgconfigprettyunitsprogresspurrrR6Rcppreadxlrematchrlangstringistringrtibbletidyrtidyselectutf8vctrswithrzip
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Adds cell borders to openxlsx spreadsheet | add_cell_borders |
| Format 'openxlsx' worksheet based on changes | add_changed_formats |
| Translates from excel cell address to rows and columns | cell_range_translate |
| Apply style to worksheet based on one or more excel-style cell ranges | cells_stylize |
| Minimal spreadsheet comparison function | excel_diff |
| Summarize the rows changed between two dataframes | present_rows_changed |
| Compare two dataframes of spreadsheets | sheet_comp |
