Feb 29 2024 09:25 AM
Hi,
I’ve started to work on a product that will have a deep integration with Excel with the following requirements.
I’m wondering what Excel extensibility framework I should be using: VBA, JS, COM or .NET (or perhaps none of them fully support what I’m looking for). If anyone has experience or insights into which framework would be most appropriate for these requirements, I would greatly appreciate your guidance.
Thanks,
Mar 02 2024 06:53 AM
For the requirements you've outlined, a combination of different Excel extensibility frameworks may be necessary to achieve your goals. Here's a breakdown of each framework and its suitability for your requirements:
1. VBA (Visual Basic for Applications):
2. JavaScript:
3. COM (Component Object Model):
4. .NET:
Given your requirements, a combination of VBA for basic automation and tracking, and a .NET-based approach for advanced UI integration, interactive features, and backend communication may be the most suitable solution. You can leverage the strengths of each framework to build a comprehensive Excel add-in that meets your needs. However, the exact approach will depend on factors like your development skills, resources, and project constraints.
My knowledge of this topic is limited, but since no one has answered it, I entered your question in various AI. The text and the steps are the result of various AI's put together.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.