Using Excel Office Scripts for Engineering Application.

Bill Bell 101 Reputation points
2022-08-22T14:13:45.647+00:00

When I first looked at Office Scripts I was thinking it is good for simple formatting. I have an Excel VBA addin (.xlam) engineering app that does estimation and optimization for a product. I'm wondering how extensive an app you can create in Office Scripts. It has interesting opportunities for collaboration. Questions:

Is there a runtime limit for a script? I envision some optimizations taking 20-30 minutes.

Is there a size limit on scripts? My VBA addin is 2500 lines.

Is there a good way to manage large Typescript files?

Is there a runtime memory limit?

Is there a limit on JSON fetch data size/number limits? My addin uses a local Access database to hold engineering data. I envision creating a lot of JSON files from the database.

Is there any way to use GIT or Devops for backing up scripts.

Is there a way to use Visual Studio or VSCode?

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,212 questions