topic Send to Excel doesn't work in QlikView

Send to Excel doesn't work

Tue, 06 Sep 2011 06:29:57 GMT

Hi,

I am having a problem with the function "Send to Excel" from an object in QV Desktop. After clicking "send to Excel" MS Notes is opening in .csv format instead of Excel. How can I export to Excel again (this was working all the time before)?

My user preferences for Export are:

Send to Excel doesn't work

Tue, 06 Sep 2011 07:02:24 GMT

hi,

Can you please check anything related to file association.

Can you check by double clicking on any of the existing excel file and see what happens?

Cheers.

Send to Excel doesn't work

Tue, 06 Sep 2011 07:14:46 GMT

Thank you for the hint.

The file association for *csv was wrong - I have now changed it to Excel and the function "send to Excel" is working again.

This link was helpful for changing the file association in Win7:

http://www.winvistaclub.com/t19.html

Send to Excel doesn't work

Tue, 20 Sep 2011 06:36:14 GMT

After changing the association for *csv files to Excel, Excel is at least starting after pressing the XL icon on a QV object. BUT, the Excel fil is still in a "csv" format. What do I have to configurate to have the Excel export in "Excel Workbook"?

Send to Excel doesn't work

Anonymous — Tue, 20 Sep 2011 06:44:41 GMT

Hi,

Go to the user prefferences (Ctrl +Alt + U) and see if your setting are like these below:

Hope this helps

Cheers!

isam

Send to Excel doesn't work

Tue, 20 Sep 2011 07:09:43 GMT

Yes my user prefferences are exacly like your image. The export is still in Excel with csv format.

Re: Send to Excel doesn't work

Anonymous — Tue, 20 Sep 2011 07:27:35 GMT

Hi There,

I haven’t found the solution jet. However if you right click on your qlikview object and choose export:

You should get a something like this:

Now choose Excel as file type.

Cheers!

Send to Excel doesn't work

Tue, 20 Sep 2011 08:49:35 GMT

For some strange reason... it's working again.

Re: Send to Excel doesn't work

Anonymous — Tue, 20 Sep 2011 08:52:36 GMT

Cool. I’m curious how to what the caused it :D. But it works so that’s what’s important!

Send to Excel doesn't work

Thu, 05 Jan 2012 22:40:17 GMT

I have just recently had a similar issue, but with the ajax client. On one user's machine and Firefox 8, clicking the 'XL' button on a straight table opens a new browser tab with the data and a .csv extension. Earlier in the day it was sending to excel as expected on this user's machine.

Tested on a different machine and also using Firefox 8 the same button on the same table exports to excel as expected.

I do not understand what circumstances cause that button to produce a .csv file instead of a .xls, but I would like to.

Re: Send to Excel doesn't work

Anonymous — Fri, 06 Jan 2012 07:45:57 GMT

Hi kevin,

Maybe a stupid question, but did you check whether excel has been set to default?

There wasn’t a ‘real’ solution to this problem, it just disappeared after a sometime.

Maybe you can download and install Open Office (Calc) <<is like excel, and set it up as default and see what happens. If Qlikview sends it data to Calc, then change the settings back to Excel.

Good Luck!

Cheers,

iSam

Re: Send to Excel doesn't work

Mon, 18 Jun 2012 09:33:50 GMT

How many records are you trying to export?

More than 65,536 records, will be exported as a .csv, because .xls (Excel 2003 format) can only handle 65,536 records.

Re: Send to Excel doesn't work

peterwh — Fri, 14 Sep 2012 10:29:50 GMT

Hello,

the number of records is 65499 where Qlikview is using .xls. If its 65500 and higher its .csv. I know these figures, cause I tested it, filed a bug report and QlikTech-Support told me, that this is a hardcoded number, even if you use Excel2010. They don't use 65536, because they use this 37 lines for other things.

Just my 2 cents

Peter

Re: Send to Excel doesn't work

marco_81 — Mon, 29 Oct 2012 13:54:31 GMT

We have the same Problem with the Ajax Client...

In the QV Desktop Edition and with the Internet Explorer Plugin the XLS Export is working fine with over 65xxx records, only the Ajax Client will open a new Browser Tab with the extension .csv... the Problem is that excel did not opend!

... did anyone find a solution for this Problem?! -Because we have some users with Mac and they only can use the Ajax Client and they have to export over 65.xxx records.