Add Data Row - Array row

[sphencer (HANSOL KIM)]

Hello, guys?

I’m working on a project to extract data from newspaper articles for a certain period of time and then store the data in Excel on a monthly basis.

However, if you type array row in the Add data row as shown in the picture, an error will appear.

Why is that?

The following is what I did for this project.

1. Open browser
2. Data scraping
3. Build data table
4. Split date using for each row
5. Use switch to enter data on each table.
6. Save as Excel

There was a problem running the add data row using the fifth switch during this course.

Would you be able to help me?

Thank you! =)

[Gemlan (Gemlan Krisel Guevara)]

Hi @sphencer can you share your xaml data???

[Lahiru.Fernando]

Hi @sphencer

It looks like, in the code, it doesn’t properly identify the double quotes for those column names in the row.item(“This part”)…

So replace the double quotes there… just delete and retype it… it should work…

Let know if that doesn’t…

[sphencer (HANSOL KIM)]

Thank you for answering, @Lahiru.Fernando!

I tried it the way you told me, but I still get an error.
Error saying row is not declared.

What’s the problem?

[Lahiru.Fernando]

@sphencer Use this code and see how it goes…

{row("Title").ToString, row("URL").ToString, row("Date").ToString}

Might need to replace the double quotes and retype if needed

[sphencer (HANSOL KIM)]

Thank you for answering, @Gemlan!

Here is my main project for this error…
Would you mind check for this?Main.xaml (23.5 KB)

[pattyricarte (Patty Boy)]

Hi @sphencer

What are you aiming to do? You encountered that error because your variable row was not available in your activities. Try to put you activities inside ForeachRow Activities.

cheers

Happy learning

[sphencer (HANSOL KIM)]

@Lahiru.Fernando
Really thank you for your helping.
But same error… what’s the problem in my project?? (T_T)

[pattyricarte (Patty Boy)]

yes @sphencer

you still getting the error because row was not accessible at this moment !

cheers

Happy learning

[sphencer (HANSOL KIM)]

@pattyricarte
How can accessible??
Would you mind let me know more in detail?

[pattyricarte (Patty Boy)]

@sphencer
Scenario
1.You want to access the value of the row in this datatable ExtractDataTable right ?
2.If it is right you need to put your Switch Activities inside the Foreachrow Activities to access the variable row.

See image below for your reference.

cheers

Happy learning

[pattyricarte (Patty Boy)]

@sphencer
like this the variable is now availble. See image below for your reference.

cheers:D

Happy learning:D

[sphencer (HANSOL KIM)]

@pattyricarte
Wow! Dear! You are right!
It fixed~!
Really, really thank you~!!!

Wow~ Hurrah~!

[pattyricarte (Patty Boy)]

No worries @sphencer

Happy to help here.

cheers

Happy learning