For a job i made a very simple but also very quick working client that imports Excel files.
Idea very simple.
Firstline of the excel file contains the template field names (like ‘f0’)
all other excel lines contain the data to be shown.
You can select one of these lines and show.
Making data delivery by 3rd parties fast and easy to understand.
Just for inspiration for all client builders here.
if you like I am willing to share
big thankyou to team “superfly” for making casparcg-connection
Have you seen this? Whit it you can do the same from whit in Excel itself. And you can use all sort of formulas and stuff…
Yep i guess it was a source off inspiration 
Really like your plug-in / approach !! 
My approach here was to make it “ultra” simple / very basic.
As it fit’s more in the operation i made it for.
yes it is certainly less versatile then your plug-in.
That is nice to hear, thanks.
Mine was to make it as flexible as possible, so that “power” users of Excel can use all of their know how to shape data the way they need it. The price is, that it’s not so easy to use.
I just reticently made a quick client for live subtitling of an opera (!) that imports Excel data and updates a simple template. So, as you said, sometimes the best approach is to build something for a particular use case.
Hi Maurice78,
It looks very useful. Will be great if you share it.
Thank you in advance.
When I find time I will clean it up a bit and post it here
sounds very interesting , what is the language you used ? Would be even more interesting to be able to work on gsheet (for my needs 
since anyone can update it at any time during the show way easier than an excel file.)
On my side I worked on a node-js interface that was using google API to retrieve data from gsheet, then update casparcg template in real time. Never finished and it stayed a demo purpose, but interesting enough
You could use a power query in Excel to pull the data from gsheet and my AddIn to update a Caspar template with the data.
here it is 
i am by far not the best coder soo stuff can be ugly inside
feel free to use or change
ls
Maurice
Any hints to do things simpler / better are very welcome
Hi Maurice78,
Thanks for sharing, but I’ve got a little problem. When i test it there is a error:
20 error code ELIFECYCLE
21 error errno 1
22 error xlstoccg@1.0.2 unit:karma start test/unit/karma.conf.js
22 error Exit status 1
23 error Failed at the xlstoccg@1.0.2 unit script.
23 error This is probably not a problem with npm. There is likely additional logging output above.
24 verbose exit [ 1, true ]
When i try to play a template server back error too:
[2019-09-18 10:57:38.257] [1560] [info] Sent message to 127.0.0.1: 400 ERROR\r\nREQ 2lgtvxn CG 1-20 ADD 1 “FOOTBALL\Ploch” 1 “{}”\r\n
May be I do something wrong?
hmm did you use NPM or YARN to install package’s ?
i used yarn.
is there a template named “FOOTBALL\Ploch” in your template folder.
i will put a example excel file in the repo later.
maybe it is formatted different then it supposed to.
grt
maurie
Intuitive and powerful.
I like that I can see the template value intuitively.
