| Title: | Fast Formula Stripping and Exporting Excel Sheets to Separate Files |
|---|---|
| Description: | Provides fast, dependency-minimal tools to strip all cell formulas from standard Excel (.xlsx) files while preserving evaluated calculated values intact. It also supports exporting multi-sheet workbooks into standalone single-sheet files. By design, the package extracts only cell values and their formatting (styles) to ensure maximum speed and safety, discarding complex embedded objects such as images or charts. |
| Authors: | Shunsuke Homma [aut, cre] |
| Maintainer: | Shunsuke Homma <[email protected]> |
| License: | MIT + file LICENSE |
| Version: | 0.1.0 |
| Built: | 2026-07-02 21:39:12 UTC |
| Source: | https://github.com/cran/parcxl |
Deconstructs a multi-sheet .xlsx file, flattens all internal cell formulas into values, and pipes each sheet layout out into clean, standalone, single-sheet Excel files.
export_sheets(input_xlsx, output_dir)export_sheets(input_xlsx, output_dir)
input_xlsx |
Character scalar. Path to the source multi-sheet .xlsx file. |
output_dir |
Character scalar. Path to the destination directory where separated files will be written. |
Invisible NULL.
Extracts an .xlsx archive, drops all formula nodes while keeping the current calculated values intact, and saves the output as a streamlined, value-only workbook.
remove_formula(input_xlsx, output_xlsx)remove_formula(input_xlsx, output_xlsx)
input_xlsx |
Character scalar. Path to the source .xlsx file. |
output_xlsx |
Character scalar. Path where the flattened .xlsx file should be written. |
Invisible NULL.