Loading...

Exporting an entire list to Excel from qListView?

Title

Exporting an entire list to Excel from qListView?

Description

Exporting an entire list to Excel from qListView?

Please wait...

Working with a list with over 11k items configured in qListView, Since the Default view of the WebPart is set to 50 items per page, when we export to Excel, it only exports the items from the currently loaded page (not from the entire list).

Also, the exporting process takes approx 1.5 minutes. However, when exporting directly from SharePoint list, entire list (11K records) takes approx 20 seconds.

Cause

The wrong WebPart is being used.

Resolution

Use the qExcelViewer web part to Export the entire list.

Also, use the Configuration Editor to change the Max Query Count value to a value greater than 11,000.

Defect ID

The wrong WebPart is being used.

Leave a Reply