export_hierarchy_to_excel

Internal function to export hierarchical pivot tables to Excel with formatted headers.

internal

Provides tools for processing and analyzing .har and .sl4 files, making it easier
for 'GEMPACK' users and 'GTAP' researchers to handle large economic datasets.
It simplifies the management of multiple experiment results, enabling faster
and more efficient comparisons without complexity. Users can extract, restructure,
and merge data seamlessly, ensuring compatibility across different tools.
The processed data can be exported and used in 'R', 'Stata', 'Python', 'Julia', or
any software that supports Text, CSV, or 'Excel' formats.

Pattawee Puangchit

HARplus

Enhanced R Package for 'GEMPACK' .har and .sl4 Files

export_hierarchy_to_excel function

<dl><dt>pivot_df</dt>
<dd>A hierarchical pivot object created by pivot_data_hierarchy().</dd>
<dt>file_path</dt>
<dd>Character. The file path for Excel export.</dd>
<dt>xlsx_filename</dt>
<dd>Character. The name for the Excel file when using multi_sheet_xlsx. If NULL, uses the name of the dataset. Default is <code>NULL</code>.</dd></dl>

Arguments

Export Hierarchical Pivot Table to Excel (Internal) — export_hierarchy_to_excel

<dl>

<dt>pivot_df</dt>
<dd>A hierarchical pivot object created by pivot_data_hierarchy().</dd>


<dt>file_path</dt>
<dd>Character. The file path for Excel export.</dd>


<dt>xlsx_filename</dt>
<dd>Character. The name for the Excel file when using multi_sheet_xlsx. If NULL, uses the name of the dataset. Default is <code>NULL</code>.</dd>

</dl>

export_hierarchy_to_excel: Export Hierarchical Pivot Table to Excel (Internal)

Description

Usage

Value

Arguments