This is a migrated thread and some comments may be shown as answers.

Microsoft Office Add-in's

11 Answers 242 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Sacha
Top achievements
Rank 1
Sacha asked on 02 May 2012, 09:39 AM
Hello all....

I have a quick question. I'm developing an add-in for MS Project. The add-in will essentially be a pop up Windows form but it must contain a line graph which will be rendered from values in an array.

Can the Telerik Winforms controls be used on forms which are contained in an MS Office add-in?

Many thanks,

Sacha

11 Answers, 1 is accepted

Sort by
0
Jack
Telerik team
answered on 02 May 2012, 02:07 PM
Hello Sacha,

Thank you for writing.

A possible approach will be to wrap your application as an ActiveX control. However, please note that our controls are designed to work in a managed environment and we cannot guarantee that everything will work properly when using ActiveX.

Please refer the following article which describes how to create an ActiveX user control using C# and WinForms:
http://www.telerik.com/support/kb/winforms/general/wrapping-a-net-user-control-as-an-activex.aspx

A better way is to use VSTO. This should work in your case and should be easier to implement. However, please note that our controls are designed to work as stand alone applications rather than add-ins, so some side effects may occur. Attached you can find a sample application demonstrating how to add a RadButton in a pane in Excel, and upon button click a RadForm is opened.

Should you have any other questions, we will be glad to help.
 
All the best,
Jack
the Telerik team
RadControls for WinForms Q1'12 release is now live! Check out what's new or download a free trial >>
0
TonyG
Top achievements
Rank 1
answered on 20 May 2012, 04:35 AM
Hi, please pardon me for jumping in here. The answer to your question is Yes, you can use RadControls in Microsoft Project.

Now, you need to listen very carefully...  :)

I am a huge fan of Telerik RadControls. I have a Premium license which I use primarily for ASP.NET and Windows Forms development.

I am also a huge fan of Add-in Express, which is to Microsoft Office what RadControls are to the user interface. Note: I am an avid user, not an employee or shill - so this is not an ad but an enthusuastic endorsement for fellow RadControls user/developers.
 
Add-in Express (ADX) provides a set of controls which are used instead of VSTO, just like we use Telerik grids and trees and other controls as a superset of what Microsoft provides. ADX facilitates event handling, integration with the Office UI, and especially with deployment.

Deployment is the major issue we all have with Microsoft Office development. We need COM shims between our managed code and the environment. There is documentation on this going all the way back to 2000 and it's been a royal pain. I've blogged the issues, read hundreds of other blogs, articles, forum postings, and books on the topic. It can be pure torture to get an add-in to work at all in a non-development environment. These days it's easier with VSTO and default VS2010 extensions, but if you want to deploy a single add-in to users who are running with different versions of Office in different versions of Windows, your world is going to be dominated by little nuances, setup tweaks, C code, and work-arounds that are all completely outside the scope of your application. Add-in Express eliminates all of that.

So from one RadControls user to another, please visit the Add-in Express website. Read the blogs. Go through the forums (you'll see my name in there too). You'll see employees as dedicated as those at Telerik supporting software as good as RadControls, and a dedicated base of users too. I have to say, it's not "slam dunk easy" to start working with ADX, any more than it is with RadControls. It's a new library with its own set of nuances. But once you "get it" your development will start to fly. (Seriously, you really need to go through the blogs and forums, like you do with RadControls, in order to understand the tool capabilities and process of using the tools.)

Does it work with Microsoft Project? Yes. My focus is on Excel and Outlook, and I'm making great use of RadControls to provide a professional and familiar user experience within those applications. You can do this with Project too.

Now I'll ask you for a personal favor. If you do contact Add-in Express, please leave a note for Andrei Smolin, a Team Leader there, and tell him Tony G sent you. Three years ago, he found one of my blogs expressing the pain of creating Excel add-ins, suggested that I try his company's software, and my life changed as much after that as it did when I found RadControls. I think he would appreciate knowing that his effort has born fruit.

I don't usually slobber all over myself advocating products like this with almost religious fervor. But I have two main tools in my kit aside from core Microsoft development tools, and those are RadControls and Add-in Express. I live in these tools every day of my life, spend my days and nights in the forums for these products, and earn a living when I show prospects what can be done with them. So I don't mind going a little over the top when expressing my satisfaction with them. Given the opportunity I embarrass myself with as much praise for RadControls. This has resulted in some of my colleagues and clients purchasing RadControls, and I hope you will similarly consider adding Add-in Express to your set of tools as well.

Uh, I hope that helps. :)
0
Jack
Telerik team
answered on 28 May 2012, 10:31 AM

