convert gridview to .xls

Question

0.00/5 (No votes)

See more:

Hi..,

I am converting grid view data to .xls format. I stored this csv file in "D://NAME.xls". But When I open the name.xls a Text Import dialog appears. My system has open office only.How can I avoid this screen??

Posted 13-Jan-15 0:14am

Member 10994712

Updated 13-Jan-15 0:29am

v2

Add a Solution

Comments

Richard MacCutchan 13-Jan-15 6:25am

You cannot store a CSV file with the .xls extension.

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)

CHill60 · Answer 1 · 2015-01-13T00:34:00

Solution 1

You have two choices ...

Either store the file as D:\NAME.CSV (See the comment from Richard macCutchan)

Or

Save the data in XLS format - see this CP article for more information Export datatable to XLS/CSV compatible with MS-Office and Open-Office[^]

Posted 13-Jan-15 0:34am

CHill60

Comments

Member 10994712 13-Jan-15 6:46am

am developing a windows application

CHill60 13-Jan-15 7:02am

Then store it as a CSV - both MS Office and Open Office calc can open one of those

Member 10994712 13-Jan-15 23:33pm

I created file as name.csv. But it is in word format

CHill60 14-Jan-15 5:52am

If it is in word format then that is what your code wrote it out as! Name it .DOCX if it's word format