topic Table box to excel. in QlikView

Table box to excel.

Wed, 12 Aug 2009 17:00:29 GMT

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.

Table box to excel.

ipauldur — Wed, 12 Aug 2009 19:21:31 GMT

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.

Table box to excel.

Wed, 12 Aug 2009 22:09:51 GMT

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.

Table box to excel.

Wed, 12 Aug 2009 22:42:32 GMT

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.

Table box to excel.

Thu, 13 Aug 2009 00:06:05 GMT

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.

Table box to excel.

Thu, 13 Aug 2009 15:44:12 GMT

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.