how to open an excel file in windows form application

Question

Hello sir,

          my  code generated  output excel file and i need to open that file with button click  so how do i open that file.

Regards,

kavi

Answer 1

If it is a native application, then consider ShellExecute, specifying the “open” verb and the full path of Excel file.

Answer 2

ShellExecute() & ShellExecuteEx() and CreateProcess() is your friend.

Thanks

---

Rupesh Shukla

Answer 3

hello sir,

        is their any tutorial available for reference i am very beginner for windows application programming,

Regards,

kavi

Answer 4

Hi kavi,

From your description, It seem you have a windows form application in C++\CLI, right? If so, please check this article: http://www.codeproject.com/Articles/28083/Use-Visual-Studio-C-CLI-to-Automate-Excel 

Add refenence of Microsoft::Office::Interop::Excel

You could find these code in the article:

#define Excel   Microsoft::Office::Interop::Excel
...

      Excel::Application^ exApp = gcnew Excel::ApplicationClass();
      //2. Add a workbook (comes with three Worksheets)
      Workbook^   exWb  = exApp->Workbooks->Add(Type::Missing);
            .
            .
            .
      // Show the Workbook
      exApp->Visible = true;

Best regards,

Shu Hu

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 5

hello sir,

        is their any tutorial available for reference i am very beginner for windows application programming,

Regards,

kavi

Hello , I am not sure about your target language . What type of application you have Win32 ,MFC or C# .C++/CLI etc. Second thing you can look inside the MSDN for these function . They contain example as well.

Thanks

---

Rupesh Shukla

Answer 6

There are many ways to do this.  The above suggestions required the Excel installed on the target machine.  Or you could purchase a third party library, which will not require Excel installed on the machine.

Steve

Answer 7

hi,

    my application is in  C++/CLI. with above code i am able to open excel application. but i need to open excel file  in my form with button click as output window.

like this article :

http://www.codeproject.com/Articles/15760/How-to-Integrate-Excel-in-a-Windows-Form-Applicati

Regards,

kavi

Answer 8

Thanks For your sharing with us such a good