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