How to export table row span value to merge in export to Excel/PDF file?
How to export table row span value to merge in export to Excel/PDF file?
sudarshanj
Posts: 3Questions: 1Answers: 0
Hi Team,
As I am new to this I would like to know some inputs regarding to Data Table export to excel/PDF functionality. Need to know about export table row span data value with cell merge into Excel and PDF.
This question has an accepted answers - jump to answer
This discussion has been closed.
Answers
Do you mean
rowspanattributes? DataTables does not supportrowspanin the table body I'm afraid.Allan
Thank You Allan
How hidden table data (<td style="display: none;"> tag ) will be considered as merge cell in Data table export to xls/pdf.
E.g.
<tbody><tr role="row" class="odd"><td class="sorting_1" rowspan="2">test 1</td><td>test image assessment</td><td>2</td><td>100</td><td rowspan="2" class="sorting_2">140.91</td></tr><tr role="row" class="even"><td class="sorting_1" style="display: none;">New Batch 30 April</td><td>Test01</td><td>1</td><td>81.82</td><td style="display: none;" class="sorting_2">140.91</td></tr></tbody>
No - it would just be considered as a regular cell.
If you want to exclude certain columns from the export, see this example.
Allan
Thank you Allan for quick response
Hi Team,
I would like to know some inputs regarding to Data Table export to excel/PDF functionality. Need to know about export table column data value with specific cell merge (colspan in specific cell in a table) into Excel and PDF.
@Uzair_Shamsi - please don't duplicate threads.