Replace invalid characters with suitable symbols or chars automatically in an Excel sheet names in .NET

brunojuliao · February 5, 2019, 4:24pm

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)

amjad.sahi · February 5, 2019, 7:05pm

@brunojuliao,

Thanks for the sample project and details.

We will be evaluating your project and get back to you soon.

ahsaniqbalsidiqui · February 6, 2019, 10:11am

@brunojuliao,

I have investigated your scenario a bit. It throws exception unless the file name is upto the letters “…_IDIG-US” which make 31 in number so the exception is thrown if file name contains 32 characters. About replacing invalid characters, we have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-46573 - Replace invalid characters with suitable symbols

amjad.sahi · February 12, 2019, 7:47am

@brunojuliao,

This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-46573”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

amjad.sahi · February 12, 2019, 9:16am

@brunojuliao,

Please try our latest version/fix: Aspose.Cells for .NET v19.1.6 (attached)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells19.1.6 For .Net2_AuthenticodeSigned.Zip (4.7 MB)
Aspose.Cells19.1.6 For .Net4.0.Zip (4.8 MB)

brunojuliao · February 12, 2019, 1:35pm

All the tests I run are looking good. Thanks for the prompt reply and fix.

amjad.sahi · February 12, 2019, 2:04pm

@brunojuliao,

Good to know that your issue is sorted out by the new fix/version. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

aspose.notifier · February 18, 2019, 12:16pm

The issues you have found earlier (filed as CELLSNET-46573) have been fixed in Aspose.Cells for .NET v19.2. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi