CasparCGAddIn for Microsoft Excel

client

#1

For more than a year now I am working on a Add-In for Microsoft Excel (Windows only). Now it seems to be in a status were it can be used. What is missing and will follow soon is a documentation about all the buttons etc.

You can either download the source code or the setup or both.

Have fun.


XML setup help
#2

For more than a year now I am working on a Add-In for Microsoft Excel (Windows only). Now it seems to be in a status were it can be used. What is missing and will follow soon is a documentation about all the buttons etc.

What does it do? what is if for?


#3

Stupid me :smiley: I should tell that also. It let you use Excel as a client for CasparCG. You can use it to send datasets to Caspar or use it as a fully interactive client. As Excel can import external data via PowerQuery, you can use it to inquire for instance sport results from the internet, fotmat it, and send it to Caspar. There is also a mechanism to let one or more of these PowerQueries run automatically on loading a template. That can be used to load external data each time you show a graphic. I used it for drone racing, were the time keepers provided the data via a JSON service. It‘s a matter of minutes to build such a query, instead of programming a custom client for each application. It can also be used for voting etc. I am currently writing a user manual and hope to finish that by tomorrow.


#4

In the mean time I have written kind of a documentation of the Add-In. You find the PDF here.


#5

Hey Didi, great great tool! The power query is awesome. On which platforms (Win, Office, Caspar) have you done your testing ? Tested local or network connection ? I have some issues Win10, Excel 2016 64bit via network to CCG 2.2.0 on Win7. Preview works for list items but I don’t get any PGM out.


#6

Hi Dirk, I tested it with server 2.0.7 as when I started the project, a year ago, that was the stable version and also what my clients work with. Have you read the documentation? There it should explain how to get output. For the list worksheet there are settings under the little gear icon in the lower, list related, pane of the dashboard.

Grab2

For the worksheets were one sheet is one graphic the settings are in the dialog-box you access from the CasparCG ribbon “Data” pane.

Grab1


#7

Hey Didi,

I LOVE this. I am a complete newbie with CaparCG though. How do I get the client side to input the data? Or even create a template that would work with it.


#8

This IS the client. You get the data into Excel in any way you get data into it. By typing, copy / paste or PowerQuery. You can use any templates that you have with it, there is no difference to the way other clients play templates.


#9

Ok List ist working now. Rebooting everything and using 2.0.7 fixed the not working PGM playout. When using 2.2.0 I don’t get any templates in the drop downs. The TLS command arrives at the server and replies but Excel does not show any templates. Now I first need to learn how to program a template for custom worksheet data. Thanks so far.


#10

The latest build corrects this. The format of the TLS return data has changed.


#11

Very nice approach Didi

this is definatly something for in the toolbox !