Skip to content
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

<p>The wrong WebPart is being used.</p>

Resolution

<p>Use the qExcelViewer web part to Export the entire list. </p> <p>Also, use the Configuration Editor to change the Max Query Count value to a value greater than 11,000.</p>

Defect ID

<p>The wrong WebPart is being used.</p>

Leave a Reply