How to Copy Cells from Excel into SelectizeInput (R Shiny)

I want to be able to copy rows of text from Excel and paste it into the text field in our app like this:

Highlight all cells and copy into the Sample labels text field:

What we want (each row from Excel is its own entry in the text field)

What the app currently does when we paste the rows from Excel (each row from Excel combines into one entry):

Is there a way to copy cells into a SelectizeInput-like text field and somehow separate each cell whwen copied from Excel? Thank you.

You can use readxl package to read a specific range of cells and then update the values in the selectInput gadget with shiny::updateSelectInput() function.

If you need more specific help, please provide a proper REPRoducible EXample (reprex) illustrating your issue.

Have you tried to use textInput instead?

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.