Copy link to clipboard
Copied
Hi,
I want to get data from a csv file.
This file has differents sheets.
I can get data with simple csv file (without sheets) and expression.
But is it to possible to get data and navigate into the sheets to get the data i want.
Thank you in advance
Copy link to clipboard
Copied
By definition a CSV cannot have different sheets. That's merely some extra info Excel generates for reimporting the data. So, no. You need to export them separately and link them individualyl just as well.
Mylenium
Copy link to clipboard
Copied
Hi There,
This is definitely possible with Adobe's built-in tool set. You import the CSV as footage layer type and then use its layer properties in that CSV in the expression. You can possibly pick-whip specific CSV properties while your cursor is in the expression editor.
You can also easily accomplish this with Templater for After Effects. It supports TSV (tabbed-separate value files) along with cloud-based Google Sheets, among other data source types.
You can read this article on how to get dynamic data into expressions.
Hope these references help!
—Arie
Copy link to clipboard
Copied
Thank you very much both !
Copy link to clipboard
Copied
As Mylenium said, csv files cannot include multiple sheets.
See https://stackoverflow.com/questions/29615196/is-csv-with-multi-tabs-sheet-possible
So most likely, you have to export a separate csv file for each sheet.
By the waay, my extension Automation Blocks also offers an easy and powerful csv file workflow for After Effects: