Column not found

Help Activities
,
1

Screenshot 2023-07-27 212028
column not found

I’ve ticked “add headers” when i read range

2

Hi @helpplease

You are using Write Cell, so you need to define it which column you need to write means A1, B1 like that instead of writing the column

Hope this may help you

Thanks,
Srinivas

3

Hello,

Can you check the following post , similar to your problem.

1 Like
4

^ this is what I am trying to do

5

Can you share the place where you have added column headers or changed it to date

6

Is 1/9/2022 the header, that’s what you want the column named? I’m pretty sure you can’t have / in column names. I recommend creating better headers in your source document.

7

@postwick

I just tried Headers with / symbol and it worked actually, Data can be retrieved if column Headers contains / symbol
Also, I agree with @postwick such names are not recommended for Column headers

image
image1399×778 35.7 KB

1 Like
8

Ok I wasn’t sure. Thanks for testing.

What if you try to output dt_test.Rows(0)(“01/02//2023”).ToString

9

I get the output
image

1 Like
10

Hi @helpplease ,

I believe you’re using the Write Cell activity, for that the error states that the column not found because the Write Cell would need the column names like A1, B1, C1, …

I believe you are missing a Step on converting the Datatable column name / the Column Name value that you have to a Excel Letter Column Name. Do check the post below, which also discuss the same topic :

11

Hi @helpplease

Please find the below xaml for your reference

BlankProcess4.zip (167.3 KB)

I hope it helps!!

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.