Microsoft Office Add-in's

12 posts, 0 answers
  1. Sacha
    Sacha avatar
    10 posts
    Member since:
    May 2012

    Posted 02 May 2012 Link to this post

    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
  2. Jack
    Admin
    Jack avatar
    2335 posts

    Posted 02 May 2012 Link to this post

    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 >>
  3. UI for WinForms is Visual Studio 2017 Ready
  4. TonyG
    TonyG avatar
    239 posts
    Member since:
    Feb 2006

    Posted 19 May 2012 Link to this post

    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. :)
  5. Jack
    Admin
    Jack avatar
    2335 posts

    Posted 28 May 2012 Link to this post

    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 >>
  6. Mary
    Mary avatar
    1 posts
    Member since:
    Jun 2012

    Posted 22 Jun 2012 Link to this post

    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.
  7. TonyG
    TonyG avatar
    239 posts
    Member since:
    Feb 2006

    Posted 22 Jun 2012 Link to this post

    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? ;)
  8. Gary
    Gary avatar
    5 posts
    Member since:
    Mar 2014

    Posted 23 Apr 2014 Link to this post

    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?
  9. Dess
    Admin
    Dess avatar
    1605 posts

    Posted 28 Apr 2014 Link to this post

    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.
     
  10. Gary
    Gary avatar
    5 posts
    Member since:
    Mar 2014

    Posted 28 Apr 2014 in reply to Dess Link to this post

    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.





  11. Gary
    Gary avatar
    5 posts
    Member since:
    Mar 2014

    Posted 28 Apr 2014 in reply to Gary Link to this post

    ...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???
  12. Gary
    Gary avatar
    5 posts
    Member since:
    Mar 2014

    Posted 28 Apr 2014 in reply to Gary Link to this post

    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 
  13. Dess
    Admin
    Dess avatar
    1605 posts

    Posted 01 May 2014 Link to this post

    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.
     
Back to Top
UI for WinForms is Visual Studio 2017 Ready