Table box to excel.

[#1]

Hello Everyone,

What will happen if I have large number of records in the table box and I need to transfer in the excel sheet.. Is it possible to transfer the huge data in the same excel sheet but in different sheets.

[ipauldur]

Hi,

Yes, It is possible.

Qlikview automatically writes the data into next sheet with the same excel after reaching the 65536 rows in the first sheet.

Regards,

Durai.

[#3]

Hi,

I have written a macro to move the datas to excel.

/************************************************************/

Sub Test

Set obj = ActiveDocument.GetSheetObject("LB08")

Obj.ExportBiff "C:\test1.xls"

End sub

/************************************************************/

Can I control the number of rows to be moved to excel. Like first 1,00,000 in one excel (multiple sheets) and the next 1,00,000 in the next excel and so on. And also Is there a limit for the no. of sheets in one sheet when exported.

[#4]

Excel 2007 can have 1,048,576 rows, and the number of sheets is limited by available memory. I do not know about earlier versions.

I am wondering why you are wanting so much data in Excel. QlikView is FAR BETTER for analysis

The Copy to Excel icon on the table caption will only copy those rows you have selected.

If you look at the APIGuide.qvw file, on the Automation Examples Tab, select Class = TableBox and Member = GetCells. The example shown covers creating an object for a number of rows and columns. You will have to work out the detail for what you want.

[#5]

Hello Ivang,

I need to export the qlikview data (after some manipulation) to excel and in turn to the database. I am looking for an easy method to transfer the data to excel.

[#6]

Can I assume that you want to put this into Excel so you can use an Excel macro to update the database?

You can use similar functions in the QlikView macro editor. This reads a database... PLEASE be careful that you don't corrupt your data!!

dim conn
dim tlist

set conn = createobject("adodb.connection")
conn.open "dsn=MyData;uid=myuser;password=mypassword;"

set tlist = createobject("adodb.recordset")
tlist.cursorlocation = 3
tlist.open "select * from mytable", conn, 3, 3

dim table_list
tlist.movefirst
while not tlist.eof
table_list = table_list & tlist.Fields(0) & vbcr 'Carriage return
tlist.movenext
wend
msgbox table_list

tlist.close
conn.close

You can also use a macro or report to write QlikView data to a text file, but it depends on what you want to do.