it's sound crazy.but yes that's what i want.
i work for TV station ,major in graphic DEPT
i am incharge of subtitle daily update.
every day i got a excle file from pre-broadcasting DEPT ,then i copy and paste the wording from excle to aftereffect's different layers then add fade in\fade out effect and render then.
actually, it's not a hi-tech,but workload is huge!
i have to copy paste 200+ every day, freak out...
is it possible that AE can import wording automatic paste them into the layer?
thanks for reading my crazy thought...
Message was edited by: Andrew Yoole - Corrected title spelling for clarity
Here is a script by Dan Ebberts in his web site that will take each line in a text document a turn it into an After Effects text layer.
So, if you to save your Excel documents as text, it should help-
In addition to the simple text from file script pointed out, you may also wish to look into things like the ones below:
They may not contain the perfect solution you seek, but the code could be modified to suit your needs. there's a couple of more scripts out there with similar functionalities, most of which can be found on or via AEnhancers.