Problem with clone datatable

Help
1

Hello,

I had used datatable.clone to clone the headers of another datatable into a new one, but when i use write range i can’t see the headers but when i put the cloned datatable inside a msbox it shows the headers!!!

1 Like
2

Check Add Headers in write range

1 Like
3

Hello @abdel

Please, check if you marked the propriety “ADDHEADERS” in Write Range Activitie

4

i marked “addheaders” but it does not works!!!

5

@abdel

Can you share your code?

6

Initialisation.xaml (43.2 KB)

7

@abdel

Try disable the option "Create new file "in excel scope, I can’t test it because I don’t have the file.

8

there is nor “create new file” in my version:

image

9

@abdel
Send me the file

10

i sent you the file right now

2 Likes
11

Hi @abdel,

I don’t know if this is resolved, but if it isn’t, here’s what I noted in your workflow:

  1. You’re using a variable and an argument with the same name, and you’ve done this twice: “DT_Last_Modified_file_header” and “DT_Last_Modified_file”

  2. In the message box, I see you’re using the variable “DT_Last_Modified_file_header_txt” which you have only used once in your entire workflow. This is a string variable which never gets anything assigned to it in your workflow so i don’t know how you’re getting any value out of it.

  3. And in write range, you’re using “DT_Last_Modified_file_header” variable with Add headers column checked. This looks fine.

12

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