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

shiny
1

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:

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

6
6795×68 2.47 KB

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

7
7812×99 2.2 KB

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

2

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.

3

Have you tried to use textInput instead?

4

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