Custom Excel export is not displaying the spl characters in excel properly
Custom Excel export is not displaying the spl characters in excel properly
ra165
Posts: 2Questions: 1Answers: 0
we are using openxml excel + datatable to export the data to excel and it's working fine locally. when we hosted the same on IIS webserver it's not exporting the special characters properly. Please suggest the fix.
This discussion has been closed.
Answers
This thread may help. If not, we're happy to take a look, but as per the forum rules, please link to a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.
Cheers,
Colin
Thanks for your comment.i'm a newbie to JS and trying to fix the issue existing code and it's 1300+ lines of code. where the dev had mentioned value.replace(/&/g, '&') where it's showing properly in sheet1 and not in sheet2 of excel.