The dashboard I prepared with shiny can be seen in the image. I want to store the user inputs in an excel file. How can I store all of these input values in an excel file which will be in the same directory if I press the button? Code can be seen below;
ui.nav("Optimization Dashboard",
ui.panel_title(window_title="Optimization Dashboard",
title=""),
# Sidebar containing input data for the tables
ui.layout_sidebar(
sidebar=
ui.panel_sidebar(
ui.input_date('date1', "Date: ", value="2023-02-27"),
ui.input_switch('tank1', ui.h6("Switch1")),
ui.input_switch('tank2', ui.h6("Switch2")),
ui.input_switch('tank3', ui.h6("Switch3")),
ui.input_switch('tank4', ui.h6("Switch4")),
ui.input_switch('tank5', ui.h6("Switch5")),
ui.input_switch('tank6', ui.h6("Switch6")),
ui.input_numeric('c_volume', "Input7", 70000),
ui.input_numeric('l_volume', "Input8", 2000),
ui.input_numeric('cv2_volume', "Input9", 1000),
ui.input_text_area('log_text', "Update Log", height='150px'),
# ui.output_plot(id = 'prediction_plot'),
width=2
),
main=ui.panel_main(
ui.row(
ui.column(4,
ui.input_action_button('get_table', 'Get Input Data', \
class_="btn btn-primary"),
ui.output_table('df_input'),
),
),
)
),
)