Thank you for the kind words, Tony. We are happy to see you satisfied by our product. We also hope that your feedback will help the others that have issues with the Office plug-ins.

Greetings,
Jack
the Telerik team
RadControls for WinForms Q1'12 release is now live! Check out what's new or download a free trial >>
0
Mary
Top achievements
Rank 1
answered on 22 Jun 2012, 06:43 AM
I have no idea about the microsoft's add ons but I guess microsoft outlook is one of their add-ins.. i don't know how to use it but right now I am thinking to take microsoft outlook training online.
0
TonyG
Top achievements
Rank 1
answered on 22 Jun 2012, 09:42 AM
No... Outlook is one of the Microsoft Office applications, along with Excel, Project, OneNote, Word, and others.

An add-in is a COM object that gets registered within another application to add functionality. So an Office add-in makes Office apps do things that were not provided by Microsoft.

Sacha wants to know if RadControls will work in a MS Project add-in, to give it the look-and-feel that we all appreciate here. The answer is yes.

Mary, are you in the right forum? ;)
0
Gary
Top achievements
Rank 1
answered on 23 Apr 2014, 01:45 PM
I think that I found the right forum...
I am using Visual Studio 2013 Premium, Version 12.0.21005.1 REL.  I want to drop a Telerik.WinControls.GridView, Version 2014.1.402.40 (radGridView) onto Sheet1 of my Excel 2010, VSTO, document-level addin.  But it is disbabled.  I can drop it onto a winform in the same project and run it successfully.  How can I use your grid on my Sheet1 surface?
0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 28 Apr 2014, 10:59 AM
Hello Gary,

Thank you for writing.

Please find attached a sample project, demonstrating how to add RadGridView in Excel Sheet1, VSTO, document-level add-in. Docking a control from our suite to Microsoft Excel is a question, related to Office development in Visual Studio rather than Telerik UI for WinForms. Please address your question in the appropriate MSDN forums. Here is a link that can get you started: http://msdn.microsoft.com/en-us/office/hh133430.aspx

I hope this information helps. Should you have further questions, I would be glad to help.

Regards,
Desislava
Telerik
 
Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
 
0
Gary
Top achievements
Rank 1
answered on 28 Apr 2014, 02:48 PM
Hello Desislava,
The following steps do not work for me.  Do the same steps work for you?
1.  Install Visual Studio 2013 Premium Version 12.0.21005.1 REL.
2.  Install Telerik UI for WinForms Q1 2014 SP1 Trial
3.  Start Visual Studio 2013 and create a new project --
4.  File | New Project , Select Visual C#, Select Office/Sharepoint, Select Office Add-ins, Select Excel 2010 Workbook
5.  Open Sheet1 of ExcelWorkbook.
6.   Open Toolbox and search for radGridView ** no Telerik controls are listed, no radGridView control is in the toolbox.





0
Gary
Top achievements
Rank 1
answered on 28 Apr 2014, 02:53 PM
...The toolbox shows standard Winform controls and Excel Controls.  I can drop these onto the Sheet1 surface and use them.
What do I need to do to get your radGridView control onto my Sheet1 design surface???
0
Gary
Top achievements
Rank 1
answered on 28 Apr 2014, 03:42 PM
7.  Project | Add Windows Form, Select Windows Form, Windows Form1 designer opens.
8.  **Now the Toolbox contains all the Telerik UI for Winforms Controls.
9.  **Drag RadGridView control onto Winform design surface
10.  Now open Sheet1 surface and drag radGridView onto Sheet1.
It works!  Not sure what the problem was originally, but I hope that you can fix UI for Winforms install to work with Excel VSTO projects right out of the 'box'.
Cheers, Gary 
0
Dess | Tech Support Engineer, Principal
Telerik team
answered on 01 May 2014, 06:29 AM
Hello Gary,

Thank you for writing back.

When you create a new project - Excel 2010 Workbook, the Telerik UI for WinForms references are not included. It is necessary to add them in order to be able to display the controls from our suite in the Toolbox.

I hope this information helps. If you have any additional questions, please let me know.
  
Regards,
Desislava
Telerik
 
Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
 
Tags
General Discussions
Asked by
Sacha
Top achievements
Rank 1
Answers by
Jack
Telerik team
TonyG
Top achievements
Rank 1
Mary
Top achievements
Rank 1
Gary
Top achievements
Rank 1
Dess | Tech Support Engineer, Principal
Telerik team
Share this question
or