View Excel file using Activex Control

c# visual-studio-2010 excel activex activexobject
yohan.jayarathna picture yohan.jayarathna · Apr 1, 2011 · Viewed 8.3k times · Source

I want to view excel file in my windows application which I am trying to build using visual studio 2010.

How can I do this ?

Is there any excel activeX control for this.

Suggestion are warmly welcome....

Please Help

Answer

alisabzevari picture alisabzevari · Jun 26, 2011

Actually I found two techniques to do this:

  1. Use a Web Browser control: And it is better to use AxWebBrowser because when you use 2007 and 2010 version of excel the ribbon can not be shown and using this control instead of WebBrowser is better to help solve this problem.
  2. Use SetParent Win32 API: I think this is the better solution because it is more controllable. Fortunately the complete control implemented by this technique is published in CodePlex and it is here: ExcelViewer

Related questions

How do I save an Excel file without getting a format warning when opening, using C# and Excel 2010

I'm using Excel 2010. I'm trying so save my excel file, with this code. It does save a .xls file, but when I open the file I get this message: The file you are trying to open, 'tre.xls', is in …

Read More
Simple Example of VSTO Excel using a worksheet as a datasource

I think I'm running into a case of "the easiest answers are the hardest ones to find" and I haven't come across any searches that give this to me in a straightforward way. This is for Excel 2010 and VS 2010 within …

Read More
Strange error on Excel Workbook input

For the current code: String currentPath = Directory.GetCurrentDirectory(); OpenFileDialog op = new OpenFileDialog(); op.InitialDirectory = currentPath; if (op.ShowDialog() == DialogResult.OK) currentPath = op.FileName; else { toolStripStatusLabel1.Text = "Failed to Load Workbook"; toolStripStatusLabel1.Visible = true; } Workbook wb = new Workbook(excel.Workbooks.Open(…

Read More