search

abrasher / excite

1 stars 1 forks source link

Tyring to solve similar problem... #1

Open demyte opened 1 year ago

demyte commented 1 year ago

Hey there!

Not sure if you are monitoring this repo, I came across it via your published vite plugin vite-plugin-custom-functions-metadata.

I am also trying to get a working Officejs + Vue3 + Vite + Typescript project going and for the task pane it is all working, but for the functions, trying to get vite (rollup) to have a separate entrypoint for the ./src/functions/functions.ts as something like /functions.js is a real blocker.

Did you get any further with this template and getting a custom function (with a shared runtime) going under vite?

Happy to collaborate to improve this template

abrasher commented 1 year ago

I have been unable to get shared runtime working with Vite and haven't put too much effort into it as I didn't really need it for my usecase. Let me know if you manage it on your own, would be happy to collaborate! Office.js isn't very well documented if you don't use the yeoman generator

abrasher commented 1 year ago

I added an example of how I use custom functions in excel with Vite. Again, this isn't shared runtime but does allow both task pane and functions in one project.

demyte commented 1 year ago

I didn't know there was the option to use the page with the custom functions as well, i'll add that in to my example thats using the shared runtime and see if I can get it working in that mode.

I'll let you know.

demyte commented 1 year ago

@abrasher I think I have it all working now with shared runtime, taskpane, commands and custom functions.

I have opened PR #2 for discussion etc...

Let me know your thoughts 👍