Click here to Skip to main content
16,018,202 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have an Excel file that contain special characters like ç and in my code I'm saveing the file as text file
VB
xlSheet.SaveAs(FileName, Excel.XlFileFormat.xlUnicodeText)

I tried xlUnicodeText & xlTextWindows

But the text file display it as c and not ç

How to display the ç???
Posted
Comments
CHill60 8-Jul-14 7:30am    
How are you viewing the text file? Are you sure it's not the viewer doing the translation back to 'c'
TheWebDeveloper 8-Jul-14 7:34am    
How do i view the file??? I double click on it and it opens
George Jonsson 8-Jul-14 8:52am    
Is notepad your default text editor?
TheWebDeveloper 9-Jul-14 2:19am    
I don't care just to be ab .txt file since I'm using stream reader to read the data and insert them in my database but I need to save the ç as it is in my excel to match it with my database records.
George Jonsson 9-Jul-14 2:56am    
No need to be touchy.
You refer to a text file and we want to know how you view your that text file.
Some editors, like Notepad, doesn't handle special characters very well by default.
So if you explain exactly what you are doing, you might get the help you need.
Being rude will not get you there.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900