topic Re: Export to xls.file in QlikView

Export to xls.file

gidon500 — Sun, 17 Jan 2016 19:02:20 GMT

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 — Sun, 17 Jan 2016 19:02:52 GMT

the export bottom apply a macro

asgardd2 — Mon, 18 Jan 2016 07:43:15 GMT

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 — Mon, 18 Jan 2016 09:38:49 GMT

Hi Anton

I will try that

thanks

gidon

HirisH_V7 — Mon, 18 Jan 2016 09:48:12 GMT

Hi ,

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

-Hirish

HirisH_V7 — Mon, 18 Jan 2016 10:01:40 GMT

Hi,

This may help You out with out using macros,

Check this,

Hirish