How to prevent table headers from inserting data from Text into an Excel table?

I’m importing data from a text file, separating lines by cells in column A, but the data overlaps with table and table headers.

My data

In my Ui Path



Result

But I want to do this

Best Regards

Hi @Famui_Yanisa

First add build data table then it give to add data row later write range workbook

1 Like

@Famui_Yanisa

Check these options in generate datatable from text activity:
image

1 Like

Hey @Famui_Yanisa

in your write range workbook
Untick the add headers property
image

1 Like

@Famui_Yanisa

In write range provide the cell as "A2"

Cheers

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