How to merge datatble cells for two columns or more

Help Activities
, ,
1

I have this link

Here I nees to capture this table

image
image1145×266 27.9 KB

After capturing the table into datatable when writting the datatble in excel, getting this output as follows

image
image833×152 16.5 KB

Please refer the attached excel for reference. USState.xls (21 KB)

I want to get the output as it is in the table showing on the webpage. Can anyone help with the solution.

Thanks,
Sourav

2

Please suggest some solution on this topic if possible.

3

Hi,

Basically, we can merge cells using Alt+H M C in Excel.

So the following sample might help you.

img20210826-2
img20210826-2384×785 28.1 KB

Sample20210826-2.zip (16.3 KB)

Note: Some selectors for excel might be needed tuning for your environment.

Regards,

1 Like
4

Thanks a lot for this work around. Is it possible to do this merge function from the datatable, and then we can write that formatted datatable into excel?

5

Hi,

Unfortunately, as DataTable is not worksheet, there is no concept of merge cell and format etc in DataTable. Probably we need to acheive it on excel worksheet.

Regards,

6

Thank you for the solution.

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.