Skip to Content
Former Member
Jun 16, 2016 at 07:50 AM

Not able to export Data to excel


Hi Leads

I am trying to extract report from MII UI dashboard based on input parameters. After running report and extracting to excel, records are not fully getting exported. While running same query in database for extracting report it is giving all records.

Number of records in database 182660

Records exported to Excel 120001

Is there any limitation of excel to export certain number of records? Is there any work around for resolving the issue?

I am using below mentioned url to extract report to excel:

url =servername +"Illuminator?queryTemplate=QUALITY/QUA_I/QUERIES/SelectFilteredFromConfigurationList&Param.5="+escape(wherePart).replace(/\+/g,'%2B')+"&OutputParameter=ID_LIST&Content-Type=text/csv";;