Excel saveas Text File

Question

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 8-Jul-14 1:19am

TheWebDeveloper

Add a Solution

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.

TheWebDeveloper 9-Jul-14 3:58am

Any solution?

TheWebDeveloper 9-Jul-14 2:22am

I just select the excel and click a button. what it do is it save the file as txt file and read that file and match records in my database and make insert to database but it is not matching my string that contain the ç and when I open my txt file i find it c not ç

TheWebDeveloper 8-Jul-14 7:33am

When I open the file its displaying it as c and and i want to read that and match it to values in my database that contain ç and it is not matching ç to c. Did you see the problem here?

CHill60 8-Jul-14 9:07am

If you open a cmd window and use type FileName (substitute the actual fully pathed filename) do you see ç ?

TheWebDeveloper 9-Jul-14 2:20am

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.

TheWebDeveloper 9-Jul-14 2:22am

I just select the excel and click a button. what it do is it save the file as txt file and read that file and match records in my database and make insert to database but it is not matching my string that contain the ç and when I open my txt file i find it c not ç

Maciej Los 8-Jul-14 17:09pm

Do you mean: special character inside the file content or inside file name?

TheWebDeveloper 9-Jul-14 2:20am

the file content

Maciej Los 9-Jul-14 2:40am

Provide a method you save data into Excel sheet.

TheWebDeveloper 9-Jul-14 3:49am

Manual

Maciej Los 9-Jul-14 3:58am

Are you loosing text encoding just after SaveAs(Text format) command has been called?

TheWebDeveloper 9-Jul-14 4:05am

I have text file that contain ç and I want to save it as .txt file I use this command: xlSheet.SaveAs(FileName, Excel.XlFileFormat.xlUnicodeText)xlTextWindows but it displayed it as � and when I used this command xlSheet.SaveAs(FileName, Excel.XlFileFormat.xlUnicodeText) it displayed it as c.

What should i do so it display it as my excel as ç ???

TheWebDeveloper 9-Jul-14 4:07am

Sure after i use this command xlSheet.SaveAs(FileName, Excel.XlFileFormat.xlUnicodeText) THE TEXT FILE IS GENERATED and when I open it i find the ç as c

Maciej Los 9-Jul-14 4:02am

I tested it on my machine. All works fine with SaveAs (Unicode Text)!

TheWebDeveloper 9-Jul-14 4:08am

You saved and excel containing ç and it displayed it as ç in the text file???

TheWebDeveloper 9-Jul-14 5:14am

I replaced xlTextWindows with xlUnicodeText and it works :d

CHill60 9-Jul-14 2:54am

What System.Text.Encoding value are you using on your StreamReader?

TheWebDeveloper 9-Jul-14 3:48am

none

CHill60 9-Jul-14 5:56am

Try using StreamReader(filename, System.Text.Encoding.ANSI).
If that doesn't work try System.Text.Encoding.UTF8

TheWebDeveloper 9-Jul-14 6:10am

I replaced xlTextWindows with xlUnicodeText and it works :d

CHill60 9-Jul-14 7:11am

In your post you said you had already tried that!

TheWebDeveloper 9-Jul-14 7:37am

Yes I tried it yesterday it didn't work I tried it today and it works

Don't you just love .Net :d

TheWebDeveloper 9-Jul-14 7:38am

can you check my other question about formatting an excel file

http://www.codeproject.com/Questions/794835/Excel-Format-Numbers?arn=0

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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