The first time I developed a small custom web add-in for Microsoft Excel was the time when it rendered via Internet Explorer as a WebView, which had the worst debugging tools and under the best circumstances, they worked from time to time:)
It was a small piece of JavaScript that changed some names in cells and that's all. By that time I have known only VBA for Applications and was excited to study new technology to simplify my daily workflow in e-commerce.
For some time, I've studied a Typescript with Vue.js and love it and I've started building a small add-in in my free time to navigate, search and manage worksheets in one book. Unfortunately, the designing with HTML and SCSS was quite hard for me, and after some time I built the first version (see dark theme screenshot on the left). I was proud but something was missing in the code and in the design part.
Over time I tried to return to the app, but all my tries failed:)
Two years later after my last try, after using Flutter quite much for mobile and cross-platform development the puzzle suddenly was solved in one night and with a couple of late hours - inspired by firebase and react interop dart libraries, I wrote a small js interop dart library for office.js. And hooray🎆 it worked:)
Well, I thought, why not, and by using Flutter with Fluent UI after 7 or 8 days later the add-in was rebuilt from the ground and it was just excited time to see that anything possible via tries and failed:)
Hopefully this time I will publish it to Microsoft Store, but even if it is not, well, even this story is completed, others are not:)
With a hope that this story can inspire:)
Anton
The useful links:
Sheet Manager repository and live website
Office.js interop library
It was a small piece of JavaScript that changed some names in cells and that's all. By that time I have known only VBA for Applications and was excited to study new technology to simplify my daily workflow in e-commerce.
For some time, I've studied a Typescript with Vue.js and love it and I've started building a small add-in in my free time to navigate, search and manage worksheets in one book. Unfortunately, the designing with HTML and SCSS was quite hard for me, and after some time I built the first version (see dark theme screenshot on the left). I was proud but something was missing in the code and in the design part.
Over time I tried to return to the app, but all my tries failed:)
Two years later after my last try, after using Flutter quite much for mobile and cross-platform development the puzzle suddenly was solved in one night and with a couple of late hours - inspired by firebase and react interop dart libraries, I wrote a small js interop dart library for office.js. And hooray🎆 it worked:)
Well, I thought, why not, and by using Flutter with Fluent UI after 7 or 8 days later the add-in was rebuilt from the ground and it was just excited time to see that anything possible via tries and failed:)
Hopefully this time I will publish it to Microsoft Store, but even if it is not, well, even this story is completed, others are not:)
With a hope that this story can inspire:)
Anton
The useful links:
Sheet Manager repository and live website
Office.js interop library
