How to prevent blank rows to be written in Microsoft Excel Writer?

Get Help & Discuss
1

I am trying to pick up data from a table on a website containing blank rows in-between using Web Loop Table. But I do not want to write those blank rows to the Excel file getting generated through Microsoft Excel Writer.
Any solutions?

2

Well I solved this problem by myself. The solution is to import the file again with Microsoft Excel Input and select No Empty Rows option. That’s it. After this you could use Microsoft Excel Writer to get the new excel file without having any blank rows in-between. Hope this helps others too.

Solution
Solution.png1031×473 32.9 KB

3

That’s great Hitesh! Thank you for adding the correct answer.

4

My pleasure.