how to convert csv files split comma and export to columns of excel in c#

Question

1.00/5 (1 vote)

See more:

hi
i am trying to convert a .csv file to .xls file.

and i am able to do it . but the problem is when it changes to .xls file the comma seperated values are displaying in a single cell like

abc,50,60,usa

mno,68,93,canada

can any body please tell how to split it by comma and i want the data in a different cells

Posted 29-Jul-15 18:56pm

ATHUL AC

Add a Solution

Comments

[no name] 30-Jul-15 1:26am

Try adding double quotes around your various fields.

Maciej Los 30-Jul-15 1:39am

OK, show us the method you use to "convert" csv into xls. Use "Imrpove question" widget. At this moment the question is incomplete.

1 solution

Add a Solution

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)

Patrice T · Answer 1 · 2015-07-29T19:25:00

Solution 1

Have you try to open Excel and then, from Excel, open the CSV ?

If Excel is opened by the csv, no conversion is done.
If in Excel, you open a csv file, Excel will ask how to convert the csv, and you don't have to prepare the csv.

Posted 29-Jul-15 19:25pm

Patrice T