The data editor can only input digital data,when cell is null


i have a excel file . the column named ‘beizhu’ is null ,the other columns is not null.

when i load the excel to dataframe ,
i try to modify the ‘beizhu’ clolum,i find :only input the digital data. for example,1 .
howerver,if i input the other type data,i cannot input ?

Steps to reproduce

Code snippet:


If applicable, please provide the steps we should take to reproduce the error or specified behavior.

Expected behavior:

Explain what you expect to happen when you run the code above.

Actual behavior:

Explain the undesired behavior or error you see when you run the code above.
If you’re seeing an error message, share the full contents of the error message here.

Debug info

  • Streamlit version: (get it with $ streamlit version)
  • Python version: (get it with $ python --version)
  • Using Conda? PipEnv? PyEnv? Pex?
  • OS version:
  • Browser version:

Requirements file

Using Conda? PipEnv? PyEnv? Pex? Share the contents of your requirements file here.
Not sure what a requirements file is? Check out this doc and add a requirements file to your app.


  • Link to your GitHub repo:
  • Link to your deployed app:

Additional information

If needed, add any other context about the problem here.

Hi @hillstone

To help further understand the issue that you are facing, could you share 2 screenshots of the app with the columns that you can and cannot input data into it.


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