Setting max character length for a cell? Is it possible?

[surfdmountain]

I'm using Spire.XLS with .NET.
Is there a way to set the max number of characters for a cell? I only want a cell to allow 50 characters.

I've seen CellDataType.TextLength but I'm not sure how to set the max length.

[Marcia.Zhou]

Hello,

Thanks for your inquiry!

Please refer to the following code to set the max length of the cell. If you have any other questions, just feel free to contact us.

Code: Select all

            //set the length <= 5
            Workbook workbook = new Workbook();
            Worksheet worksheet = workbook.Worksheets[0];
            CellRange cellA1 = worksheet["A1"];
            cellA1.DataValidation.AllowType = CellDataType.TextLength;
            cellA1.DataValidation.CompareOperator = ValidationComparisonOperator.LessOrEqual;
            cellA1.DataValidation.Formula1 = "5";


Sincerely,
Marcia
E-iceblue support team

[surfdmountain]

Thanks! That works!

[Marcia.Zhou]

Hello,

Thanks for your feedback!

Glad to hear that the code is worked.

If you encounter any issues related to our product in the future, just feel free to contact us.

Have a nice day!

Sincerely,
Marcia
E-iceblue support team