search

opf / OpenProjectExcel

MIT License
58 stars 23 forks source link

How to make Add in like this that sync? #22

Closed rajendrap123 closed 4 years ago

rajendrap123 commented 4 years ago

@oliverguenther @oliverguenther

I would like to make Excel add in like this which sync between excel and web server, and someone please tell me how to process?

Thanks in advance

bpetraus commented 4 years ago

hi @rajendrap123 actually I had this in mind, as well. This by itself isnt a big deal. If you're interested, there're several tutorials in the internet.

The problem in this special case is, that a lot of data is cached in worksheets. So if you want to reuse the code in an addin, you have to find a solution for this (probably create worksheets to runtime ect.) Possible, but I dont know, if this fits your case.

In general I would suggest you to switch completely to excel-javascript-api for the purpose of creating an excel web addin. I thought about by myself, and I will work on it. Just didnt found the time, yet.