How to format data into excel?

Fri, 26 Sep 2014 14:13:42 GMT

Hi,

I have a excel file with data as in attached input. I need to format the data which is shown in attached output excel file. can anyone suggest me whether would it be possible with qvw?

Thanks.

Re: How to format data into excel?

MarcoWedel — Fri, 26 Sep 2014 14:17:04 GMT

attachment missing

regards

Marco

Re: How to format data into excel?

Fri, 26 Sep 2014 14:17:22 GMT

Please see attached.

Re: How to format data into excel?

Anonymous — Fri, 26 Sep 2014 19:10:02 GMT

FUNCTION ExcelExport(objID)

set obj = ActiveDocument.GetSheetObject( objID )

w = obj.GetColumnCount

if obj.GetRowCount>1001 then h=1000 else h=obj.GetRowCount end if

Set objExcel = CreateObject("Excel.Application")

objExcel.Workbooks.Add

objExcel.Worksheets(1).select()

objExcel.Visible = True

set CellMatrix = obj.GetCells2(0,0,w,h)

column = 1

for cc=0 to w-1

objExcel.Cells(1,column).Value = CellMatrix(0)(cc).Text

objExcel.Cells(1,column).EntireRow.Font.Bold = True

column = column +1

c = 1

r =2

for RowIter=1 to h-1

for ColIter=0 to w-1

objExcel.Cells(r,c).Value = CellMatrix(RowIter)(ColIter).Text

c = c +1

r = r+1

c = 1

END FUNCTION

SUB CallExample ExcelExport( "CH01" )

END SUB

VB Macro to Loop Field (Dynamic) and Export Chart (Dynamic) to Excel & Name Sheets by Field Value

Useful Qlikview Macros

QlikView automation by external VBScript scripts

topic Re: How to format data into excel? in QlikView

How to format data into excel?

Re: How to format data into excel?

Re: How to format data into excel?

Re: How to format data into excel?