How to remove datatable headers?

Hi. I want to remove headers in datatable and I am using Remove Datatable Row activities but I don’t know what to write in RowIndex.Can someone help me please?

There is not a way to do that, datatables always need the headers…

1 Like

Is not it possible?

no… it is part of any datatable specification… why do you try to do that?

1 Like

I want to convert it to text and I don’t want to headers

I suggest to you to remove the header after you create it as text…

1 Like

which way should I do?

Depends on how do you want your text to be… What was you plan to convert to text?

1 Like

I converted with output datatable. But headers at the beginning of the text

Write the same datatable in other excel and convert it to String using OutputDataTable
and make sure while writing second time
in write range property panel uncheck the Add Headers

1 Like

Just put an Assign activity with the output variable from Output DataTable like this:
MyDataTableText = MyDataTableText.Remove(0, MyDataTableText.IndexOf(Environment.NewLine)+2)

1 Like

Hi,

You can try using on the output of Output Data Table (text) the method Substring like this.

text.Substring(text.IndexOf(vbCrLf))

1 Like

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