Worksheet Names Cannot be more than 31 Characters c#

 
         Hi, Today I am Facing This Issue In My Project. When We Write Excel Sheet C# Via. In Excel, SheetName Allows Only 31 Characters. Otherwise, You Can Write More then 31 Characters You Will Faced This Issue.

         I Am using Closed XML  for Write Excel Sheet. To Rectify this issue to Write Following Code. You can Write The SheetName.


    using (XLWorkbook wb = new XLWorkbook())
                {
                    wb.Worksheets.Add(dt,"Sheetname");




Comments

Popular posts from this blog

Unable to perform operation on the item is locked in workspace

Insecure cookie setting: missing Secure flag

Display Canvasjs Line Chart using Data from Database