You can do it using ExcelPackagethat provides server-side generation of Excel 2007 spreadsheets. You can download it from codeplex. Here is sample code to generate XLSX file using ExcelPackage. 1: FileInfo XLSXFile = new FileInfo(XLSXFileName); 2: using ...
I need to create an excel whose one of the columns needs to restricted so that the user is able to enter only a specified amount of characters in it.
i.e. a column should take say 500 characters of word and should not allow any further characters to be written in that column.
I am using ExcelPackage.
Please reply on the same post if u can contribute to it.