Add Data Row - Array row

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! =)

2 Likes

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

3 Likes

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…

2 Likes

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?

@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

1 Like

Thank you for answering, @Gemlan!

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

1 Like

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. :smiley:

cheers :smiley:

Happy learning :smiley:

2 Likes

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

1 Like

yes @sphencer

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

cheers :smiley:

Happy learning :smiley:

2 Likes

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

1 Like

@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.

image

cheers :smiley:

Happy learning :smiley:

5 Likes

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

image

cheers:D

Happy learning:D

5 Likes

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

Wow~ Hurrah~!

3 Likes

No worries @sphencer

Happy to help here. :smiley:

cheers :smiley:

Happy learning :smiley:

4 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.