0

shiny_dashboard

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'),
                                 ),
                   ),
               )
           ),
           )
M--
  • 25,431
  • 8
  • 61
  • 93
murcielago
  • 11
  • 4

0 Answers0