Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Macro to copy table data without column names

Hi,

I have created a macro to export a number of QlikView tables to a predefined excel template. However I would like to export the table data only without the column names.

This is an example of the current copy and paste logic in the macro:

ActiveDocument.GetSheetObject("CH57").CopyTableToClipboard (true)
XLSheet.Paste XLSheet.Range("A22")


Can anyone advise me how to change this to exclude the column names?

1 Solution

Accepted Solutions
sgrice
Contributor II

Re: Macro to copy table data without column names

ActiveDocument.GetSheetObject("CH57").CopyTableToClipboard (false)

XLSheet.Paste XLSheet.Range("A22")

3 Replies
sgrice
Contributor II

Re: Macro to copy table data without column names

ActiveDocument.GetSheetObject("CH57").CopyTableToClipboard (false)

XLSheet.Paste XLSheet.Range("A22")

Not applicable

Re: Macro to copy table data without column names

Ahhh so simple, lets pretend I haven't been scratching my head for an hour 

Thanks

sgrice
Contributor II

Re: Macro to copy table data without column names

Here the APIguide app to help with macros

Community Browser