Convert .csv file to .xls file?

Question

1.00/5 (1 vote)

See more:

I am looking for a c or matlab program which can convert .csv file to .xls file?

What I have tried:

i did with c program by replacing every comma by a tab but it didn't work properly

Posted 8-Sep-16 0:01am

Member 12727233

Updated 9-Sep-16 14:17pm

Add a Solution

Comments

Member 12727231 8-Sep-16 6:02am

I am looking for a c or matlab program which can convert .csv file to .xls file?

What I have tried:

i did with c program by replacing every comma by a tab but it didn't work properly
Permalink Posted 37 secs ago
Member 12727233352
Have a Question or Comment?
Add your solution here

Patrice T 8-Sep-16 6:23am

"it didn't work properly" is bot informative.

[no name] 9-Sep-16 19:48pm

If you think that someone here is going to write this program for you, you have come to the wrong place. We are also not a program/code finding service.

4 solutions

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)

CPallini · Answer 1 · 2016-09-08T01:52:00

Solution 2

As Richard suggested, the straightforward way to obtain such conversion is using Excel itself. Excel can import CSV files and thes save the worksheet in its own format.
One alternative could be Excel Automation, though C programming language is not the best suited for.

Posted 8-Sep-16 1:52am

CPallini

Comments

Member 12727233 9-Sep-16 2:46am

Friend i have to do it for like 3000 files so i can't do it manually , that's why i am lookinf for a program so i can do for all the files by a single program.
so if you can help me out with c program or matlab ..it would be more needful,thanks in advance.

CPallini 9-Sep-16 2:50am

Probably you best bet would be C#. See, for instance:
http://csharp.net-informations.com/excel/csharp-excel-tutorial.htm

S Houghtelin · Answer 2 · 2016-09-08T02:14:00

Solution 3

You listed MatLab, assuming you do know how to use it and have MatLab on your machine, Write Microsoft Excel spreadsheet file - MATLAB xlswrite[^]

Regards.

Posted 8-Sep-16 2:14am

S Houghtelin

Comments

Member 12727233 9-Sep-16 2:48am

yess i done it with matlab program but xls file which i have generated using matlab is not in readable format so i am looking for a better solution ...which i can expect you talented people will provide me ..
thanks in advance

S Houghtelin 9-Sep-16 7:19am

What do you mean by not in readable format? Are you attempting to open an .xls file without using Excel or are you trying to generate tab delimited files? You are not describing your file very well.

programify · Answer 3 · 2016-09-09T13:36:00

I use the libxlsxwriter static library to create C programs that convert CSV to XSLX files directly - with full formatting, multiple tabs, etc.

See: libxlsxwriter[^]

The easiest way to convert CSV to XLS(x) is to load the CSV directly in to Excel and Save As an XLSx file type.

Hope this helps.

:)

Patrice T · Answer 4 · 2016-09-09T14:17:00

Quote:
i did with c program by replacing every comma by a tab but it didn't work properly

This is not a conversion from csv to xls !
This is just another flavor of csv and excel know how to open both csv flavors as already stated in previous answers.
the only interest of using tabs is that it is easier to handle strings that include commas. Note that comma is also used as decimal point in many countries in Europe.

Convert .csv file to .xls file?

4 solutions

Solution 2

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0