I use RubyXL to generate a template xlsx file for users to input data.
For one column, say 'Student No.', some data start with 0, like 0011.
I hope the user can input this directly without changing the data type of the column to text.
I know that I can change the data type of a cell, but the number of the data is various, so I don't know how many lines an user will input.
Is there any way to change the default type of a column?
I use RubyXL to generate a template xlsx file for users to input data. For one column, say 'Student No.', some data start with 0, like
0011
. I hope the user can input this directly without changing the data type of the column to text.I know that I can change the data type of a cell, but the number of the data is various, so I don't know how many lines an user will input.
Is there any way to change the default type of a column?
Thank you.