Skip to main content
V
Vladyslav26943554unsi
Participant
November 3, 2022
質問

Import Patreon patron list from xlsx file to After Effects for mogrt

  • November 3, 2022
  • 返信数 1.
  • 255 ビュー

Hi. I'm trying to create a responsive list of patrons for a YouTube channel. It is possible to extract the current list of your supporters on Patreon, and I can convert it from xlsx to csv, but I'm struggling to proceed. I am trying to create a text layer, which will collect a list of patrons from the csv file I add to this mogrt.

The file has the list of all the names needed in the very first column. Row 1 has the names of the column, so I need everything from first column starting from second row. I would also like to separate these names with comas.

Can anyone help me with the expression needed for that?

このトピックへの返信は締め切られました。

返信数 1

Mylenium
Mylenium
Legend
November 3, 2022

You would need to run a look that concatenates all the names. Something like this perhaps:

 

mRef=thisComp.layer("Patreons").sourceData;

mNames=[];

 

for (i=0;i <= mRef.length;i++)

{mNames.push(mRef[1,i].dataValue.toString()+", ")

}

 

Mylenium

契約条件Accessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices