Member Avatar

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

  • 8 Contributors
  • forum 10 Replies
  • 1,370 Views
  • 6 Years Discussion Span
  • comment Latest Post by jtodd Latest Post
Re: a control to display an excel document 80 80
Member Avatar

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?

Re: a control to display an excel document 80 80
Member Avatar

i actually want to EMBED excel spreadsheat into the..

Re: a control to display an excel document 80 80
Member Avatar

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!

Re: a control to display an excel document 80 80
Member Avatar

TNX !!!!
i did it :)

Re: a control to display an excel document 80 80
Member Avatar

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

Re: a control to display an excel document 80 80
Member Avatar 
dim objExcel
set objExcel = createobject("Excel.Application")
objExcel.Workbooks.open "c:\somepath\somefile.xls"
objExcel.Show
Re: a control to display an excel document 80 80
Member Avatar 
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.

Re: a control to display an excel document 80 80
Member Avatar

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

Re: a control to display an excel document 80 80
Member Avatar

Hey,

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

avv2

Re: a control to display an excel document 80 80
Member Avatar

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!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.

Sign Up — It's Free!