Insert Blank Row

[babita (Vedika)]

In excel no of rows,I want to add blank row after each 950 rows count.how to add?

[AshwinS2 (Ashwin S)]

Hi @babita

Check this

How to insert category wise blank row in Excel Sheet?

Existing workflow, I already develop insert blank row activity in the Excel sheet but it’s work fixed after every 02 rows. But my expectation is, How to insert blank row dynamically in the excel sheet category wise. [image] [image]

Thanks
Ashwin S

[lakshman (Ganta lakshman)]

@babita

Please check below thread.

Insert a blank row after every two rows in Excel

Hi, I have an excel file of around 7000 rows. [1] I need to insert a blank row after every two rows like this: [2] Can somebody guide me to do this? Thanks! Main.zip (15.8 KB)

[AshwinS2 (Ashwin S)]

Hi @babita

You can use excel application scope and use insert /delete rows

Insert/Delete Rows

Thanks
Ashwin S

[hacky (NotHacker)]

@babita

IT IS VERY EASY…

Use the counter and the check to verify if you are on the 950th row…

then Use “ADD DATA ROW” activity and supply the Datatable name and give “{}” in the array row field in the properties.

Regards,
@hacky

[babita (Vedika)]

Will it iterate every 950 row?

[AshwinS2 (Ashwin S)]

yes

Thanks

Ashwin S