Using Excel Office Scripts for Engineering Application.

Question

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?