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.
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.