how to open excel file

Question

0.00/5 (No votes)

See more:

hi all,
i am working on excel sheet. i had already export data from a datagridview into excel sheet. now i want to view this excel sheet on click of a button. how could i do that.
thanx in advance
neaS

Posted 31-Aug-11 0:56am

neeraj24may

Add a Solution

3 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)

Bert Mitton · Answer 1 · 2011-08-31T01:14:00

Solution 1

Good morning,

The link below shows how to automate Excel...
http://support.microsoft.com/kb/301982[^]

If you're looking to open a saved file, then try the following:

http://msdn.microsoft.com/en-us/library/h6ak8zt5.aspx

Posted 31-Aug-11 1:14am

Bert Mitton

Updated 31-Aug-11 1:15am

v2

Comments

BobJanova 31-Aug-11 11:30am

5 from me, though I added some details in my answer.

BobJanova · Answer 2 · 2011-08-31T05:30:00

Solution 2

Use Process.Start (as linked by Bert). Make sure you set UseShellExecute to true so that you can use Process.Start on the .xls. This will start whatever application you have associated with .xls (probably Excel, but it might not be) and load the sheet into it.

Posted 31-Aug-11 5:30am

BobJanova

Mahmud Mostafa · Answer 3 · 2011-08-31T06:08:00

Hi,
suppose you have an excel sheet contains data in the following format

<br />
ID	ISBN	        Date<br />
1	0273600796	10/1/2011<br />
2	0071162070	10/1/2011<br />
3	0071162070	10/15/2011<br />
4	0070522235	10/15/2011<br />
5	0070527105	11/1/2011<br />
6	0070577277	11/1/2011<br />
7	007024801x	11/15/2011<br />
8	0071164278	12/1/2011<br />
9	0071140654	12/1/2011<br />

saved in excel file named "OutOfPrint.xls"
you can use the following code snip to read this file into datagridview

C#

DbProviderFactory factory =
                DbProviderFactories.GetFactory("System.Data.OleDb");

                using (DbConnection connection = factory.CreateConnection())
                {
                    connection.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;
                Data Source=OutOfPrint.xlsx;Extended Properties=
                ""Excel 8.0;HDR=YES;""";

                    using (DbCommand command = connection.CreateCommand())
                    {
                        command.CommandText = "SELECT ID,ISBN,Date FROM [OutofPrint$]";

                        connection.Open();

                        using (DbDataReader dr = command.ExecuteReader())
                        {
                            while (dr.Read())
                            {
                                gvOutofPrint.Rows.Add(dr["ID"], dr["ISBN"],dr["Date"]);
                            }
                        }
                    }
                }

good luck