filter report and export it in xlsx in aura component

Question

i want to filter a report and export it to xlsx when the user click on a button as in lightning component, i use a link like this but it don't work: String url = baseUrl + '.lightning.force.com/lightning/r/Report/'+ reportId+ '/view?fv0=' + userKey + '&xlsx=1&exp=1&enc=UTF-8&isdtp=p1'; It just filter the report but don't export it. Can someone help me? Thanks

Answer 1

Could you please try following.

String url = baseUrl + '.lightning.force.com/servlet/PrintableViewDownloadServlet?isdtp=p1&reportId='+reportId;