Excel- Adding Multiple Columns into excel without Data

#1

Hi All,

I have one excel sheet with column headers.
I want to add multiple columns at particular location in that file.
Sample.xlsx (7.7 KB)

In this file , have 10 columns like sample1 to sample 10…
i want to add sample11 column in between sample3 and sampl e4…
and sample12 column in between sample6 and sample7…

Can you please provide solution with workflow?

Thanks in Advance…

Regards,
Sagar.

#2

@SagarSB try below workflow it will help you. It will work if your excel has atleast one row of data.

AddExcelColumn.xaml (9.8 KB)

#3

hi…
My excel is containing huge data…
after the execution it is filling Column1 - column n into empty column

Please help

#4

@SagarSB i didn’t get you can you elaborate your problem?

#5

the solution which was provided by you is not able add column to sheet.

#6

Problem
Problem.PNG938x484 4.46 KB

After successfully adding column into file…at the end these column get automatically added

#7

@SagarSB may be ur excel which u have read has empty values that is the reason u got those extra things.

#8

no it is not empty ,it is having huge data

#9

@SagarSB how many columns u have added? check ur workflow once clearly.

#10

i have added 2 columns…one at 3rd position and another at 9th position.

#11

@SagarSB can i see your workflow. if your ok