Exception thrown while adding trying to add new column to an existing excel file

excel
activities

#1

Hi There,

I am facing an issue with ‘Insert Column’ activity, where an exception is thrown while trying to add a new position. Below is the screenshot of the workflow.
image

Below is the exception that is thrown when i run the workflow.
image

Would be glad if someone can help.

Thanks & Regards,
Rammohan B.


#2

@Rammohan91
Can you share the screen shot of properties what you gave

Check the index or position property, where you have to insert the column

Regards,
Mahesh


#3

Hey @MAHESH1, Thanks for the reply. Here is the screenshot of properties for ‘Insert Column’ activity. I tried both with and without position, however in both the cases its throwing the same error. My table has only 2 columns as of now ‘Sr No’ & ‘Name’ and have given the table name as ‘Table1’ as selected under the activity.
image


#4

@Rammohan91

refer this


You have to use this inside Excel application scope
mention the position of the column as the index( eg: 0, 1 like this) that where you have to insert,
if you are not going to give position parameter then it will insert at the last.

Regards,
Mahesh