Write cell removes the headers in Excel

Help Activities
,
1

I have an Excel like this:

image
image1566×334 4.27 KB

I am using a write cell activity to write into cell A2 - but for some reason this removes my headers like this:

image
image1295×341 3.18 KB

The write cell activity does not have an overwrite property so unsure why this is happening

2

Hi @E.T.S ,

Could you provide us with the Workflow Configuration that you have done or the Screenshot of it? It would help us to understand the issue.

3

@E.T.S

it will not remove the header as you are writing in the cell A2 it will rewrite only on the cell A2 if any value present

cheers

4

I have copied and renamed a file which does nor change the Excel file, but when I use the write cell activity the headers remove

image

image

image

5

The headers in row 1 are removed but the data from the write cell activity works:

image
image929×208 5.4 KB

6

@E.T.S
can you share the image of the excel file before writing into it

like excel file which is having headers

cheers

7

@E.T.S ,

Could you perform a Check right after the Rename File activity is done, without the Write Cell Activity being executed, If the file is actually present or existing ? Just to check if the Copied file is properly having the headers also?

8

image
image1050×249 14.4 KB

9

Yup the file exists, and the headers are still there after the rename activity

10

@E.T.S ,

We see there are two different variables being used, argIn_strReport and argIn_strReportName.

Could you validate if both are having the Same File Path ? I believe there must be a difference in the File Paths

11

I am passing the argument out here in this xaml:

image
image987×139 7.42 KB

Then passing the value to another xaml like this:

image
image893×60 2.7 KB

Would this be incorrect

12

@E.T.S ,

We would want you to check the File Path and check whether the File Path generated is also the same.

We could also try with a Test Workflow where you are hardcoding the File Path of the Excel Template and then write the data using Write Cell activity and check whether it overwrites the data or not.