How to add empty row(front) in data table?

Help Studio
, ,
1

i need to add empty row in datatable in the first row of the table

for example
aaa bbb ccc
1 2 3
4 5 6
7 8 9
2

Hi,

Can you try to use DataRowCollection.InsertAt method as the following?

image
image1197×840 46 KB

Sample
Sample20240307-2.zip (3.1 KB)

Regards,

3

Hi @domsmgtmeet22

FYI, Another Approach

dt.Rows.InsertAt(DT.NewRow(), 0)

image
image1541×812 46.5 KB

image
image823×661 22.8 KB

Sequence38.xaml (9.8 KB)

Hope it helps!!

4

before header insert row ???

5

Hi @domsmgtmeet22

Do you want to insert a row before header?

Regards

6

yes, i need header row in datatable

7

Hi @domsmgtmeet22

Input:
image

dt.Rows.InsertAt(DT.NewRow(), 0)

image
image1553×797 50.6 KB

Output:
image

Regards

8

example share your xls file

9

Hi @domsmgtmeet22

TIME.xlsx (9.4 KB)

Regards

10

where sequence file…

11

Hi @domsmgtmeet22

Sequence38.xaml (7.7 KB)
TIME.xlsx (8.6 KB)

Regards