Function reference
All functions and classes exported by tidychain.
Functions
| Function | Description |
|---|---|
build_timeline() |
Build Formula Creation Timeline |
check_sheet_protection() |
Check Sheet Protection Status |
detect_anomalies() |
Detect Anomalies in Calculation Chain Order |
expand_range() |
Expand Cell Ranges to Individual Cells |
extract_formulas() |
Extract and Parse Formulas from Excel |
get_all_cells() |
Get All Cells in Workbook |
is_encrypted_xlsx() |
Check if an xlsx file is encrypted |
parse_formula_refs() |
Parse Cell References from a Formula |
parse_xlsx() |
Read Excel Workbook |
plot_anomalies() |
Plot Anomalies Highlighted on Sheet Grid |
plot_calc_order() |
Plot Calculation Chain Order vs Row Number |
plot_sheet_heatmap() |
Plot Sheet Heatmap of Calculation Order |
print_original_comparison() |
Print Original Layout Comparison |
print_timeline_summary() |
Print Timeline Summary |
read_calc_chain() |
Read and Parse Excel calcChain.xml (Internal) |
read_xlsx_structure() |
Read Excel Sheet Structure |
reconstruct_original() |
Reconstruct Original Layout |
remove_sheet_protection() |
Remove Sheet Protection from Excel File |
summarize_anomalies() |
Summarize Detected Anomalies |
tidychain-package() |
tidychain: Excel Forensics and Model Decomposition via ‘calcChain’ Analysis |
translate_formula() |
Translate Excel Formula to R |
visualize() |
Visualization Functions for tidychain |