• Adobe After Effects Expressions

  XML excel spreadsheet – access text in cells.

  Posted by Fabio Apelbaum on May 23, 2016 at 4:29 pm

  Hi guys!

  Im trying to use an excel spreadsheet (XML) to change text layers In my after effects project, I was looking at the code inside the excel spreadsheet XML I have and this text that I am trying to access seems to be inside namespaces, such as in this sample: Data ss:Type=’String’>original text /Data. is there a way to retrieve “original text”?

  Please find some of the code I have so far in the image attached, I included the xml inside my code just to test it, later I will write my script to gather the XML info from an XML Excel file.

  This is what the XML file looks like:
  

  And this is so far, the code that I was able to put together, it just does not do what I need yet….

  Thank you all in advance!!

  Fabio Apelbaum replied 9 years, 12 months ago 1 Member · 0 Replies
• 0 Replies

Reply to this Discussion! Login or Sign Up