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.5-any)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 11 days agofrom:4b8abf35c2. Checks:5 OK, 3 NOTE. Indexed: yes.
| Target | Result | Latest binary |
|---|---|---|
| Doc / Vignettes | OK | Feb 27 2025 |
| R-4.5-win | NOTE | Feb 27 2025 |
| R-4.5-mac | NOTE | Feb 27 2025 |
| R-4.5-linux | NOTE | Feb 27 2025 |
| R-4.4-win | OK | Feb 27 2025 |
| R-4.4-mac | OK | Feb 27 2025 |
| R-4.3-win | OK | Feb 27 2025 |
| R-4.3-mac | OK | Feb 27 2025 |
Exports:add_cell_bordersadd_changed_formatscell_range_translatecells_stylizediff_to_tableexcel_diffexcel_diff_tablepresent_rows_changedsheet_comp
Dependencies:askpassbase64encbslibcachemcellrangerclicpp11crayondata.tabledigestdplyrevaluatefansifastmapflextablefontawesomefontBitstreamVerafontLiberationfontquiverfsgdtoolsgenericsgluehighrhmshtmltoolsjquerylibjsonliteknitrlifecyclemagrittrmemoisemimeofficeropensslopenxlsxpillarpkgconfigprettyunitsprogresspurrrR6raggrappdirsRcppreadxlrematchrlangrmarkdownsassstringistringrsyssystemfontstextshapingtibbletidyrtidyselecttinytexutf8uuidvctrswithrxfunxml2yamlzip
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 |
| 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 |
| Summarize the rows changed between two dataframes | present_rows_changed |
| Compare two dataframes of spreadsheets | sheet_comp |
