Export Report to Excel

[#1]

In QlikView I want to export the chart to excel and it has more rows in it like greater than 65000, which excel cannot store.  What would be the way to export the report with lot of data.

[#2]

Hi sateesh ... i am faceing the same issue i am able to export  more than 100,000 rows to excel using IE Plugin  but with Ajax I am able to export only 65,000 rows. 

and what plug-in you are useing ?

[siddharth_kulka]

Sateesh,

Excel 2003 doesnot store >65000 in a single sheet, but records>65000 should be seen in the next sheet

Excel 2007 & above stores upto a Million records

What version are you using and what is the issue?

Regards,

Siddharth

[#4]

Siddharth

Thanks for the reply. I think its 2003 and I will confirm that.  But looks like >65000 stores in next sheet.  I have to check that too.

I have another requirement in which client want to use QlikView for reporting.  Sources are 3 CSV files and using QlikView they want to export the data into an single excel file with three CSV data in three separate tabs.

Is that possible, let me say again 3 CSV files into one Excel file in three individual tabs.

Thanks

[#5]

Ganesh

Looks like the Excel version. As Siddharth said Excel 2007 will resolve the issue.

[siddharth_kulka]

When you load 3 csv files in QV, 3 tables will be created. If the fields are same, 1 table will be created.

If there are 3 tables in QV, 3 xls or csv files can be created by exporting.

If there is 1 table in QV, a single xls or csv  can be created by exporting.

Mention the no of final tables in QV and the objects that you are using to export to excel

[#7]

This is just a requirement and didnt get any info abt no of table and the object using to export to excel.

Lets say we have three different table, so can it be stored in one excel sheet with three different tabs.

And another thing, is there a way to export data from QV other than excel.

[siddharth_kulka]

In a nutshell, you will need to use macros to achieve that you have mentioned.

You can export to PDF, other than excel.

[#9]

Great.  But how do we export to PDF as I dont see an option in charts.

Thanks!

[siddharth_kulka]

You need to have PDF Writer(QV Downloads) installed + Macros to execute.

There are other 3rd party softwares like CutePDF available as well!