Datatable reading query

[supu123 (supriys)]

Hiii,

When extracting the table i m getting at the top as
column1,column2,…
sr.No,Case Number,…

I dont want column1 column2 at the top how do i remove it.

Thanks and Regards,
Supriya

[mhk15 (mehak)]

@supu123 check add header property.

[varunk (Varun Kumar)]

Hi @supu123,

While extracting from web you are getting right,that names column1 & column2.
You are writing data table to excel.Let me know

[supu123 (supriys)]

Hiii,

I don’t want to write it to excel i want to give it to a click activity but the problem is the cfirst it reads case number and not the link value due to column-1 in it
It considers column-1 as the header but the header is case number

Thanks and Regards,
Supriya

[varunk (Varun Kumar)]

Hi @supu123,

Then remove that from that text.

[supu123 (supriys)]

Hiii @varunk
I didn’t get u

Thanks and Regards,
Supriya

[varunk (Varun Kumar)]

Hi @supu123,

After getting data table from web you can write as you shown in message box right.
Write that in to text file & remove first line

[shubham (Shubham Dhoot)]

If you are using Data scraping activity to extract it, then while writing it to excel check the Add Header property in Write range Activity. It will remove 1st row from extracted data table.