-
Excel shopping list price comparison
Hi There,
I’m working on a project to import Excel cell data into an animated shopping list.
The idea is that you see a grocery receipt where you can see the price difference between identical products but bought at different stores.The first column contains the groceries, the second contains the price and there is a third column that contains the second price. The maximum number of comparisons per receipt is 7.
I have to make several receipts and the input has to be animated line by line with a pause between every input (ie. excel_line_1: 1kg apples [pause] € 1,25 [pause] € 1,35).
If it would be only one receipt I would build this without expressions but I have to make quite a lot…
There are numerous excel-data import scripts available but nothing that works like this. Is there an easy way to import the csv-data and animate this?Greeting and Salutations
Gerben
-
2 Replies
-
Hey Gerben, one of the ways to do it:
1. You can animate one receipt and link all variables from .csv with expressions.
2. To add to the first point, name the composition that it would have index like following: receipt-[index] So it would be receipt-0, receipt-1 etc.
3. Link your expressions at the first point by grabbing data based on receipt index, like the following: thisComp.name.split(“-“).pop() It will get an index
4. By duplicating composition in project panel, you should get updated lists.Some additional double checkings might be needed to hide fields when they are irrelevant though
-
Hi Tomas,
I’ve found a way to build it almost as you suggested and works like a charm!
Thnx!
Reply to this Discussion! Login or Sign Up