Hello,
So I have a flow that grabs data from a website, then grabs data again, and then should remove duplicate rows, and then paste into an Excel sheet. Here are what those steps look like
This isn't the best solution to getting all the rows out of a stupid iframe, but it's a solution for now. :) However there is one duplicate lingering, and I realize now because there is an extra space being added, and I don't know where it's coming from. It's pulling the exact same data twice from the source, it's just scrolling down.
I don't know if it's a problem with Automate, or Excel? This is opening up a pre-made Excel template. I assuming the 'Write to Excel' step will overwrite anything there anyway, but just in case I went into the template and selected all those rows, I did a delete on the keyboard, I did a right click -> Delete, and I did a right click -> Clear content and resaved it, but it's still happening. Any thoughts?
