Excel Export Formatting Issue

[#1]

Hi

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??

[vikasmahajan · Accepted solution]

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

[tresesco]

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.

[#4]

Hey Vikas,

Thanks Yaar it helped.

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

[#5]

Thanks tresesco.It worked !!