How to Add two rows with merged cells in top of the Excel using DocumentFormat.OpenXml

Question

Hi All
I have implemented the code to create Excel from data table using DocumentFormat.OpenXml and it was working fine. But I want to add two rows in the excel top with merged cells (Ref Image) which contains the Title of the sheet with some additional information. After this two lines my table should show. Any leads to help me to solve this?

In this image. First two rows I have to create and my data table should start with 3 rd row.

Thanks in advance
Jo

Answer 1

Hi @Elaya Raja ,

But I want to add two rows in the excel top with merged cells (Ref Image) which contains the Title of the sheet with some additional information. After this two lines my table should show. Any leads to help me to solve this?

You can use the MergeCells and MergeCell classes to create the merged cells you require, then insert the row at the first and second row. To populate data in the merged cells you need to add the value to the upper left most cell; any other values will be ignored.

Refer the following sample code: 211531-sourcecode.txt

The generated excel file looks like this:

And, if append the table data, the result like this:

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Best regards,
Dillion