Hello,

I have a datatable

suppose like

A B C D

1 2 3 4

5 6 7 8

Now I have to write it in excel like

Header1 Header2 Header3

A:1 2 4

C:3 2 4

A:5 6 8

C:7 6 8

There by one line in my datatable is creating two rows in excel?

Can anyone can suggest any solution to how to do that?

# How to write 1 data table row into 2 lines of excel

I am sorry I did not get your problem here. But you can access the elements from data table like this

row(“ColumnName”).ToString or DataTable.Rows(RowIndex)(ColumnIndex).ToString

By doing this you can easily write a cell or an excel row even

I can access the elements but my doubt is with single row of data table I want to create 2 rows in excel.

| **A** | **B** | **C** | **D** |

…

| 1 | 2 | 3 | 4 |

…

| 5 | 6 | 7 | 8 |

…

Suppose lets consider A B C D are headers of my data table and above shown is my datatable Table1

I want it to be written in excel in 2 rows

i.e…

| H1 | H2 | H3 |

…

| A:1 | 2 | 4 |

…

| C:3 | 2 | 4 |

…

| A:5 | 6 | 8 |

…

| C:7 | 6 | 8 |

…

Under same header1 H1 I need A and C of my datatable in different rows and B and D are common in both rows.