none
Is it a good idea to use Macros and Apps for Excel 2013 together? RRS feed

  • Question

  • Hi,

    I'm are trying to build apps for excel and have a need to leverage some of the excel elements like pivot table or charts. So far I have not seen anything in the java script api which allows me to work with these objects, where as I could do this with Add ins.

    Also there are scenarios where I need to deal with large data set and do some computation.

    Only way out looks to be using macroes for this and trigger the macro from my app. One disadvantage is that macros need to be enabled.

    Is this approach fine? Or is there any other way for an app to interact with excel objects using javascript api?

    Friday, March 15, 2013 5:39 AM

Answers

  • Hi, Seshu

    It's true that add-ins have capabilities that apps for Office do not have in Excel, so there are certainly situations where you might want to use add-ins. And you can have add-ins and apps together in the same document.

    However, you should be aware of some of the limitations:

    • We haven't done work specifically to make add ins and apps interact (for example, there is not a JavaScript function to call macros).
    • As you mentioned, the document would need to be macro-enabled.
    • The add-ins do not work on other platforms (eg. Excel Web App).

    Let me know if you have more questions. Thanks!

    -Michael

    Friday, March 15, 2013 8:21 PM
    Moderator