Hey Everyone, I’m using Excel Activities to inset a column in my work book. I set a condition as following
Range: Excel.Sheet(“123”)
Has headers: checked
Where: After
Relative to column: “TEST_MO”
Add header: “TEST_ERROR”
when the flow run into this activity, there is a exception showing that "Column does not exist. "
I check my workbook and I’m sure the column “TEST_MO” and sheet “123” are existed.
is anything i can do for solving this problem?
Hey Can you check if “TEST_MO” column contains any spaces before or after it in the excel sheet
can you check the column name which is having any spaces or Type the name manually in the code and check once
I tried from my end its working
cheers
Thanks for replying me, i just checked my the column “TEST_MO” didn’t contain any spaces before it or after it. I was wondering if the excel activities “insert column” created a new column when there was no column for it to insert the data or I need to create the column before execute this activity?
Thanks for replying me, i just checked my the column “TEST_MO” didn’t contain any spaces before it or after it. I was wondering whether i needed to create a column named “TEST_ERROR” before I execute the activity or the activity would create the column i need when there was no column for it to insert the data?
Hi @jojo11050702 ,
You can write cell with “TEST_ERROR” to column if it in last column
If you have index
you can use invoke
Hey @jojo11050702 , Insert column will create a new column if TEST_MO is present.
Can you send the sheet you are using
Thanks everyone, I used debug mode to find out where the problem was, then i found out the path that the excel activity referred to was not point to the folder I placed the workbook i needed. After editing the path, the problem solved
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
Palaniyappan
Anil_G
mpraveen1902
Yoichi
prerna.gupta
nien_shan_thai
Kartheek_Battu
CHAN_Hiu_Fung_Victor_Stud
KishoreC
nikhil.girish