Overview | Importing from Excel | Dealing with multi-tier headers | Identifying rows via "anchor cells" | row_finder() | row_finder_by_color | Putting it all together | Caution | Helper functions | I need to replicate contents from an excel file into an R script | Help, the numeric contents I read in from excel have a weird mix of formatting! | Exporting to Excel / Copying between Excel | Dataframe into Excel | Copying contents safely | Update columns from one file to another
Package: excelsior 0.0.1
Collin Edwards
excelsior: Streamlines Excel File Automation
Useful tools for automation of excel file data entry, especially transferring parts of one sheet into a sheet of another file.
Authors:
excelsior_0.0.1.tar.gz
excelsior_0.0.1.zip(r-4.7)excelsior_0.0.1.zip(r-4.6)excelsior_0.0.1.zip(r-4.5)
excelsior_0.0.1.tgz(r-4.6-any)excelsior_0.0.1.tgz(r-4.5-any)
excelsior_0.0.1.tar.gz(r-4.7-any)excelsior_0.0.1.tar.gz(r-4.6-any)
excelsior_0.0.1.tgz(r-4.6-emscripten)
manual.pdf |manual.html✨
DESCRIPTION |NEWS
card.svg |card.png
excelsior/json (API)
| # Install 'excelsior' in R: |
| install.packages('excelsior', repos = c('https://framverse.r-universe.dev', 'https://cloud.r-project.org')) |
Bug tracker:https://github.com/cbedwards-dfw/excelsior/issues
Pkgdown/docs site:https://cbedwards-dfw.github.io
Last updated from:283cdb863e. Checks:9 OK. Indexed: yes.
| Target | Result | Time | Files | Syslog |
|---|---|---|---|---|
| linux-devel-x86_64 | OK | 144 | ||
| source / vignettes | OK | 265 | ||
| linux-release-x86_64 | OK | 151 | ||
| macos-release-arm64 | OK | 190 | ||
| macos-oldrel-arm64 | OK | 218 | ||
| windows-devel | OK | 102 | ||
| windows-release | OK | 117 | ||
| windows-oldrel | OK | 105 | ||
| wasm-release | OK | 158 |
Exports:as_numeric_smartcell_range_translateclip_to_veccopy_columnscopy_sectionfind_fill_colorimplant_dfread_excel_tiered_headersrow_finderrow_finder_by_color
Dependencies:cellrangerclicpp11crayondplyrgenericsgluehmslatticelifecyclemagrittropenxlsx2pillarpitonpkgconfigprettyunitsprogresspurrrR6Rcppreadxlrematchrlangstringistringrtibbletidyrtidyselecttidyxlutf8vctrswithrxldiffzoo
Readme and manuals
Help Manual
| Help page | Topics |
|---|---|
| Convert character vector to numeric with intelligent handling | as_numeric_smart |
| Translate copied excel row/column into code to make an R vector | clip_to_vec |
| Copy columns from one Excel file to another with change tracking | copy_columns |
| Copy data section between locations in Excel workbook | copy_section |
| Find fill color of specified cell | find_fill_color |
| Directly implant data from dataframe to openxlsx2 workbook | implant_df |
| Read an Excel file with multi-row headers | read_excel_tiered_headers |
| Find row number based on an "anchor cell" | row_finder |
| Find anchor cell based on fill color | row_finder_by_color |
