Excel 2007 and PL

[jasbo]

One of my QueryReporter users has just upgraded to Excel 2007. Now she can no longer export files from QR to Excel. I gather that the new Excel files have a different extension than the familiar .xls. Is there a known fix for this? Thanks. --jrb

 

[Marco Kalter]

What exactly goes wrong?

 

[jasbo]

This is not something I can test because I use an older version of Excel. I asked the use that complained and I got this answer. You can tell me whether you need more information. She responded:

Well, it does work but Excel 2007 comes up in "compatible mode" which functions under the rules of the older version so if I have run a query of more than the limit of 65,536 rows, it only brings in that many rows.

 

[jasbo]

By way of further information.... I am able to use QueryReporter 3.1.0 to create a CSV file with the correct number of rows (140,000+ in this case). I do not have Excel2007, so I can only import the first 65,000 or so rows. I have asked my user to test importing this file into Excel2007. If that works, the question will become how to directly export from QR to Excel2007. -- jrb

 

[jasbo]

One last bit of information. She could import the .csv file without any issue. The issue is importing large selection sets without running into the 2^16 rows limitation in Excel2007, which should actually be able to deal with that limitation. -- jrb

 

[Marco Kalter]

The Query Reporter does indeed not use Excel 2007 format, and is limited to 65536 rows. This is on the list of enhancement requests.

 

[mimimimi]

i checked, it says The query results of a report can be exported to HTML, XML, CSV or TSV format. You can alternatively show the results directly in a Microsoft Excel spreadsheet.
looking forword to enhancement: qr from excel.
keep good work