Automating data in After Effects with Excel tables.
In this first video of my channel, I explain how to generate automatic changes to batches of compositions in After Effects using Excel tables. This can be very helpful for generating text banners or any graphic template that you need to modify repeatedly in your work.
Link to convert to Json format:
https://csvjson.com/csv2json
•Conditional expression to change color:
if(footage("Datos.json").sourceData[thisComp.name].Color=="Rojo"){
[1,0,0,1]
}else{
if(footage("Datos.json").sourceData[thisComp.name].Color=="Verde"){
[0,1,0,1]
}else{
[0,0,1,1]
}
}
This expression is applied to the color property and what it does is read the entries in the "Color" column of my Excel table and set different colors (in the format [0,0,0,0]) depending on whether it matches the colors in my "Red" and "Green" list. I didn't include "Blue" because it would be the default color.
•Conditional expression to hide or show a layer:
if (footage("Datos.json").sourceData[thisComp.name].Imagen==thisLayer.name){100}else{0}
This conditional is simpler, I applied it to the opacity property. It reads the "Image" column of my table and sets the opacity to 100 if the table entry, for example "Image 1", matches the name of the layer. For this to work, the layers must have the same name as the table entries, in my case "Image 1", "Image 2" and "Image 3".
AE project and Excel document:
https://drive.google.com/drive/folder...
0:00 Intro
0:10 The composition
1:02 The Excel table
1:56 Migrating from Excel to AE
2:40 Using entries from the table
3:50 Automating with the composition name
5:38 Using conditionals for color and opacity
7:03 Conclusion
Watch video Automating data in After Effects with Excel tables. online without registration, duration hours minute second in high quality. This video was added by user Mig Alejandro 19 October 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 6,71 once and liked it 27 people.