1,105,333 Community Members

a control to display an excel document

Member Avatar
marijana
Light Poster
40 posts since Jun 2004
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
1
 

please, does anybody know is there a .NET control in which an excel document can be displayed on a windows form ?? Or is there any other way to display it on a form??
tnx :)

Member Avatar
Comatose
Taboo Programmer
2,536 posts since Dec 2004
Reputation Points: 290 [?]
Q&As Helped to Solve: 227 [?]
Skill Endorsements: 34 [?]
Team Colleague
 
0
 

Are you wanting to just read the data from the excel spreadsheet, and put that data on the form? Or are you wanting to Embed an excel spreadsheet into the form?

Member Avatar
marijana
Light Poster
40 posts since Jun 2004
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

i actually want to EMBED excel spreadsheat into the..

Member Avatar
bcheath_1
Newbie Poster
20 posts since Jan 2005
Reputation Points: 0 [?]
Q&As Helped to Solve: 1 [?]
Skill Endorsements: 0 [?]
 
0
 

Hi,


In the Visual Studio.NET Evironment, right-click on a toolbox tab and select add/remove items. There should be an Excel Spreadsheet 9.0, 10.0, or 11.0 control depending on your version of Office. I believe it is located in the .NET Frameworks tab. If not, it would be under the COM Components tab. Select the control and click OK. The control will then be added to your toolbox.


Hope this helps!

Member Avatar
marijana
Light Poster
40 posts since Jun 2004
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

TNX !!!!
i did it :)

Member Avatar
Fred Coomer
Newbie Poster
1 post since Apr 2005
Reputation Points: 0 [?]
Q&As Helped to Solve: 1 [?]
Skill Endorsements: 0 [?]
 
0
 

I cannot find the object. Is it the MicroSoft Spreadsheet 10.0? If so, I have it loaded, but I cannot add an existing workbook to it. How can this be done, or better, how can I get the Excel object?
Thanks
FC

Member Avatar
Comatose
Taboo Programmer
2,536 posts since Dec 2004
Reputation Points: 290 [?]
Q&As Helped to Solve: 227 [?]
Skill Endorsements: 34 [?]
Team Colleague
 
0
 
dim objExcel
set objExcel = createobject("Excel.Application")
objExcel.Workbooks.open "c:\somepath\somefile.xls"
objExcel.Show
Member Avatar
atulloveindia
Newbie Poster
1 post since Jul 2005
Reputation Points: 0 [?]
Q&As Helped to Solve: 1 [?]
Skill Endorsements: 0 [?]
 
0
 
dim objExcel
set objExcel = createobject("Excel.Application")
objExcel.Workbooks.open "c:\somepath\somefile.xls"
objExcel.Show

Please tell me how to interact with the Excel Sheet embedded in the Page.
I want to get the values of selected cells.

Member Avatar
KrisB
Newbie Poster
3 posts since Aug 2005
Reputation Points: 0 [?]
Q&As Helped to Solve: 1 [?]
Skill Endorsements: 0 [?]
 
0
 

Please tell me how to interact with the Excel Sheet embedded in the Page.
I want to get the values of selected cells.

I, too, am trying to figure out how to interact with an embedded Excel Sheet. I have searched the web, but have not found any information.

If someone could put me / us in the right direction, it would be greatly appreciated!

Thanks,
Kris

Question Answered as of 8 Years Ago by Comatose, Fred Coomer, atulloveindia and 2 others
Member Avatar
avv2
Newbie Poster
1 post since Sep 2005
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Hey,

To embeded excel in WinForm, add Windows WebBrower control from the components tab. Use the Navigate method to open the excel.

avv2

Member Avatar
jtodd
Junior Poster in Training
80 posts since Mar 2010
Reputation Points: 0 [?]
Q&As Helped to Solve: 2 [?]
Skill Endorsements: 4 [?]
 
0
 

Hey guys. I have tried the above suggestions but no luck. I am trying to view a excel form I created in windows forms. Any advice or help would be greatly appreciated!

You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article