As you may notice in the attached project, CSV’s sheet name is the file name, which is nice. Although, it’s getting 32 chars and the limit is 31.
Also, you will notice that the file name contains square brackets ("[" and “]”). Although, if I try to set a sheet name using this char, it throws an exception with a list of invalid chars.
My suggestion, regarding the square bracket issue, is to replace it by regular brackets ("(" and “)”). You can try the file in my sample. That’s what Excel does.
AsposeTest13.zip (4.9 MB)