Choosing an Excel development technology [closed]

General Tech Technology & Software 2 years ago

0 2 0 0 0 tuteeHUB earn credit +10 pts

5 Star Rating 1 Rating

Posted on 16 Aug 2022, this text provides information on Technology & Software related to General Tech. Please note that while accuracy is prioritized, the data presented might not be entirely correct or up-to-date. This information is offered for general knowledge and informational purposes only, and should not be considered as a substitute for professional advice.

Take Quiz To Earn Credits!

Turn Your Knowledge into Earnings.

tuteehub_quiz

Answers (2)

Post Answer
profilepic.png
manpreet Tuteehub forum best answer Best Answer 2 years ago


I have an Excel spreadsheet and I've been tasked with displaying the data in an interesting way and adding some interactivity. I am trying to choose between creating an App for Office or using VBA macros to enhance the spreadsheet. What technology makes the most sense for my situation?

  • I am using Excel 2013 and Windows 7 (All users of the spreadsheet have the same environment).
  • I am not a software engineer, though I have some programming experience.
  • I do not need to access any external services (database, web API, etc.).
  • I do not need to access any Office documents besides the spreadsheet.
  • I need the code to be easily distributed along with the document.
  • The code needs to be available offline
  • I do not have Visual Studio

Primary concerns:

  • Ease and enjoyment of development
  • Ease of manipulating the spreadsheet (I am concerned that I won't have as much control over the document with the Apps for Office Javascript API)
  • Ease of distribution (I will not be able to setup an app store within my organization)
  • Attractiveness and usability of the end product
  • Availability of resources and documentation
profilepic.png
manpreet 2 years ago
  • Ease and enjoyment of development

this will initially depend on what you are used to: if you are familiar with the OO environment, then stick with VBA. likewise, a Java/web background will see you settle into the Apps environment more quickly

  • Ease of manipulating the spreadsheet

I can't speak with experience of using Apps for Office, but I can theorise that MS Office will prove to be a far more feature-rich, stable and integrated development environment for some time, if only because it's already been around for 20 years.

  • Ease of distribution

MS Office add-ins can be fiddley to manage if users are not based on a single network, but this has long been the case and there's plenty of solutions/work-arounds published on the web

  • Attractiveness and usability of the end product

unless you are going to start retailing the product, I think MS Office is more than viable here

  • Availability of resources and documentation

again, there's 20 years-worth of forum discussions, blogs and expert solutions for MSO at your fingertips, for free

Also, I believe the MSO software license is a one-off overhead, whereas Office 365 etc is subscription.


0 views   0 shares

No matter what stage you're at in your education or career, TuteeHub will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.