How to remove datatable headers?

Help
, , ,
1

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?

1 Like
2

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

1 Like
3

Is not it possible?

4

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

1 Like
5

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

6

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

1 Like
7

which way should I do?

8

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

1 Like
9

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

10

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
11

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

10 Likes
12

Hi,

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

text.Substring(text.IndexOf(vbCrLf))

2 Likes
13

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