Hello forum members,
I am trying to automate a web-scraping script that uses IP addresses to look up machine details on an internal website. I am facing a problem where the “Get column” action can only hold 2000ish entries of the 45,000+ line cells (contents are IP addresses) in the excel file when I transfer the contents to a list variable.
- Is there an upper limit on how many cells worth of data can be stored in a list variable?
- Is there a workaround to pick only 1500 cells at a time for processing using the “For Each” action till all 45K entries are processed since the filter does not currently accept variables?