topic Re: Excel Export Formatting Issue in QlikView

Excel Export Formatting Issue

Wed, 04 Sep 2013 11:51:20 GMT

This is how my qlikview chart(straight table) looks like.

I am writing a MACRO to transpose and export to excel.This is the code :

So i get the following output on button click event :

But the Expressions label alignment is centre.But in the Qlikview Straight table in the fig1 its left aligned.

All the data are properly populated with the correct format except for the expressions label.

Any idea on how to solve this alignment issue??

Re: Excel Export Formatting Issue

vikasmahajan — Wed, 04 Sep 2013 11:54:37 GMT

Add following code and check

'********* Format Excel **************

Set Selection = XLSheet.Cells

With Selection

.VerticalAlignment = 1

.WrapText = True

.Borders.ColorIndex = 0

.ColumnWidth = 11

'When the export finishes we display the below message:

'MSGBOX "Export Complete!",VbInformation

End With

Hope this helps you.

Vikas

Re: Excel Export Formatting Issue

tresB — Wed, 04 Sep 2013 11:57:24 GMT

See if this helps:

Columns("A:A").Select

    With Selection

       .HorizontalAlignment = xlLeft

        .VerticalAlignment = xlBottom

        .WrapText = False

        .Orientation = 0

        .AddIndent = False

        .IndentLevel = 0

        .ShrinkToFit = False

        .ReadingOrder = xlContext

        .MergeCells = False

    End With

Modify accordingly.

Re: Excel Export Formatting Issue

Wed, 04 Sep 2013 12:17:11 GMT

Hey Vikas,

Thanks Yaar it helped.

But any idea how to Autofit row/Column based on the data??

Re: Excel Export Formatting Issue

Wed, 04 Sep 2013 12:20:02 GMT

Thanks tresesco.It worked !!