import os as PI_OS
import pandas
import polars
import pyarrow
import openpyxl

# Export
def FC_EXPORT_EXCEL_POLARS(ZVFCI_DF_INPUT, ZVFCI_ST_RESULTS_FOLDER, ZVFCI_ST_RESULTS_FILE):

    PI_OS.makedirs(ZVFCI_ST_RESULTS_FOLDER, exist_ok=True)

    ZV_ST_FILE_PATH = PI_OS.path.join(ZVFCI_ST_RESULTS_FOLDER, ZVFCI_ST_RESULTS_FILE)

    ZV_DF_PANDAS = ZVFCI_DF_INPUT.to_pandas()
    
    ZV_DF_PANDAS.to_excel(
        ZV_ST_FILE_PATH,
        index=False,
        engine='openpyxl'
    )

    print(f"Excel file successfully exported to:\n{ZV_ST_FILE_PATH}")

def FC_EXPORT_EXCEL_PANDAS(ZVFCI_DF_INPUT, ZVFCI_ST_RESULTS_FOLDER, ZVFCI_ST_RESULTS_FILE):

    PI_OS.makedirs(ZVFCI_ST_RESULTS_FOLDER, exist_ok=True)

    ZV_ST_FILE_PATH = PI_OS.path.join(ZVFCI_ST_RESULTS_FOLDER, ZVFCI_ST_RESULTS_FILE)
  
    ZVFCI_DF_INPUT.to_excel(
        ZV_ST_FILE_PATH,
        index=False,
        engine='openpyxl'
    )

    print(f"Excel file successfully exported to:\n{ZV_ST_FILE_PATH}")