Columns are not adding next to the column

[ManjunathReddy (P Manjunatha)]

I am trying to add the columns to the existing column, but due to the background color it is not adding in expected place.

Thanks

[Yoichi]

Hi,

How about copying formats using Copy/PasteRange activity after insert columns?

Regards,

[Shubham_Kinge]

Hello @ManjunathReddy
Try this solution.
Read whole sheet as datatable then try to remove empty columns and add your new columns in datatable and then again write it to the same excel.

[ManjunathReddy (P Manjunatha)]

@Yoichi

I am following a different method for adding date columns and don’t want to disturb it now.

So is there any other solution?

@Anil_G

[Yoichi]

Hi,

Can you share your current workflow?
I suppose CopyPasteRange activity will also work in your workflow.

Regards,

[Anil_G (Anil Gorthi)]

@ManjunathReddy

after reading you can check if the column is empty and find the first empty column and use that index to write the data

for each on columns and inside thst use filter to check column is empty .filter will be currentitem.columnname and isempty

filtereddt.count =0 then store the index value and break the loop

that index can be used

cheers