Export to xls.file

[gidon500]

Hi Guys

enclosed is a qlik doc with an export bottom

it creates xls file for the table

I want to export only part of the table

not  to include the first line and the first colomn

is it possible

thanks

gidon

[gidon500]

the export bottom apply a macro

[asgardd2 · Accepted solution]

The simplest way is after exporting into Excel to remove the first column and first row.

Add in your macro function Export four rows:

XLSheet.Rows("1:1").Select

XLApp.Selection.Delete -4162

XLSheet.Columns("A:A").Select

XLApp.Selection.Delete -4159

[gidon500]

Hi Anton

I will try that

thanks

gidon

[HirisH_V7]

Hi ,

Is there any way to do it with out macro!!

-Hirish

[HirisH_V7]

Hi,

This may help You out with out using macros,

http://market.qlik.com/cia-report-manager.html

Check this,

Hirish