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
Смотрите видео Automating data in After Effects with Excel tables. онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Mig Alejandro 19 Октябрь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 6,71 раз и оно понравилось 27 людям.