excel file gets corrupted, when use special character & in sheet name.

[Naresh Singh]

Hi, 

I'm using @syncfusion/ej2-excel-export version 19.3.44. we are creating excel file. but when we using special character & or >  for excel sheet name. then excel file we gets is corrupted.

any solution for this?

Regards,

Naresh Singh

[Aravinthan Seetharaman]

Hi Naresh, 

 

Thanks for contacting Syncfusion Support. 

 

We have checked your query in your mentioned version(19.3.44). We cannot able to reproduce your reported issue in our end. For your reference we have prepared video demo and sample here. 

 

Demo: https://www.syncfusion.com/downloads/support/directtrac/general/ze/ss_sheet_name-1117623984  

 

Sample: https://codesandbox.io/s/hopeful-ride-cmy29?file=/package.json:569-771  

 

Please check the above details and if you are still facing issue, please share the below details. 

 

• If possible, please reproduce the issue in provided sample or share the issue reproducible sample.
• Please share us the video demonstration of this issue.
• Please share the Spreadsheet related code snippet.

 

Please provide the above requested information, based on that we will check and provide you a better solution quickly. 

 

Regards, 

Aravinthan S 

[Naresh Singh]

Hi Aravinthan S,

Thanks for your response. I have created a stackblitz sample for your reference. Just let you know that issue is reproducible only when excel sheet name has these special character & < ”

https://stackblitz.com/edit/angular-ivy-dxdlut?file=src%2Fapp%2Fhello.component.ts

Regards,
Naresh Singh

[Aravinthan Seetharaman]

Hi Naresh,

We have checked your query. Before proceeding further, we would like to know that, whether you are using Syncfusion Spreadsheet component in your application. This information will help us to provide better solution quickly.

Regards,

Aravinthan S