how to open the Excel document(.xlsx) in embeded Winforms Control Using C#

Question

5.00/5 (2 votes)

See more:

Hai,

I am trying to display the Excel document in windows forms using the webbrowser Control.

using the code googled in Codeproject How to Integrate Excel in a Windows Form Application using the WebBrowser[^] and i am able to disaply excel(.xls and .xlsx) files in 32 bit Operating System correctly in webbrowser control.

But when i trying to execute the code in 64-bit operating system .xlsx type Excel files didn't open in webbrowser Control instead they were opening as normal excel file but .xls files opening correctly in webbrowser Control.
For that i executed the register Script to change the registry settings using the below link http://support.microsoft.com/kb/927009[^]
but .xlsx files always Open separately as like Office excel file instead of opening it in webbrowser Controls.

Presently i am using Microsoft Office 2010 software as my office tool.

Please provide the solution to open the .xlsx files to be open in webbrowser control.

Thank you.

Posted 18-Jan-13 23:18pm

V G S Naidu A

Add a Solution

Comments

Valery Possoz 19-Jan-13 6:01am

Set you project as x86, not AnyCPu. That will force it to execute as a 32bit process even on 64b platforms.

adriancs 19-Jan-13 6:18am

+1 Vote Up

V G S Naidu A 20-Jan-13 23:27pm

thank you possoz, it's working with your technique. but i need to run the project as any cpu because it has the 64-bit dll's which support 64-bit operating system. if u please give me another suggestion.

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)

Rob Graham · Accepted Answer · 2013-01-19T08:50:00

If you have 32 bit office installed in a 64 bit OS, you must compile your winforms application as "x86" not "AnyCPU". If it is compiled as "AnyCPU" it will start the 64 bit CLR which cannot host 32 bit office interop dlls.

The older xls format was supported by the Jet engine, which has side by side support for both 64 and 32 bit, the newer xlsx format is supported by a newer engine that does have side by side support. This is a major pain in the neck, but the information about 64 bit support was directly from Microsoft support - they nmo longer intend to provide side by side support, as the see the file support as part of office, not part of the OS. Fortunately, few people install 64 bit office, even on a 64 bit OS, so compiling for x86 will work with 32 bit office on either OS. If you have to support both 32 bit office, and 64 bit office, you will need two versions (one AnyCPU or x64 and one x86), and will need to determine which office version you are interacting with at install time.