After the iview table component uses the grouping header, can only the children part be exported when exporting?

problem description

during this period of time, the project uses vue+iview to develop the front end, and now you will use the table component of view and its export cvs table function. The type of
header that has merged cells works well with grouping headers on the page.

cvs

there are all kinds of solutions on the Internet, but there are no good answers. Come here and ask if there is a good solution

.

related codes

/ / Please paste the code text below (do not replace the code with pictures)

what result do you expect? What is the error message actually seen?

Jan.13,2022

after reading this export source code, excel is exported in csv format, and it should be troublesome for csv to merge cells.
I recently encountered this requirement, which is to take apart the merged cells and finally disassemble multiple row headers into one row. The number of columns is equal to the number of body data columns, similar to:

.
          TITLE
    t1            t2

Export becomes:

  TITLE(t1)  TITLE(t2)

temporarily imperfectly meet the demand;

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1bdc2a4-312da.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1bdc2a4-312da.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?