Exporting to EXCEL

[Anonymous]

Dear folks,

if i export 5 crores records from my qlikview document to excel..what ll happen?? is it possible to export crores records to excel...

Sorry if i asked a stupid question(i faced this question in interview)

Thanks in Advance.

[ecolomer]

Yes you can expot to excel

[Anonymous]

Thanks for the reply......actually i just want to know the limit of records we can transport to excel.....

[ThornOfCrowns]

65,000 or 1,048,576 depending on your version of Excel.

[Anonymous]

thank u.... mine is ms office 2013 and what ll happen exactly if i try to export more than its limit???

[ashfaq_haseeb]

Then it will support 1,048,576

If you export as csv it will hold many values.

Provided you need to have enough ram.

Regards

ASHFAQ

[Anonymous]

thanks Ashfaq..... what error will come if i try with 2 million records  to export?

[ashfaq_haseeb · Accepted solution]

No Errors,

If you have don't have enough ram to handle this them your commuter may consume more ram and become unresponsive.

Regards

ASHFAQ