I am doing an assignment where I search in an API, with given values from my Excel file(Elastic Search). Then I have to extract multiple values from the API and paste these values into Excel. I have no trouble accessing the API.
I use a simple for loop to iterate through my values from the Excel file. The problem occurs when I try to write the values from the API into my Excel file with Write To Cells, using the RPA.Excel.Application library. The error I get is: AttributeError: ‘NoneType’ object has no attribute ‘Cells’.