SpreadJS provides an option to specify which headers are included when data is copied or pasted.
Just set the workbook copyPasteHeaderOptions option to specify which headers are included. For example:
workbook.options.copyPasteHeaderOptions = GC.Spread.Sheets.CopyPasteHeaderOptions.allHeaders
Spread.Sheets supports copying multiple non-contiguous cells then pasting to a single range. The following cases are supported:
Spread.Sheets ignores filtered rows when copying.
Select an option from the drop-down, then select full rows or columns on the worksheet, such as 'FRI' column or '8:00' row, then copy and paste.