We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Maxlength Character in Excel cells

Hi,

I have one scenario.

I need to do while downloading a empty template.

I have done code by data validation.

Each column will have different character length.

Lets take i have to do validation for 3 columns (Column 8 - length 10, Column 9 - length 15, Column 10 - length 30)

When i apply Validation.Formula, it takes length of 30 to all the three columns.

Please advise me on above point to do data validation.

@Harish_Gopalan,

Thanks for your query.

I think you should implement text length validation type with different characters’ length on each range/area (Column 8 - length 10, Column 9 - length 15, Column 10 - length 30). See the document topic/sub topic with example for your reference:
https://docs.aspose.com/display/cellsnet/Data+Filtering+and+Validation#DataFilteringandValidation-TextLengthDataValidation

Hope, this helps a bit.