Object reference not set to an instance of an object for APPEND RANGE

Please see screenshot below. I am unable to share the xaml due to sensitiev info inside. This was working well in 2018.2.6. After I upgraded to 4.4 (including all packages), this error is shown after I scraped a PDF table to be appended in an excel file. Any idea how to resolve?

I read online and says I need to “initialise the variable” for this error to go away. What does it mean exactly and what do I do?

Hi @auto,

Can you check after scraping are you getting any output .

If the output is datatable, check if there are any rows datatable.rows.count.tostring

If you see you are using pttable in append range and pttable value is Null according to your screenshot that why you are getting this error.

1 Like