topic ExportBiff exports 100 first rows only in QlikView

ExportBiff exports 100 first rows only

Mon, 08 Jun 2015 12:37:07 GMT

Hi Community.

Need some help with function ExportBiff. I'm using this function in macro with straight table, and found an issue, that it exports only first 100 rows from table (which containes 500 rows). How to fix this or where to change this limit? Any help would be appreciated.

Thank in advance.

Re: ExportBiff exports 100 first rows only

rubenmarin — Mon, 08 Jun 2015 12:45:51 GMT

Hi, I don't have that limit, using ExportBiff creates an xls with several thousands of rows, I also tried with a simple example:

Sub TEST

set obj = ActiveDocument.GetSheetObject("CH18")

obj.ExportBiff "C:\Temp\test.xls"

End sub

Created test.xls with 4180 rows. Check if the table you're exporting has a dimension limit or any other limit in the object itself.

Re: ExportBiff exports 100 first rows only

Mon, 08 Jun 2015 13:49:45 GMT

Thank a lot, Ruben. Really, I have complex expression as row count limit in chart , and it was the root cause of issue. Thanks for your time.