Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to Script Macro to Format Excel Export

I am trying to script a macro to format my excel document that I am exporting.

Where can I get some script on formatting, for example:

Center Align

COlour Cells

Draw Borders

etc

Rgds

3 Replies
Not applicable

Re: How to Script Macro to Format Excel Export

Why would you not format using the dialog boxes or design mode within qlikview? Is this a special need for additional formatting?

Also I would suggest having a module within excel to run the formatting you want after it has exported. QlikView from what I heard is eventually doing away with VB, but that might just be hearsay

Excel Marco Code - Record type VB

With Range("A1:C1")
   
.HorizontalAlignment = xlCenter
   
.Font.Italic = True
   
.Font.Bold = True
   
.EntireColumn.ColumnWidth = 15
End With

mwoolf
Honored Contributor II

Re: How to Script Macro to Format Excel Export

Just record a macro for each feature and then look at the recorded vba code

Not applicable

Re: How to Script Macro to Format Excel Export

Have tried that however not all of them work. Got most of them done that way