Hi Everyone,
I’m currently working on a crawl reading from an Excel worksheet. In the expression, I’m using the N method. I’ve attached a sample Excel sheet for reference. I’m data linking it starting from line 3: Scene 1, Text 1… <N+1>, Scene 2, Text 1… <N+2>, and so on for all the other scenes. I only have five scenes, but it reads all items in the Excel file, regardless of whether there are 20 or 200 items. After completing the crawl, it is also reading the second line in the Excel sheet, which states “miamidadecounty.” a lot of times. I’m not linking that line, but it keeps showing up. This behavior didn’t occur consistently during my testing, and it was also demonstrated to my supervisors.
Does the N method require at least 10 items in the Excel sheet for it to read and loop correctly? There are some meetings where we only have one item. I’ve noticed that if I add more items to the Excel sheet, it works properly. Thanks, Laz
laz
try starting at N+0 and then N+1, N is incremented each time so at the end of say 200 items N is 200 plus whatever number you add so you might be jumping to position 2 when you wrap around.
Ok. I will try this. IF not can you log in by team viewer and helps us out?
Training and Creative Services help usually has to be purchased unfortunately.
Is there anyone from Ross you deal with locally?
let me know if that improves things.
I started at n+0 etc and nothing. It loops then reads the line I don’t want it to read
Get Outlook for iOS
have you set a table you are using in your excel and connect to that and not to the entire sheet?
I don’t know. i had the crawl working fine with the training i got but now it doesn’t work. it reads the first 5 items then nothing even though the excel sheet has 16 items…and at the end it loops and reads line 2 which i dont want it to read. Here is a copy of the project and excel file. Thanks.
you are connected to the sheet not the table
ok. The excel sheet will have the same name but the agenda items on it will change every week. how do i connect to the table?
