# How to remove datatable headers?

**URL:** <https://forum.uipath.com/t/how-to-remove-datatable-headers/185677>\
**Category:** Help\
**Tags:** datatable, question, system, activities\
**Created:** [January 16, 2020, 1:19pm UTC](https://forum.uipath.com/t/how-to-remove-datatable-headers/185677 "2020-01-16T13:19:43Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![sufyant](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sufyant/32/119310_2.png) [@sufyant](https://forum.uipath.com/u/sufyant)\
**Post date:** [January 16, 2020, 1:19pm UTC](https://forum.uipath.com/t/how-to-remove-datatable-headers/185677/1 "2020-01-16T13:19:43Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![bcorrea](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/bcorrea/32/103778_2.png) [@bcorrea](https://forum.uipath.com/u/bcorrea)\
**Post date:** [January 16, 2020, 1:24pm UTC](https://forum.uipath.com/t/how-to-remove-datatable-headers/185677/2 "2020-01-16T13:24:44Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![sufyant](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sufyant/32/119310_2.png) [@sufyant](https://forum.uipath.com/u/sufyant)\
**Post date:** [January 16, 2020, 1:26pm UTC](https://forum.uipath.com/t/how-to-remove-datatable-headers/185677/3 "2020-01-16T13:26:24Z")

</div>

Is not it possible?

---

<div class="post-metadata">

**Author:** ![bcorrea](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/bcorrea/32/103778_2.png) [@bcorrea](https://forum.uipath.com/u/bcorrea)\
**Post date:** [January 16, 2020, 1:28pm UTC](https://forum.uipath.com/t/how-to-remove-datatable-headers/185677/4 "2020-01-16T13:28:26Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![sufyant](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sufyant/32/119310_2.png) [@sufyant](https://forum.uipath.com/u/sufyant)\
**Post date:** [January 16, 2020, 1:30pm UTC](https://forum.uipath.com/t/how-to-remove-datatable-headers/185677/5 "2020-01-16T13:30:37Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![bcorrea](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/bcorrea/32/103778_2.png) [@bcorrea](https://forum.uipath.com/u/bcorrea)\
**Post date:** [January 16, 2020, 1:31pm UTC](https://forum.uipath.com/t/how-to-remove-datatable-headers/185677/6 "2020-01-16T13:31:21Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![sufyant](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sufyant/32/119310_2.png) [@sufyant](https://forum.uipath.com/u/sufyant)\
**Post date:** [January 16, 2020, 1:32pm UTC](https://forum.uipath.com/t/how-to-remove-datatable-headers/185677/7 "2020-01-16T13:32:12Z")

</div>

which way should I do?

---

<div class="post-metadata">

**Author:** ![bcorrea](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/bcorrea/32/103778_2.png) [@bcorrea](https://forum.uipath.com/u/bcorrea)\
**Post date:** [January 16, 2020, 1:33pm UTC](https://forum.uipath.com/t/how-to-remove-datatable-headers/185677/8 "2020-01-16T13:33:41Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![sufyant](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/sufyant/32/119310_2.png) [@sufyant](https://forum.uipath.com/u/sufyant)\
**Post date:** [January 16, 2020, 1:34pm UTC](https://forum.uipath.com/t/how-to-remove-datatable-headers/185677/9 "2020-01-16T13:34:40Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Pradeep\_Shiv](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/pradeep_shiv/32/496519_2.png) [@Pradeep\_Shiv](https://forum.uipath.com/u/Pradeep_Shiv)\
**Post date:** [January 16, 2020, 1:40pm UTC](https://forum.uipath.com/t/how-to-remove-datatable-headers/185677/10 "2020-01-16T13:40:05Z")

</div>

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**

---

<div class="post-metadata">

**Author:** ![bcorrea](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/bcorrea/32/103778_2.png) [@bcorrea](https://forum.uipath.com/u/bcorrea)\
**Post date:** [January 16, 2020, 1:45pm UTC](https://forum.uipath.com/t/how-to-remove-datatable-headers/185677/11 "2020-01-16T13:45:39Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![cmolina](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/cmolina/32/90945_2.png) [@cmolina](https://forum.uipath.com/u/cmolina)\
**Post date:** [January 16, 2020, 8:05pm UTC](https://forum.uipath.com/t/how-to-remove-datatable-headers/185677/12 "2020-01-16T20:05:15Z")

</div>

Hi,

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

> **text**.Substring( **text**.IndexOf(vbCrLf))

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/system/32/182466_2.png) [@system](https://forum.uipath.com/u/system)\
**Post date:** [January 19, 2020, 8:05pm UTC](https://forum.uipath.com/t/how-to-remove-datatable-headers/185677/13 "2020-01-19T20:05:16Z")

</div>

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