Package: xldiff 0.0.0.9000
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.0.0.9000.tar.gz
xldiff_0.0.0.9000.zip(r-4.5)xldiff_0.0.0.9000.zip(r-4.4)xldiff_0.0.0.9000.zip(r-4.3)
xldiff_0.0.0.9000.tgz(r-4.4-any)xldiff_0.0.0.9000.tgz(r-4.3-any)
xldiff_0.0.0.9000.tar.gz(r-4.5-noble)xldiff_0.0.0.9000.tar.gz(r-4.4-noble)
xldiff_0.0.0.9000.tgz(r-4.4-emscripten)xldiff_0.0.0.9000.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/cbedwards-dfw/xldiff/issues
Last updated 22 days agofrom:ec0e550682. Checks:OK: 7. Indexed: no.
| Target | Result | Date |
|---|---|---|
| Doc / Vignettes | OK | Nov 01 2024 |
| R-4.5-win | OK | Nov 01 2024 |
| R-4.5-linux | OK | Nov 01 2024 |
| R-4.4-win | OK | Nov 01 2024 |
| R-4.4-mac | OK | Nov 01 2024 |
| R-4.3-win | OK | Nov 01 2024 |
| R-4.3-mac | OK | Nov 01 2024 |
Exports:add_cell_bordersadd_changed_formatscell_range_translatecells_stylizeexcel_diffsheet_comp
Dependencies:cellrangerclicpp11crayondplyrfansigenericsgluehmslifecyclemagrittropenxlsxpillarpkgconfigprettyunitsprogresspurrrR6Rcppreadxlrematchrlangstringitibbletidyselectutf8vctrswithrzip
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 |
| Compare two dataframes of spreadsheets | sheet_comp |
